Data Automation & Analytics Engineer (ETL, Python)

Progressive; Pleasanton (CA); In loco; USD 120.000 - 180.000; Tempo pieno

Descrizione del lavoro

Specialist Staffing Group is seeking a highly analytical technical professional to bridge business and engineering needs with software, data, and automation solutions in Pleasanton, CA. You will develop scalable data automation, implement data quality checks, and build dashboards to support risk assessment and governance.

The role emphasizes transforming complex requirements into automated workflows, partnering with engineering teams, and advancing predictive analytics within enterprise data

Competenze

• Experience developing data automation and ETL solutions.
• Strong proficiency in Python and SQL.
• Experience with APIs, database development, and data integration.
• Experience with Power BI or similar reporting platforms.
• Knowledge of data quality management and validation frameworks.
• Ability to translate requirements into automated solutions for technical and business stakeholders.
• Preferred: GIS, Foundry, cloud-based data platforms, and advanced analytics.

Mansioni

• Develop and maintain automated data pipelines that acquire, transform, and integrate data from multiple enterprise systems.
• Eliminate or reduce manual spreadsheet-based data collection and manipulation processes.
• Support integration of data from Foundry, GIS, SAP, corrosion databases, and other business systems.
• Develop reusable scripts, APIs, and automated workflows supporting annual Risk Run activities.
• Design and implement automated validation checks for critical risk assessment inputs.
• Develop exception reporting and data quality monitoring processes.
• Create automated change-detection routines to identify significant year-over-year changes in input datasets.
• Implement engineering-based business rules to identify anomalous or inconsistent data.
• Develop dashboards and automated reports supporting risk model validation and data quality monitoring.
• Automate trend analysis and exception reporting for risk assessment results.
• Support development of metrics related to data quality, risk model performance, and assessment repeatability.
• Assist with the establishment of centralized data repositories and system-of-record solutions.
• Document data definitions, business rules, validation requirements, and data lineage.
• Partner with data owners to improve data governance, ownership, and accountability.
• Support development of predictive analytics and risk forecasting capabilities.
• Assist with corrosion growth modeling, mitigation effectiveness analyses, and other analytical initiatives.

Conoscenze

ETL development

Python

SQL

APIs

Data integration

Stakeholder collaboration

Strumenti

Power BI

Foundry

GIS

Descrizione del lavoro

Specialist Staffing Group is seeking a highly analytical technical professional to bridge business and engineering needs with software, data, and automation solutions in Pleasanton, CA. You will develop scalable data automation, implement data quality checks, and build dashboards to support risk assessment and governance.

The role emphasizes transforming complex requirements into automated workflows, partnering with engineering teams, and advancing predictive analytics within enterprise data