Apply on Employer Site

PacificSource Health Plans · 1 day ago

Data Platforms Developer I

Springfield, OR

Full-time

Hybrid

New Grad, Entry Level

$58K/yr - $93K/yr

PacificSource Health Plans is seeking a Data Platforms Developer I to help members access quality, affordable care. The role involves designing and developing data models, ETL processes, and maintaining data quality while collaborating with cross-functional teams.

CommunitiesCustomer ServiceNon Profit

H1B Sponsor Likely

Responsibilities

Design dimensional data models using Kimball data warehouse design techniques

Develop ETL/ELT processes using Python and SQL on our Databricks data lake house platform

Design, implement and maintain multi-dimensional models or “Cubes” to meet specific business requirements

Participate in on-call rotation in support of the ETL/ELT nightly schedule

Periodically, develop standardized parameterized reports using Microsoft SQL Reporting Services from multiple data sources

Actively participate in the data quality improvement process by making recommendations to simplify data structures and improve information quality

Troubleshoot and resolve reporting issues, data inconsistencies, scheduling, query performance

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

Qualification

PythonSQLDatabricksInformaticaMicrosoft SQL Reporting ServicesETL/ELT processesData modelingTeamworkProblem SolvingCommunicationAdaptability

Required

Relevant real-world experience in software development and analysis, preferably in a business environment

BS in Computer Science or equivalent degree, licensure, or experience

Design dimensional data models using Kimball data warehouse design techniques

Develop ETL/ELT processes using Python and SQL on our Databricks data lake house platform

Design, implement and maintain multi-dimensional models or 'Cubes' to meet specific business requirements

Participate in on-call rotation in support of the ETL/ELT nightly schedule

Periodically, develop standardized parameterized reports using Microsoft SQL Reporting Services from multiple data sources

Actively participate in the data quality improvement process by making recommendations to simplify data structures and improve information quality

Troubleshoot and resolve reporting issues, data inconsistencies, scheduling, query performance

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

Preferred

Additional desired experience includes TriZetto Facets, Dynamics CRM, technical integration and implementation, database administration, EDI (ANSI x12 formats), FHIR, dashboard development, project management experience, and integration of enterprise-wide applications

Programming in VB.NET, ASP.NET, C#

Advanced experience with databases, Informatica and SQL stored procedures

Primary technologies/knowledge: Databricks, Python / T-SQL, Microsoft Master Data Services, Informatica MDM, Power BI, Microsoft SQL Reporting Services/BI DS, Microsoft SQL Analysis Services/BI DS, Tableau

Company

PacificSource Health Plans

Founded in 1933, PacificSource is a not-for-profit health insurer for people and organizations throughout the Northwest.

Founded in 1933

Springfield, Oregon, USA

1001-5000 employees

http://www.pacificsource.com

H1B Sponsorship

PacificSource Health Plans has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (6)

2024 (4)

2023 (2)

2022 (4)

2021 (5)