[Remote] Data Engineer, Platform Modernization (Data Warehouse Programmer/Analyst)

Note: The job is a remote job and is open to candidates in USA. CalOptima is a mission-driven community-based organization focused on serving member health with excellence and dignity. They are seeking a Data Engineer, Platform Modernization (Data Warehouse Programmer/Analyst) to modernize their legacy data estate and collaborate with various teams to transition to a cloud-native data ecosystem.ResponsibilitiesAssists the team in carrying out department responsibilities and collaborates with others to support short and long-term goals/priorities for the departmentParticipates in a mission driven culture of high-quality performance, with a member focus on customer service, consistency, dignity and accountabilityResponsible for the modernization and decommissioning of the Microsoft Access database estate, applying technical judgment to inventory and centralization work performed in partnership with Data Governance and Information Security to recommend retire, migrate or replace pathsDesigns and delivers modern replacements for legacy Access databases and departmental applications using Power BI, Power Platform with Dataverse, SQL Server stored procedures and the enterprise cloud data platformPorts SQL Server stored procedures and legacy database logic to the modern cloud data platform (e.g., Databricks, Microsoft Fabric, Snowflake) and to the medallion (Bronze, Silver, Gold) architecture using transformation frameworks such as dbtPartners with Data Governance to surface, document and validate business rules embedded in legacy stored procedures and Access databases during migrationCollaborates with business owners across the enterprise to understand legacy data workflows, negotiate retire and migrate decisions and ensure continuity of business-critical reporting and operational processesContributes to the Silver and Gold layers of the medallion architecture, developing transformation models, reporting structures and data quality tests as platform capacity growsDevelops parameterized SQL Server Management Studio templates and scheduled jobs to replace ad-hoc query and reporting patterns from retired Access databasesWorks within established CI/CD pipelines and platform change management practices (e.g., GitHub, Azure DevOps), operating through governed development, test and production environmentsDocuments legacy systems, migration decisions and reusable modernization patterns to support future platform modernization workQueries and analyzes large-scale health care datasets and business logic (e.g., claims, eligibility, provider, member data) using SQL and other tools to support migration analysis and validationReports modernization progress, risks and decisions to leadership on a regular cadence to ensure visibility and alignment with the enterprise data strategyStays informed on emerging modernization patterns, low-code platforms and cloud data tools, and proactively recommends enhancements to the organization's modernization approachManages multiple projects simultaneously, ensuring timely delivery and alignment with stakeholder expectationsCompletes other projects and duties as assignedSkillsBachelor's degree in computer science, health informatics, data analytics or a related field PLUS 5 years of professional experience in data engineering, data warehousing, database development or legacy systems modernization required; an equivalent combination of education and experience sufficient to successfully perform the essential duties of the position such as those listed above may also be qualifying2 years of hands-on experience working with Microsoft Access and VBA programming required4 years of hands-on experience working with health care data, including administrative and clinical datasets, and familiarity with HIPAA compliance requiredMaster's degree in computer science, health informatics, data analytics or a related fieldRelevant certificationsDemonstrated experience leading legacy data platform modernization or decommissioning initiatives at enterprise scaleHands-on experience porting SQL Server stored procedures and other legacy database logic to a modern cloud data platform (e.g., Snowflake, Microsoft Fabric, Databricks)Production experience with dbt and medallion (Bronze, Silver, Gold) data architectureExperience with Power Platform solution design, including Power Apps, Power Automate and Dataverse, as replacements for legacy departmental applicationsExperience with at least one other programming language (e.g., Python, Scala) for automation and analysisExperience with CI/CD tools and practices (e.g., GitHub, Azure DevOps) for data workflowsIn-depth experience with SQL Server Integration Services (SSIS) for legacy ETL analysis and modernizationExperience working in a healthcare payer environment supporting multiple lines of business, including Medicaid, Medicare, commercial, and dual-eligible populationsFamiliarity with data governance practices and tools (e.g., Collibra, Purview)Experience in regulated industries (e.g., government)BenefitsCalPERS pension program and additional retirement packages.A generous PTO programA quality work life balanceVarious wellness programsTuition ReimbursementProfessional development opportunitiesCareer development opportunitiesFlexible schedulingFull Telework (**If the position is Telework, it is eligible in California only**)Company OverviewThe N.C. It was founded in 1877, and is headquartered in Raleigh, North Carolina, USA, with a workforce of 1001-5000 employees. Its website is http://ncagr.gov.