Data Engineer for Advanced Analytics
We are seeking an experienced Data Engineer to design, build, and maintain robust reporting solutions using Power BI. The ideal candidate will have a strong SQL background and a proven ability to develop semantic data models, craft efficient SQL queries, ensure data quality through Power Query transformations, and establish proper security protocols.
Key Responsibilities:
1. Data Modeling & Querying
* Develop and maintain data models (star/snowflake schema) in Power BI, leveraging advanced SQL queries.
* Create semantic models that accurately represent business logic and support optimal report performance.
2. ETL & Data Transformations
* Utilize Power Query for data shaping, cleaning, and transformation, ensuring data integrity and consistency.
* Collaborate with data engineering teams to integrate various data sources (e.g., relational databases, APIs, CSV files).
3. Report & Dashboard Development
* Design and build interactive, user-friendly Power BI dashboards and reports that convey insights effectively.
* Develop, optimize, and maintain DAX calculations, measures, and KPIs.
4. Security & Governance
* Implement Row-Level Security (RLS) or other relevant Power BI security features to protect sensitive data.
* Work with management teams to ensure adherence to data governance and regulatory requirements.
5. Performance Tuning & Troubleshooting
* Optimize Power BI data models, queries, and measures for performance and scalability.
* Diagnose and resolve report rendering and data refresh performance issues.
6. Collaboration & Stakeholder Engagement
* Partner with business stakeholders to gather requirements and deliver actionable reports and insights.
* Provide training, documentation, and support to end-users and other internal teams.
7. Continuous Improvement
* Stay current with emerging Power BI capabilities, DAX best practices, SQL performance enhancements, and analytics trends.
* Contribute to the development of best practices for analytics, data governance, and solution design.