Data Engineer
Job Description:
Client Introduction:
In this role, you will have the opportunity to work closely with one of our esteemed clients. This client is a global leader in the Real Estate industry, known for its commitment to quality and innovation. They have chosen Dautom as their trusted partner for their upcoming projects.
Job Title: Data Engineer
Job Purpose:
As a Data Engineer specializing in Power BI dashboard development, your primary responsibility will be to design, develop, and maintain visually compelling and user-friendly Power BI dashboards. You will play a pivotal role in translating complex business requirements into actionable insights, ensuring the effective communication of data-driven narratives to key stakeholders. Also an understanding of data modelling, design, and development of the batch and real-time extraction, load, transform (ELT) processes, and the setup of the data integration framework.
Key Responsibilities:
- Deep understanding of complex DAX queries and calculations
- Deep knowledge and understanding of Data modelling and Semantic layer
- Collaborate with cross-functional teams to understand data requirements and design Power BI solutions that meet business needs.
- Develop and maintain robust ETL processes to transform and load data into Power BI for efficient reporting and analytics.
- Create visually appealing and intuitive dashboards using Power BI, ensuring a seamless user experience.
- Implement best practices for data visualization and maintain a high standard of UI/UX in all dashboard development.
- Optimize and troubleshoot Power BI reports and dashboards for performance and usability.
- Stay current with industry trends and advancements in Power BI to continually enhance our reporting capabilities.
- Work closely with data scientists, analysts, and business stakeholders to gather requirements and deliver actionable insights.
- Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and big data technologies.
- Design a data warehouse data model based on the business requirements.
- Design, develop, and test both batch and real-time Extract, Load and Transform (ELT) processes required for the data integration.
- Optimize ELT processes to ensure execution time is meeting the requirements.
- Manage Ingest of both structured and unstructured data into data lake/data warehouse system.
- Assess the data quality of the source systems and propose required enhancements to achieve a satisfying level of data accuracy.
- Process, cleanse, and verify the integrity of data used for different business analyses.
- Create automated data quality detection systems and constant tracking of its performance.
- Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency, and other key business performance metrics.
- Work as part of the analytics team on many initiatives with the different departments within the company. Collaborative problem solving, sophisticated design, and the creation of quality products is essential.
QUALIFICATIONS & EXPERIENCE:
Minimum Qualification
- Bachelors degree in Computer Science, Information Technology, or a related field. Masters degree is preferred.
Minimum Experience
- 3+ years of experience in Data Engineering (PowerBI Reporting).
- Power BI certification is a plus.
- Dashboard Design and Development
- Experience with other BI tools and technologies.
- Familiarity with cloud platforms such as Azure or AWS.
- Knowledge of SQL, Azure Data Factory, Data Bricks, MS Synapse, Python, or other relevant Tools (Informatica, Data Services, etc.) is a plus.
Benefits and Perks:
- Competitive salary and bonus structure.
- Comprehensive health and wellness benefits.
- Opportunities for professional development and growth.
- Flexible work arrangements, including remote work options.
- Employee recognition programs and a collaborative team environment.
Required Skills:
Informatica Performance Metrics Wellness Bonus Data Quality Analysts Usability Operational Efficiency Options Visualization Big Data User Experience Dashboard Calculations Data Visualization Load Real Estate Salary Metrics Business Requirements Problem Solving Power BI Analytics Infrastructure Integration Information Technology Computer Science Python SQL Design Engineering Communication Business Science