**Reporting Solutions Engineer Position Summary**
* We are seeking an experienced Power BI developer with a strong SQL background to design, build, and maintain robust reporting solutions.
Data Modeling & Querying Responsibilities:
* 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 Responsibilities:
* 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 Responsibilities:
* 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 Responsibilities:
* 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 Responsibilities:
* 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 Responsibilities:
* 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 Responsibilities:
* 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:
* 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.