Senior Power BI Engineer

Summary

A Senior Power BI Engineer for Analysis Services focuses on building and maintaining the infrastructure necessary for data collection, storage, and processing. They are responsible for performing planning, design, and development of organizations for Power BI Business Intelligence applications, reports, and dashboards. Provide expertise and support in reporting systems, Azure Analysis Services, Azure Synapse Workspace Analytics, Power BI and data access.

They work with other teams and users to ensure solutions meet all business needs.

• Semantic Modeling & Analysis Services (AAS): develop tabular and multidimensional models, manage AAS process, write complex queries to retrieve large data from a database, analyze root cause and troubleshoot data warehouse and reporting system issues.
• Reporting & Insights Delivery: develop visual reports and dashboards with filters, variables, and drill‑down capabilities; use Power BI to build visualizations and dynamic reports that facilitate end‑user understanding; design, develop, and test operational, strategic, and federally mandated reports for internal and external stakeholders, leadership, CMS, and steering committees.
• Data Integration, Automation & Reliability: integrate data from on‑premises and cloud‑based sources, automate outputs to refresh on a scheduled basis, design and maintain reliable data processing workflows, design scalable solutions for growing data volumes and user demands, optimize data architectures for performance and scalability.
• Security, Governance & Data Quality: implement and maintain security measures (role‑based access control and data encryption), establish and enforce data governance policies and practices, govern system and data integrity analysis, analyze and troubleshoot data issues and propose effective solutions.
• User Enablement, Support & Documentation: provide Power BI and AAS user support around connectivity, access, and control; provide training on Power BI data sets and cubes; answer technical and procedural questions; create and maintain technical documentation; work with other teams to analyze and resolve Power BI or AAS issues; work with the data warehouse team to build ETL stored procedures and design data warehouse architectures;
  
  collaborate with Data Architecture team and data warehouse team to design scalable, secure, high‑performance architectures across multiple cloud environments; other duties as assigned.

• 5+ years with advanced Azure Analysis Services and Power BI, advanced SQL.
• 3+ years of experience working with Azure Data Warehouse.
• 3+ years of mentoring experience.
• Experience with data warehouse requirements and design.
• Advanced knowledge and experience in data mining large database systems and technical documentation.
• Well organized, flexible, proactive, resourceful, efficient with strong attention to detail.

• Motivated self‑starter with initiative to take independent action and accept responsibility.
• Strong interpersonal skills; ability to work with all levels of internal management and staff, as well as outside clients, vendors, diverse populations, stakeholder groups, and customers.

Benefits information available on request.

• Core business hours 8:00 a.m. to 5:00 p.m., Monday through Friday; occasional irregular hours may be required.
• Preferred duty station:
  Olympia, Washington headquarters; hybrid remote and on‑site schedule may be considered.
• Limited travel requirements; may occasionally be required.
• Duties require use of standard office furniture and equipment; employee responsible for maintaining safe, ergonomic, secure workspace at remote location.
• Reasonable accommodations can be provided for individuals with disabilities.

• Criminal background screen conducted for candidates under final consideration and for those hired, every five years of employment when highly sensitive data is processed or maintained; background screen results must meet Exchange eligibility standards.

This Washington Health Benefit Exchange is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, marital status, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. We participate in E-Verify. The Department of Justice's Right to Work poster is available.