Data Platforms Developer I
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.
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
Skills
- 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
- 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 Overview
Company H1B Sponsorship