Software Developer II, Business Intelligence - Medical Management

PacificSource; Boise (ID); Hybride; USD 65 000 - 110 000; Plein temps

Avantages offerts par ce poste

Flexible telecommute policy

Medical

Vision

Dental insurance

401(k) plan

Paid time off and holidays

Tuition reimbursement and training

Life insurance

Volunteering opportunities

Résumé du poste

PacificSource is seeking a software development and analytics professional to enhance our BI reporting environment. You will design and implement reports from multiple data sources, optimize data quality, and participate in LEAN-driven operational improvements across IT and business teams.

You will work with Epic Payer Platform/Tapestry, Databricks, SQL Server, Tableau, and Power BI to deliver value. Ideal candidates have 3+ years of experience in healthcare IT, a CS degree, and strong SQL

Qualifications

• 3+ years of software development and analysis in a business environment.
• Healthcare insurance systems experience (Medicaid/Medicare) preferred.
• Knowledge includes debugging, software installation, programming development tools, Transact-SQL, MS Visual Studio, and MS SQL Server Management Studio.

Responsabilités

• Develop standardized parameterized reports using COTS reporting tools from multiple data sources.
• Support end users on the use of reports and reporting tools.
• Participate in design and implementation of data models and cubes to meet business requirements.
• Analyze and evaluate existing or proposed systems and applications.
• Develop, program, and configure mission-critical applications and/or web portals.
• Provide training and input to departments on system capabilities.

Connaissances

VB.NET

ASP.NET

C#

Transact-SQL

Formation

Bachelor’s degree in Computer Science

Outils

Epic Payer Platform/Tapestry

Databricks

Tableau

Power BI

SQL Server Integration Services

Microsoft SQL Reporting Services

MDX

SQL Server Management Studio

Description du poste

PacificSource Overview

Looking for a way to make an impact and help people? Join PacificSource and help our members access quality, affordable care! PacificSource is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to status as a protected veteran or a qualified individual with a disability, or other protected status, such as race, religion, color, sex, sexual orientation, gender identity, national origin, genetic information or age. PacificSource values the diversity of our community, including those we hire and serve. We are committed to creating and fostering a work environment in which individual differences and diversity are appreciated, respected and responded to in ways that fully develop and utilize each person’s talents and strengths.

Provide information system solutions to internal departments and external customers and partners. Responsibilities include analyzing requirements, understanding business processes and needs, and recommending solutions to achieve the business’ goals. Solutions will include implementation and integration of purchased applications and development of applications and integrations where appropriate. Projects are completed with cross-functional teams of IT peers and business partners. Manage time and expectations to ensure a high degree of stakeholder and user satisfaction.

Essential Responsibilities

• Develop standardized parameterized reports using Commercial off-the-shelf (COTS) reporting tools from multiple data sources.
• Support end users on the use of reports and reporting tools.
• Actively participate in the Data Quality improvement process by making recommendations to simplify data structures and improve information quality.
• Identify opportunities for operational improvements and reduce waste using the LEAN methodology.
• Troubleshoot and resolve reporting issues, data inconsistencies, scheduling, query performance.
• Keep current on current trends, best practices, and technologies in BI and make appropriate recommendations to technology planning team.
• Design and implement multi-dimensional models or “cubes” to meet specific business requirements.
• Analyze and evaluate existing or proposed systems.
• Develop, program, and configure mission-critical applications and/or web portals.
• Assess user requirements and provide input to departments.
• Liaise with other IT staff to improve system efficiency, security, and functionality.
• Identify, diagnose, and resolve potential and evident system problems.
• Provide troubleshooting support to other staff.
• Design and apply new methods and procedures.
• Develop and test systems, programs, and database structure for efficiency and effectiveness.
• Prepare systems specifications, project plans, and other internal documents.
• Ensure users and partners understand nature of work being performed, as well as timeframes and milestones.
• Provide regular status updates to supervisors and stakeholders.
• Train users in technical aspects of systems.
• Participate in selection and recommendation of suppliers and vendors.
• Assist in management of those relationships.
• Balance high-priority work with lower priority maintenance work to ensure both success of projects and smooth operation of existing functions.
• Proactively identify opportunities for system and process improvement.
• Work with management and stakeholders to prioritize and implement solutions accordingly.

