ETL/ELT Developer/Cloud Implementer

The Department of Health Services (DHS), Division of Public Health (DPH) is recruiting for an ETL/ELT Developer/Cloud Implementer within the Office of Health Informatics (OHI).

OHI is responsible for creating and supporting public health data collection systems and infrastructure, as well as selecting and providing support for analysis and data management tools. Data collected supports all state and many national public health programs. Many of the data sources are part of a set of national data and technology standards supporting federally- funded health initiatives.

This position offers the option to work remotely up to 5 days per week and will be headquartered at one of the DPH central or regional offices. You must have access to both a private workspace and high-speed internet if working remotely. A greater in-office presence may be required periodically for meetings, events, training, onboarding, or other operational needs. This position will work Monday through Friday, daytime hours.

As an employee of the State of Wisconsin, you'll also have access to an amazing benefits package, including:

• 3.5 weeks of vacation, 9 paid holidays and ample sick time.
• Top rated health plan options starting at $42/month for single plans and $104/month for family plans, after 2 months of state service.
• Premium pension plan with a 6.95% employer match in 2025. Plus, a tax advantaged supplemental retirement savings plan which allows you to save money directly from your paycheck for retirement. Use this Total Rewards Calculator to see the total value of our competitive benefits package!
• Several flex spending accounts: medical, dependent care, commuter, parking and High Deductible Health Savings.
• Well Wisconsin Wellness Program.
• A free and confidential employee assistance program that offers employees and their immediate family dependents a variety of tools, resources, and professional consultation services to support their health, goals, and overall well-being.
• Public Service Loan Forgiveness Program employer.

• Building and maintaining cloud data warehousing and cloud infrastructure
• Building and maintaining pipelines using SQL and/or Python for data warehousing and data infrastructure efforts for data sources stored both on premise and in the cloud
• Cleansing and organizing data for analysis and reporting
• Developing and maintaining SQL data ETLs and managing relational data
• Linking data from various sources
• Documenting data and data flows in the metadata management system.

The starting pay is between $50.00 to $57.00 per hour (approximately $104,000 to $118,560 per year), depending on qualifications, plus excellent benefits. A 12-month probationary period is required.

Pay for current or former state employees will be set based on the rules that apply to compensation for the applicable transaction. This position is classified as IS Data Services Consultant Administrator and is in pay schedule and range 07/32.

All applicants who may be appointed to this position will be required to allow DHS to conduct a background check to determine whether the circumstances of any conviction may be related to the job being filled.

For positions that allow remote working flexibility, working outside of Wisconsin or in bordering cities will not be allowed except in extremely limited circumstances due to the need to report to an office location in Wisconsin on short notice.

DHS does not sponsor work visas for this position, thus, in compliance with federal law, selected candidates will be required to verify eligibility to work in the United States by completing the required I-9 form upon hire.

Employees must have access to both a private workspace and secure high-speed internet for remote work option. Mileage reimbursement to the employee’s headquarter location is not provided. Remote work flexibility will be discussed in more detail during the interview process.

Minimally qualified applicants will have all of the following:

• Experience evaluating and consulting on data management techniques and tools and data warehousing or similar technology (e.g., data lakes, data marts, etc.).
• Experience providing technical consultation regarding data strategy, tool implementation, or data management, to individuals with varying technology backgrounds.
• Experience designing, developing, and managing relational databases (e.g., SQL Server, etc.).
• Experience using SQL and other programming languages (e.g., Python, r Java, etc.).

Well-qualified applicants will also have one or more of the following:

• Experience building, implementing, and managing data infrastructure in the cloud (e.g., data extraction, orchestration, storage, networking and cost management) in a government, health care, or public health setting.
• Experience in data extract, transformation, and load (ETL/ELT) techniques and execution.
• Experience building and implementing data architectures
• Education, training, or certification in computer science, data analytics, or related field.

Your letter of qualifications is limited to two (2) pages. For a guide on developing your resume and letter of qualifications and what should be included in these materials, click here.

Applying is easy! Click “Apply for Job” to start your application process. Sign into your account or create an account before applying for the job. Follow the steps outlined in the application process to submit your application.

Helpful Information:

• Once your application is submitted, no changes are allowed. Click “Save” to allow changes to your application as needed before submitting by the deadline.
• You may want to save a copy of the job posting for referencing after the deadline.
• Submitted materials will be evaluated by a panel of job experts according to the qualifications above.
• Please monitor your email for communications related to this position.
• Current or former permanent, classified, state employees must complete the online application process to be considered.
• If viewing through an external site, please apply directly at Wisc.Jobs.
• For technical assistance and general information, please see Frequently Asked Questions. For questions about the position, to request a copy of the full position description, or for other employment inquiries, please contact DHSDPHHR@dhs.wisconsin.gov.

DHS is an Equal Opportunity and Affirmative Action employer.

Veterans are encouraged to apply. For complete information on Veterans’ hiring programs with the WI Department of Veteran’s Affairs, click here.

The deadline to apply is March 10, 2025 at 11:59 PM. Applicants are strongly encouraged to allow ample time to finalize their applications keeping in mind that technical assistance is only available Monday through Friday 7:45 am – 4:30 pm. Late or incomplete applications will not be accepted.