We are seeking an experienced data professional to join our team as a Power BI Engineer. This role involves designing, building, and maintaining robust reporting solutions using Power BI.
The ideal candidate will have a strong background in SQL, including complex joins, stored procedures, and performance tuning. Experience with data modeling, Power Query, and DAX is also required.
Key Responsibilities:
* 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.
* ETL & Data Transformations
Design and build interactive, user-friendly Power BI dashboards and reports that convey insights effectively. Develop, optimize, and maintain DAX calculations, measures, and KPIs.
* 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.
* 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.
* 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.
* 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.
Qualifications:
* Experience:
* 3+ years of professional experience with Power BI development, including data modeling, Power Query, and DAX.
* Strong SQL proficiency, including complex joins, stored procedures, and performance tuning.
* Technical Skills:
* Power BI: Data modeling, DAX, Power Query M.
* SQL: SQL, query optimization, data warehousing concepts.
* ETL Tools & Processes: Understanding of data pipelines, transformations, and integration.
* Version Control (e.g., Git) and CI/CD pipelines for BI solutions (a plus).
* Familiarity with Row-Level Security and other Power BI security features.
* Experience with Azure Data Services (e.g., Azure Synapse, Azure Analysis Services) is a plus.
Soft Skills:
* Strong communication skills to collaborate with stakeholders and translate technical findings into actionable insights.
* Adaptable team player who can work in an agile environment.
* Proven problem-solving skills and high attention to detail.
A competitive salary package, company-provided computer, stock options, and flexible PTO are available for this role.