BI Developer

**REMOTE OPPORTUNITY for Oregon, Washington, and Idaho Residents ONLY**

We are seeking a skilled and detail-oriented Business Intelligence (BI) Developer to join our team. This role is responsible for troubleshooting data-related issues, ensuring data accuracy and reliability, and designing impactful reports and dashboards. The ideal candidate will have strong analytical skills, a commitment to data integrity, and experience with modern BI tools, particularly Azure Synapse and Power BI. This individual is expected to consistently deliver the highest level of customer service and take initiative to anticipate needs, proactively addressing challenges before they arise.

Pay: Starts at $90,000 annually (commensurate with experience)

Schedule: Monday through Friday 8:00 AM – 5:00 PM

Benefits

• Medical, Dental, Vision with In-Network & Custom Network discounts
• 401(K) with discretionary employer match
• Paid Time Off
• Free clinical diagnostic laboratory testing performed in house

Essential Duties and Responsibilities
The essential duties and responsibilities of this position include the following and must be completed with or without reasonable accommodation.

• Troubleshoot support tickets to identify the root cause of the errors/issues and resolve them in a timely manner, ensuring a positive and solution-oriented experience for internal and external customers.
• Monitor data refreshes within Power BI, SSIS data integrations, and Azure Synapse and Microsoft Fabric data pipelines, proactively identifying and resolving any failures to maintain seamless operations.
• Monitor and troubleshoot performance issues, recommending solutions to enhance overall system performance while anticipating potential bottlenecks or risks.
• Design reports and dashboards that provide meaningful insights, keeping customer needs and business objectives in mind.
• Extract and analyze data using Microsoft Excel or Power BI, ensuring that all deliverables meet the highest standards of accuracy and clarity.
• Test BI solutions for data accuracy and reliability, taking proactive measures to prevent issues before deployment.
• The standard work hours are 8:00 AM to 5:00 PM PST, with flexibility as long as core hours (8:00 AM to 3:00 PM) are covered.
• Perform other duties as assigned to support team objectives, organizational goals, and changing business needs.
• Attend work, whether remotely or on-site, consistently and on time, adhering to scheduled hours and organizational policies.

Qualifications

• Strong oral and written communication skills with a customer-first mindset.
• Ability to absorb and retain information quickly while taking initiative to improve processes and anticipate business needs.
• Strong analytical and troubleshooting skills that focus on proactive solutions.
• Detail-oriented to ensure data integrity and accuracy with a commitment to quality in all deliverables.

Technical Expertise

• Experience with Windows operating system, Microsoft Office products, Visual Studio, and SSMS.
• Understanding of data warehouse concepts, such as star schema and data modeling.
• Minimum 3 years of hands-on experience with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and Power BI.
• Experience with Azure Synapse and/or Microsoft Fabric is a must.
• Proficient in writing and optimizing SQL queries.
• Experience with Microsoft Power Platform (Power Automate and/or Power Apps) is desirable.
• Data experience in the healthcare industry is preferred.

Physical Requirements: Manual dexterity for office machine operation including computer operations, stooping, bending, mobility to complete errands, or sitting for extended periods of time. Stress can be triggered by multiple staff demands and deadlines.

Our family of companies also includes Praxis Health, the largest independent medical group in Oregon, and Interpath Laboratory, Inc., the Northwest's leading clinical and anatomic medical laboratory with over 90 locations across Oregon, Washington, Idaho, and Nebraska. With over 60 years of proven success, our organization thrives thanks to the passion, dedication, and ingenuity of our people.