Business Intelligence developer with Power BI - Remote

About the position Optum Insight is improving the flow of health data and information to create a more connected system. We remove friction and drive alignment between care providers and payers, and ultimately consumers. Our deep expertise in the industry and innovative technology empower us to help organizations reduce costs while improving risk management, quality and revenue growth. Ready to help us deliver results that improve lives? Join us to start Caring. Connecting. Growing together. Optum State Gov operates under Optum Insight, focusing primarily on supporting state Medicaid agencies through long-term contracts, including managing enterprise data warehouses and analytics for states like Connecticut and New Jersey. This group focuses on enterprise data warehouses and analytics for state agencies, specifically mentioning their current work for the state of Connecticut, which involves building dashboards, analytics, and reports for the Department of Health and Human Services. You’ll enjoy the flexibility to work remotely from anywhere within the U.S. as you take on some tough challenges. For all hires in the Minneapolis or Washington, D.C. area, you will be required to work in the office a minimum of four days per week. You’ll be rewarded and recognized for your performance in an environment that will challenge you and give you clear direction on what it takes to succeed in your role as well as provide development for other roles you may be interested in.

Responsibilities

• Act as a Business Intelligence technical subject matter expert (SME), responsible for the work associated in designing, developing, testing, maintaining and improving analytic reports and dashboards
• Responsible for the ongoing operational stability of the reporting environment, ensuring objects are properly monitored and audited to provide data integrity, accuracy and timeliness of delivery
• Work with the team to mockup the new reports and dashboards and determine the most elegant way to provide data to customers
• Collaborate with team members (business analysts, database engineers and managers) with diverse and varied technical skills sets to design and develop customer specific reports
• Ability to design and develop complicated reports including sub-reports, graphical reports, and well-formatted reports according to user requirements
• Ability to collaborate with customer to suggest additional information and enhancements to report requests
• Develop dashboards that tell a compelling story
• Exhibit a commitment to data quality by validating results compared with the data warehouse database at each step of the development process
• Participant in Agile development methodology; ability to write user stories with measurable results (acceptance criteria); attend daily stand up meetings and participation in retrospective and planning meetings
• Work daily within a project team environment, taking direction from project management and technical leaders

Requirements

• 10+ years of production level experience working with data, business intelligence toolsets and Microsoft Power BI, Tableau
• 7+ years of data warehouse analysis experience, ability to read Data Flow Diagrams, Conceptual and Physical Models
• 5+ years of PowerBI experience leveraging PowerBI Desktop DAX, Power Query
• 5+ years of experience writing SQL used in report customizations
• 5+ years of building analytical dashboard and reports in the Healthcare Vertical
• 3+ years working in a cloud environment building analytical capabilities using PowerBI service, Snowflake
• Proven keen observation skills and comfortable with complex data sets
• Proven ability to champion and manage new initiatives to completion to improve and streamline operations processes and maximize systems efficiency

Nice-to-haves

• Experience working with Medicaid data sets from MMIS systems
• Experience with healthcare interoperability standards (HL7, FHIR)
• Experience with advanced data modeling techniques; predictive modeling, link analysis, graphical analysis, supervised and unsupervised models
• Experience with Power BI Embedded for custom application integration
• Experience with advanced analytics integration (Python/R scripts within Power BI)
• Understanding of Power BI REST API and embedding reports into applications
• Proven excellent communication both written and verbal
• Proven solid analytical skills to identify trends, anomalies, and compliance risks in Medicaid data

Benefits

• a comprehensive benefits package
• incentive and recognition programs
• equity stock purchase
• 401k contribution

Apply tot his job Apply To this Job