Senior Data Analyst - Business Intelligence Developer
We are seeking an experienced Power BI Engineer with a strong SQL background to design, build, and maintain robust reporting solutions. The ideal candidate will have a proven ability to develop semantic data models, craft efficient SQL queries, ensure data quality through Power Query transformations, design intuitive dashboards using advanced Power BI visualizations and DAX measures, and establish proper security protocols.
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
* 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).
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.
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.
Requirements:
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.
Language:
* C1 English Proficiency Required.
Benefits:
* Competitive Salary
* Company Provided Computer
* Stock Options
* Flexible PTO
],