Cloud SQL Developer - Hybrid

Applied Statistics & Management - Temecula, CA

Full-time - Mid Level

Temecula, CA

Publishing Industries

About the position

The Cloud SQL Developer at Applied Statistics & Management Inc. (ASM) plays a crucial role in managing third-party data sources and integrations for healthcare administration and quality assurance. This position involves automating data collection, cleaning, and linking public sources to ensure data availability, speed, and reliability for verification, querying, and reporting in applications. The ideal candidate will focus on user experience, quality, and reliability while collaborating with other developers to solve design and performance challenges.

Responsibilities

• Extract, clean, and transform data from diverse sources such as databases, APIs, flat files, and external systems.
• Develop and maintain robust ETL processes to automate data integration and ensure data quality.
• Write efficient and scalable SQL queries to transform and aggregate data for business needs.
• Collaborate with the product team and integration partners to understand data requirements and implement data solutions.
• Ensure the consistency, accuracy, and reliability of data by implementing best practices for data governance.
• Optimize and maintain data pipelines for continuous integration and delivery of data.
• Monitor data performance and troubleshoot issues related to data ingestion, transformation, and storage.
• Monitor and validate updates and issues with third-party data sources.
• Document data engineering processes, workflows, and solutions for internal knowledge sharing.

Requirements

• Experience with RDBMS (MSSQL, PostgreSQL, etc.) with writing and maintaining SQL Queries, tables, views, indexes, etc.
• Experience with ETLs—Azure Data Factory, SSIS, or related technologies.
• Experience with extracting data from Excel, CSV, etc.
• Familiarity extracting data from the web—file downloads, APIs, etc.
• Familiarity dealing with unstructured data sources.

Nice-to-haves

• Creating meaningful alerts for missing/old data, process failures, etc.
• Experience with Terraform/Terraform Cloud for creating Azure/AWS resources.

Benefits

• Modern Technology - SSD-enabled laptops, dual 24" LED monitors, Sit/Stand Desks, Herman-Miller chairs.
• Catered lunches on Wednesdays.