Senior Power BI Engineer

Washington Health Benef•Olympia, WA

1d•$103,334 - $112,319•Hybrid

About The Position

The mission of Washington Health Benefit Exchange (Exchange) is to radically improve how Washington residents secure health insurance through innovative and practical solutions, an easy-to-use customer experience, our values of integrity, respect, equity and transparency, and by providing undeniable value to the health care community. The Exchange is a public-private partnership that operates Washington Healthplanfinder, the eligibility and enrollment portal used by one in four Washington residents to obtain health and dental coverage. Through this platform, and with support from a Customer Support Center and statewide network of in-person navigators and brokers, individuals and families can shop, compare and enroll in private, qualified health plans (as defined in the Affordable Care Act) or enroll in Washington Apple Health, the state Medicaid program. The Exchange embraces the following equity statement adopted by our Board of Directors: Equity is fundamental to the mission of the Washington Health Benefit Exchange. The process of advancing toward equity and becoming anti-racist is disruptive and demands vigilance to dismantle deeply entrenched systems of privilege and oppression. While systemic racism is a root cause of many societal inequities, we must also use an intersectional approach to address all forms of bias and oppression, which interact with and often exacerbate racial inequities. To be successful, we must recognize the socioeconomic drivers of health and focus on people and places where needs are greatest. As we listen to community, we must hold ourselves accountable to responding to recommendations to remedy inequitable policies, systems, or practices within the Exchange s area of influence. Our goal is that all Washingtonians have full and equal access to opportunities, power and resources to achieve their full potential. 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.

Requirements

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

Nice To Haves

Motivated self-starter with initiative to take independent action and accept responsibility for your actions.
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.

Responsibilities

Develop tabular models and multidimensional models
Develop and manage AAS process
Writing complex query to retrieve large data in a database
Analyze to find root cause and troubleshoot DW and reporting system issues
Develop visual reports and dashboards that have filters, variables and drill down capabilities
Using Power BI to build visualizations and dynamic reports that facilitate end user’s understanding of their stories through data.
Design, develop, and test operational, strategic, and federally mandated reports. This supports internal and external stakeholders, leadership, CMS, and steering committees. Development uses Azure SQL Developer, Power BI and AAS
Develop clear and well-structured analytical plans. Build and analyze large datasets which include, HPF, Medicaid and other external data
Conduct the conversion of data into insights that will lead to informed business decisions.
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 solutions that are scalable to handle growing data volumes and user demands
Implement solutions that handle increasing data volumes and user demands
Optimize data architectures for performance and scalability
Implement and maintain security measures, including role-based access control and data encryption
Establish and enforce data governance policies and practices within team
Govern system and data integrity analysis to control and manage data and report quality
Analyze and troubleshoot data issues and provide detailed analysis and propose effective solutions and downstream impact.
Provide PBI and AAS users support around connectivity, access and control
Provide training on PBI data set and cubes
Answer technical and procedural questions for team members and facilitate development and training of improved processes
Create and maintain technical documentation for development and operational purposes
Work with other teams’ members to analyze and resolve any PBI or AAS issue
Work with DW team to develop scrip to build ETL store procedures
Collaborate with Data Architecture team and DW team to design data DW architectures that support scalability, security, and performance spanning multiple cloud environments.
Other duties as assigned.