As a highly skilled Power BI Engineer, you will play a pivotal role in designing and building robust reporting solutions that propel our organization forward.
Key Responsibilities:
Data Modeling & Querying
* Develop and maintain data models (star/snowflake schema) in Power BI, leveraging advanced SQL queries to ensure optimal report performance.
* Create semantic models that accurately represent business logic and support effective data analysis.
ETL & Data Transformations
* Utilize Power Query for data shaping, cleaning, and transformation, ensuring data integrity and consistency across various sources.
* Collaborate with cross-functional teams to integrate relational databases, APIs, and CSV files into the data pipeline.
Report & Dashboard Development
* Design and build interactive, user-friendly Power BI dashboards and reports that effectively convey insights and drive business decisions.
* Develop, optimize, and maintain DAX calculations, measures, and KPIs to support data-driven decision-making.
Security & Governance
* Implement Row-Level Security (RLS) or other relevant Power BI security features to protect sensitive data and ensure compliance.
* Collaborate with management teams to establish and maintain data governance and regulatory requirements.
Performance Tuning & Troubleshooting
* Optimize Power BI data models, queries, and measures for performance and scalability to ensure seamless report rendering and data refresh.
* Detect and resolve report rendering and data refresh performance issues to minimize downtime and maximize productivity.
Collaboration & Stakeholder Engagement
* Partner with business stakeholders to gather requirements and deliver actionable reports and insights that drive business growth.
* Provide training, documentation, and support to end-users and internal teams to ensure seamless adoption and utilization of Power BI solutions.
Qualifications:
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
Benefits:
* Competitive Salary
* Company Provided Computer
* Stock Options
* Flexible PTO
Requirements:
* 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
* C1 English Proficiency Required
],