Data Warehouse Architect

Codeworks is an IT Services firm headquartered in SE Wisconsin, known for our strong commitment to quality and for our direct client relationships.

Position Summary

Codeworks is seeking a Data Warehouse Architect to develop, maintain, and enhance automated data warehouse applications. This role will focus on ETL/data mart development, reporting, dashboards, and other BI solutions. The ideal candidate will work cross-functionally between ETL and BI tasks, ensuring data integrity and optimal performance. Experience with Snowflake and Databricks is highly preferred.

Key Responsibilities

• Design and develop data warehouse BI applications, including ETL and reporting solutions.
• Collaborate with cross-functional teams to gather requirements and deliver scalable solutions.
• Review and enhance data warehouse policies and practices.
• Perform audits, troubleshoot issues, and ensure compliance with standards.
• Provide technical expertise for project estimating, budgeting, and architecture design.
• Lead and mentor development teams, ensuring best practices and quality standards.

Required Skills & Experience

• Bachelor’s degree or equivalent technical study.
• 6+ years creating Data Warehouse BI applications, including ETL/data mart development, reporting, and dashboards.
• 2+ years of experience in Child Welfare Services, Juvenile Justice, or related areas.
• Strong SQL skills and experience with Teradata Studio or similar tools.
• Ability to work independently and communicate effectively with stakeholders.

Preferred Qualifications

• Experience with Snowflake and Databricks.
• Familiarity with Agile methodologies and State of Michigan PMM/SUITE.
• Experience with end-user training and change management.

About Codeworks

Codeworks has over 25 years of experience serving Fortune 1000 companies in Wisconsin as well as our client's national locations. Our recruiting team excels at evaluating, advising, and connecting IT professionals with new opportunities that will satisfy their expectations regarding income and opportunity for growth. At Codeworks, we're committed to diversity, equity, and inclusion in our workforce and beyond. We believe in equal opportunities and value the unique perspectives that every individual brings to our team. Join us in creating an inclusive, innovative, and collaborative workplace where your talents can thrive.

Codeworks, an LRS company, is an equal opportunity employer. Applicants for employment will receive consideration without unlawful discrimination based on race, color, religion, creed, national origin, sex, age, disability, marital status, gender identity, domestic partner status, sexual orientation, genetic information, citizenship status or protected veteran status.

Codeworks discloses that the anticipated hourly pay range for this position is between $93 and $109. This range is subject to change based on job-related factors, including client requirements where applicable.

All full-time Codeworks employees are eligible to enroll in the company’s medical, dental, vision, and life insurance plans.

This position is a 1-year contract with possible extension. Location: Lansing, MI. Candidates must be local within 2 hours of Lansing and able to work hybrid (in-office 2 days per week). There is no remote-only option.

In some cases, Codeworks, an LRS company, uses generative artificial intelligence (“AI”) in support of our hiring processes. LRS takes steps to ensure the use of AI does not result in discrimination based on protected class(es). AI may be used in the hiring process solely in support of the assessment of candidate qualifications. All decisions in the hiring process are made by LRS employees. If AI will be used in the hiring process for the position for which you are applying, you will be notified and will have the opportunity to opt out. Please contact [email protected] with any questions.