Job Title: ETL Developer
Experience: 5+ Years
Start Date: Early July
Type: W2 Employee
Location: MUST BE Local to the Sacramento, CA region and be available to work onsite, although the position is mostly remote work currently. Office hours are between the hours of 8am and 6pm Monday through Friday.
Compensation: DOE and compensation package of benefits. Range of $80K - 105K, W2 hourly $50-60/hr.
Pre-employment Requirements: Professional References, I-9 Employment eligibility, Successful criminal background and drug screen. Stanfield Systems does not sponsor Visa holding candidates.
If you meet and exceed the following skills sets, please respond with your full contact information, resume, date available and desired compensation target amount and arrangement and Apply at on the Career Page, Job ID 4200 or email your resume and contact information to with “Mid. Level ETL Developer for 4200” in the subject line
Required Skills
- 5+ years of experience as an ETL Developer or Data Integration Developer.
- Strong experience developing and maintaining ETL pipelines and data workflows.
- Hands-on experience with PostgreSQL including query optimization, data modeling, and performance tuning.
- Experience with data quality validation, cleansing, reconciliation, and monitoring.
- Strong SQL development and troubleshooting skills.
- Ability to analyze business requirements and translate them into scalable ETL solutions.
- Experience working with large datasets and ensuring data accuracy and integrity.
Preferred Skills
- Experience working with Health Care/Health Data environments.
- Proficiency in Python for data processing and automation.
- Experience using Azure Data Studio.
- Familiarity with Visual Studio Code (VS Code) and MSSQL extensions/plugins.
- Understanding of data governance, security, and best practices for data management.
Responsibilities
- Design, develop, test, and support ETL processes and data integration solutions.
- Create and optimize PostgreSQL queries, stored procedures, and database objects.
- Perform data quality checks and implement data validation procedures.
- Troubleshoot and resolve ETL, database, and data integrity issues.
- Collaborate with business stakeholders, analysts, and technical teams to gather requirements and deliver data solutions.
- Document ETL processes, data mappings, and technical specifications.
- Support ongoing enhancements and maintenance of enterprise data platforms.
Nice to Have
Questions: Answers to be submitted with application
How many years of professional experience do you have as an ETL Developer? Please describe your experience with ETL design, development, and maintenance.
Have you worked with healthcare or health-related data? If yes, please provide project details, your role, and the duration of the engagement.
What are the largest-scale ETL or data integration projects you have successfully delivered in the past 5 years? Please include project size, duration, data volume, and technologies used.
How many years of experience working on State of California government projects?
Stanfield Systems Inc. is an equal opportunity employer and does not discriminate against race, color, sex, national origin, religion, age, equal pay, disability or genetic information. Some positions posted by our company will require an individual to pass a thorough criminal background check, drug screen and may require the ability to obtain various national security clearance levels. Demonstrates proficiency with on-line search engines and/or sophisticated searching strategies. More desirable if familiar with searching job boards, for sourcing & recruiting candidates and posting positions/information to the web.