Power BI Architect
About The Position
This role is responsible for leading the design and development of enterprise-grade semantic models to support self-service analytics in Power BI. The position partners closely with Data Architects, ETL teams, and business stakeholders to deliver scalable, secure, and high-performing BI solutions. The role plays a key part in the organization’s migration from Cognos to Power BI. This opportunity offers the chance to contribute at an early stage of the organization’s migration to Power BI, providing exposure to enterprise-scale analytics transformation and long-term growth potential in a contract-to-hire capacity.
Requirements
- 5 or more years of experience in BI architecture and data engineering, with 10 or more years of overall IT experience.
- Expert-level proficiency in Power BI, including DAX, Power Query, advanced data modeling techniques, and Fabric capacities.
- Expert-level proficiency in relational databases and SQL, including Oracle, PostgreSQL, MySQL, SQL Server, and Redshift.
Nice To Haves
- Strong communication skills with the ability to present technical concepts clearly to business and technical audiences.
Responsibilities
- Architect, design, and develop scalable, enterprise-grade semantic models for self-service Power BI analytics.
- Partner with Data Architects and ETL teams to ingest, transform, and prepare large and complex semantic models for analytics consumption.
- Implement and manage data governance, access controls, and security policies.
- Collaborate with business stakeholders to gather analytical requirements and translate them into effective BI and reporting solutions.
- Ensure optimal Power BI report and dataset performance through efficient data modeling, DAX optimization, and query tuning best practices.
- Monitor Power BI workspaces and Fabric capacities to ensure solutions are efficient and performant.
- Troubleshoot reports and dashboards that do not render quickly or meet performance expectations.
- Establish and enforce standards, guidelines, and best practices for Power BI development across the organization.
- Lead initiatives related to metadata management, data lineage, documentation, and data quality assurance.
- Provide technical leadership and mentorship to IT staff and business users.
- Support enterprise reporting strategies with a focus on scalability, reliability, and consistency across analytics platforms.
Benefits
- Medical, dental & vision
- Critical Illness, Accident, and Hospital
- 401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available
- Life Insurance (Voluntary Life & AD&D for the employee and dependents)
- Short and long-term disability
- Health Spending Account (HSA)
- Transportation benefits
- Employee Assistance Program
- Time Off/Leave (PTO, Vacation or Sick Leave)
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