Supporting Responsibilities

• Meet department and company performance and attendance expectations.
• Follow the PacificSource privacy policy and HIPAA laws and regulations concerning confidentiality and security of protected health information.
• Perform other duties as assigned.

Success Profile

Work Experience: Minimum of 3 years of software development and analysis in a business environment. Commercial, Medicaid, and/or Medicare healthcare insurance industry systems experience preferred. Additional desired experience includes Epic Payer Platform/Tapestry, Databricks, TriZetto Facets, technical integration and implementation, database administration, EDI (ANSI x12 formats), project management experience, and integration of enterprise-wide applications.

Programming in VB.NET, ASP.NET, C#. Advanced experience with databases, SSIS and SQL stored procedures.

Education, Certificates, Licenses: Bachelor’s degree in Computer Science or equivalent combination of upper-level education and experience required.

Knowledge: Required technical experience may include debugging, software installation, programming development tools, Transact-SQL, basic knowledge and use of MS-Office suite, flowcharting, documentation, MS Visual Studio, and MS SQL Server Management Studio.

Primary Technologies/Knowledge

• Epic Payer Platform/Tapestry, Databricks, SQL (Microsoft)
• Microsoft SQL Reporting Services/BI DS, Microsoft SQL Analysis Services/BI DS
• Microsoft Power Suite (Power BI, Power View, Power Pivot), Microsoft Master Data Services and Data Quality Services
• Microsoft SQL Server Integration Services, Tableau, MDX (Multidimensional Expression)

Competencies

• Adaptability
• Building Customer Loyalty
• Building Strategic Work Relationships
• Building Trust
• Continuous Improvement
• Contributing to Team Success
• Planning and Organizing Work

Skills

Compensation Disclaimer The wage range provided reflects the full range for this position. The maximum amount listed represents the highest possible salary for the role and should not be interpreted as a typical starting wage. Actual compensation will be determined based on factors such as qualifications, experience, education, and internal equity. Please note that the stated range is for informational purposes only and does not constitute a guarantee of any specific salary within that range. Base Range: $64,871.24 - $110,281.11

Benefits

• Flexible telecommute policy
• Medical
• Vision
• Dental insurance
• Incentive program
• Paid time off and holidays
• 401(k) plan
• Volunteer opportunities
• Tuition reimbursement and training
• Life insurance
• Options such as a flexible spending account

Physical Requirements

• Stoop and bend.
• Sit and/or stand for extended periods of time while performing core job functions.
• Repetitive motions to include typing, sorting and filing.
• Light lifting and carrying of files and business materials.
• Ability to read and comprehend both written and spoken English.
• Communicate clearly and effectively.

Disclaimer

This job description indicates the general nature and level of work performed by employees within this position and is subject to change. It is not designed to contain or be interpreted as a comprehensive list of all duties, responsibilities, and qualifications required of employees assigned to this position. Employment remains AT-WILL at all times. PacificSource is anything but a typical health insurance company. Founded in 1933, we’re an independent, not-for-profit organization that puts our members, and their communities first—across Idaho, Oregon, Montana, and Washington. It's our employees who make it happen: promoting health equity and partnering with providers to deliver better access to optimal, affordable care. So yes, with PacificSource, you get to do great things. In our effort to put members first—more than 525,000 of them—initiative, commitment, and hard work are supported and rewarded with excellent benefits, competitive wages, and opportunities for personal growth and advancement.

Additional Information

Top Workplace 2026, 2025 and 2024 USA | USA Today 2025 Healthcare Top Workplaces | Energage Top Workplaces # 6 Healthiest Employer of Oregon 2025 | Portland Business Journal Top Workplace 2024, 2023 and 2022 for Oregon and SW Washington | The Oregonian Top Workplace 2025, 2024, 2023 and 2022 for the Treasure Valley | Idaho Press Certified Age Friendly Employer, 2023 | Age Friendly Institute PacificSource is an equal opportunity employer. Click here to review our AAP Policy Statement.