Programmer

Progressive; Pleasanton (CA); On-site; USD 120,000 - 180,000; Full time

Job summary

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

Qualifications

• 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.

Responsibilities

• 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.

Skills

ETL development

Python

SQL

APIs

Data integration

Stakeholder collaboration

Tools

Power BI

Foundry

GIS

Job description

We are seeking a highly analytical and self-directed technical professional who can bridge business and engineering requirements with software, data, and automation solutions. The ideal candidate will be comfortable working with large datasets, developing scalable automation tools, and partnering with engineering teams to improve operational decision-making and risk management processes.

Required Qualifications

• 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 work with technical and business stakeholders to translate requirements into automated solutions.

Preferred Qualifications

• Utility, pipeline integrity, asset management, or risk modeling experience.
• Experience with GIS, Foundry, cloud-based data platforms, and advanced analytics.
• Familiarity with machine learning, statistical modeling, and predictive analytic

Scope of Work

Data Automation & Integration

• 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.

Data Quality & Validation

• 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.

Reporting & Analytics

• 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.

Data Governance Support

• 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.

Advanced Analytics

• Support development of predictive analytics and risk forecasting capabilities.
• Assist with corrosion growth modeling, mitigation effectiveness analyses, and other analytical initiatives supporting the TIMP Risk Roadmap.
• Evaluate opportunities to leverage machine learning and statistical analysis techniques to enhance risk assessment processes.

EOE Statement: Specialist Staffing Group is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status.

In addition to base pay, employees may be eligible for benefits such as health insurance, health savings accounts, retirement savings plans, life and disability insurance, and paid leave where required by applicable law. Eligibility may vary based on factors such as location and hire date and is subject to change.