ETL Developer (Remote)

Lensa; Lansing (MI); Remote; USD 118,000 - 122,000; Full time

Job summary

A leading technology company is seeking an experienced ETL Developer to design and maintain data pipelines critical for data integrity and business insights. The ideal candidate will have extensive SQL experience, a strong background in database management, and a commitment to data governance standards. With a collaborative remote work environment, this role focuses on delivering innovative data solutions while ensuring compliance with healthcare regulations. Join us to help transform government IT with your expertise.

Benefits

Employee Assistance Program (EAP)

Corporate Discounts

Learning & Development platform

Training and Certification Assistance

Pet Insurance

Flexible Work Environment

Qualifications

• 5-8 years experience in ETL and database management.
• Hands-on experience with SQL querying.
• Experience in an Enterprise Data Warehouse environment.

Responsibilities

• Develop and maintain scalable ETL pipelines for data integration.
• Design and optimize SQL Server databases to meet data processing needs.
• Conduct QA testing and troubleshoot data issues.

Skills

SQL

Data governance

ETL best practices

Performance tuning

Agile methodologies

Collaboration

Education

Bachelor's degree in Computer Science

Tools

Azure Data Factory

Azure DevOps

GitHub

Job description

1 day ago Be among the first 25 applicants

Get AI-powered advice on this job and more exclusive features.

Lensa partners with DirectEmployers to promote this job for GovCIO.

Overview

We are seeking a detail-oriented and experienced ETL Developer to design, build, and maintain robust data pipelines that power our data infrastructure. This role is critical in ensuring data integrity, optimizing data flow, and supporting the business with actionable, reliable data insights. You will have hands-on experience with SQL Server, including performance tuning and database design. You will collaborate with cross-functional teams to solve complex data challenges and implement innovative solutions that align with our enterprise data governance and compliance standards, including HIPAA.

This position will be a fully remote position located in the United States.

Responsibilities

This role is responsible for developing and maintaining efficient, scalable ETL pipelines to support the integration and transformation of data from diverse sources into target systems. It includes designing and optimizing SQL Server databases, writing complex T-SQL queries and stored procedures, and ensuring high performance, data accuracy, and maintainability.

• Support ongoing ETL operations and ensure secure, compliant administration of data systems in alignment with enterprise data governance.
• Collaborate with internal teams to translate business needs into technical solutions and ETL requirements.
• Adhere to organizational procedures, including source control, release/deployment, and change management protocols.
• Conduct QA testing, troubleshooting, and validation to ensure pipeline accuracy and data integrity.
• Identify, design, and implement process improvements, including automation and optimization for scalability and performance.
• Assist IT teams in developing tracking tools for data usage, user activity, and SQL performance to inform product and process enhancements.
• Perform root cause analysis for data issues and suggest actionable improvements.
• Create and maintain thorough data documentation such as data dictionaries, ERDs, and data maps.
• Ensure compliance with all applicable regulatory requirements, including HIPAA.
• Work closely with Executive and Product teams to support their data needs and resolve technical issues.
• Partner with data analytics professionals to enhance functionality, governance, and user experience in our data systems.
• Handle sensitive data, including Electronic Protected Health Information (PHI), with appropriate care and confidentiality.
• Develop and maintain scalable and efficient ETL pipelines for extracting, transforming, and loading data from various sources into target systems.
• Build and maintain SQL Server databases, including schema design, indexing strategies, and stored procedure development to support data processing and reporting needs.
• Write and optimize complex T-SQL queries, stored procedures, and functions to ensure high performance, accuracy, and maintainability of database operations.
  
  

Qualifications

Required Skills and Experience

• Bachelor's degree in Computer Science, Information Systems, or related field, with 5 - 8 years of experience. (or commensurate experience)
• 5+ years of hands-on experience in relational databases and SQL querying.
• 3+ years working in an Agile environment.
• 3+ years of experience working in an Enterprise Data Warehouse environment.
• Proficient with enterprise data integration tools (Azure Data Factory preferred).
• Strong understanding of data warehouse architecture and cloud-based infrastructure.
• Experience in performance tuning of SQL queries and ETL pipelines.
• Experience with Azure DevOps and/or GitHub for version control, CI/CD pipeline automation, and release management
• Solid understanding of ETL best practices.
• Must be highly organized with strong attention to detail.
• Able to thrive in both team and independent environments with minimal supervision.
  
  

Clearance Required: Ability to obtain and maintain a Suitability/Public Trust clearance.

Preferred Skills And Experience

• Experience with healthcare data and familiarity with HIPAA compliance.
• Familiarity with data governance frameworks and best practices.
  
  

Company Overview

GovCIO is a team of transformers--people who are passionate about transforming government IT. Every day, we make a positive impact by delivering innovative IT services and solutions that improve how government agencies operate and serve our citizens.

But we can't do it alone. We need great people to help us do great things - for our customers, our culture, and our ability to attract other great people. We are changing the face of government IT and building a workforce that fuels this mission. Are you ready to be a transformer?

What You Can Expect

Interview & Hiring Process

If you are selected to move forward through the process, here’s what you canexpect:

• During the Interview Process
• Virtual video interview conducted via video with the hiring manager and/or team
• Camera must be on
• A valid photo ID must be presented during each interview
• During the Hiring Process
• Enhanced Biometrics ID verification screening
• Background check, to include:
• Criminal history (past 7 years)
• Verification of your highest level of education
• Verification of your employment history (past 7 years), based on information provided in your application
  
  

Employee Perks

Benefits

At GovCIO, we consistently hear that meaningful work and a collaborative team environment are two of the top reasons our employees enjoy working here. In addition, our employees have access to a range of perks and benefits to support their personal and professional well-being, beyond the standard company offered health benefits, including:

• Employee Assistance Program (EAP)
• Corporate Discounts
• Learning & Development platform, to include certification preparation content
• Training, Education and Certification Assistance*
• Referral Bonus Program
• Internal Mobility Program
• Pet Insurance
• Flexible Work Environment
• Available to full-time employees
  
  

Our employees’ unique talents and contributions are the driving force behind our success in supporting our customers, which ultimately fuels the success of our company. Join us and be a part of a culture that invests in its people and prioritizes continuous enhancement of the employee experience.

We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender, gender identity or expression, sexual orientation, national origin, disability, or status as a protected veteran. EOE, including disability/vets.

Posted Pay Range

The posted pay range, if referenced, reflects the range expected for this position at the commencement of employment, however, base pay offered may vary depending on multiple individualized factors, including market location, job-related knowledge, skills, education, experience, and internal equity. The total compensation package for this position may also include other compensation elements, to be discussed during the hiring process. If hired, employee will be in an “at-will position” and the GovCIO reserves the right to modify base salary (as well as any other discretionary payment or compensation program) at any time, including for reasons related to individual performance, GovCIO or individual department/team performance, and market factors.

Posted Salary Range

USD $118,000.00 - USD $122,000.00 /Yr.

Submit a referral to this job (https://careers-govcio.icims.com/jobs/6180/etl-developer-%28remote%29/job?mode=apply&apply=yes&in_iframe=1&hashed=-1834385473)

Location US-Remote

ID 2025-6180

Category Information Technology

Position Type Full-Time

If you have questions about this posting, please contact [e-mail]

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Business Development and Sales

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at Lensa by 2x

Sign in to set job alerts for “ETL Developer” roles.

Lansing, MI $118,000 - $122,000 4 hours ago

Lansing, MI $160,000 - $170,000 4 hours ago

Communications, Policy, and Data Analyst (Remote)

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.