ETL, PostgreSQL, Data Quality, SQL, Python, Healthcare Data, Azure Data Studio, VS Code, Data Integration, Data Warehousing.
Description
Job Title:ETL Developer
Experience:5+ Years
Start Date:Early July
Type: W2 Employee
Location: MUSTBE Local to the Sacramento, CA region andbe available to work onsite, althoughthe position is mostlyremote workcurrently. Officehours arebetween the hours of 8am and 6pmMonday through Friday.
Compensation: DOE and compensation package of benefits. Range of $80K -105K, W2 hourly $50-60/hr.
Pre-employment Requirements: ProfessionalReferences, I-9 Employment eligibility, Successful criminalbackgroundand 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 arrangementand Applyat www.StanfieldSystems.comon the Career Page, Job ID 4200 or email your resume and contact information to Candidates@StanfieldSystems.comwith "Mid. Level ETL Developer for 4200" in the subject line
Required Skills
- 5+ years of experience as an ETL Developeror Data Integration Developer.
- Strong experience developing and maintaining ETL pipelinesand data workflows.
- Hands-on experience with PostgreSQLincluding 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 Dataenvironments.
- Proficiency in Pythonfor 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 besubmittedwith 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.
Howmany years of experience working on State of Californiagovernmentprojects?
Stanfield Systems Inc. is an equal opportunity employer and does not discriminate against race, color, sex, national origin, religion, age, equal pay,disabilityor genetic information. Some positions posted by our company will require an individual to pass a thorough criminal background check, drugscreenand may require the ability to obtain various national security clearance levels.Demonstratesproficiencywith on-line search engines and/or sophisticatedsearchingstrategies. More desirable if familiar withsearchingjob boards, for sourcing & recruiting candidates and posting positions/information to the web.