Power BI Data Architect
\
We are seeking an experienced Power BI professional to join our team. The ideal candidate will have a strong background in data modeling, SQL, and DAX.
\
This role will involve designing, building, and maintaining robust reporting solutions using Power BI. The successful 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
\
\
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
\
* 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.
\
Benefits
\
* Competitive salary
* Company-provided computer
* Stock options
* Flexible PTO