Data Warehouse ETL/BI Developer – Teradata / Child Welfare

Location: Lansing, MI (MI) | Employment Type: Full Time - 40 hours per week | Job Level: T4 | Work Preference: Hybrid | Job Code: 244539

Job Description:

Senior Data Warehouse ETL/BI Developer (Hybrid)

Overview / Summary

The Senior Data Warehouse ETL/BI Developer functions as a senior information technology analyst responsible for developing, maintaining, and enhancing automated data warehouse applications on the Teradata Data Warehouse platform.

This position represents the Data Warehouse Team and coordinates team activities with other data warehouse teams on complex, multi-team projects. The role also works with data warehouse developers to review existing policies and practices, modify them as needed, or propose new policies and practices.

The position is part of the Data Warehouse Team and requires knowledge of SQL, Business Intelligence tools, and relational databases to develop and maintain data warehouse ETL processes and queries.

Key Responsibilities

Develop, maintain, and enhance automated data warehouse applications on the Teradata Data Warehouse platform.
Represent the team and coordinate activities with other data warehouse teams on complex, multi-team projects.
Review existing data warehouse policies and practices, modify them as needed, and propose new policies or practices.
Work with data warehouse developers to develop and maintain ETL processes and queries.
Work independently with little direction.
Communicate effectively with programmers, analysts, supervisors, management, system users, operations, State agencies, and private-sector organizations.
Meet with users to clarify and elaborate requirements, define problems, and develop development plans.
Gather, correlate, and analyze facts; identify problems; develop solutions and alternatives; and make recommendations.
Work with Data Modelers and developers to facilitate modifications to logical designs and create physical designs suited to customer reporting needs.
Design applications considering data reconciliation to source systems, query/reporting performance, and analytical business value.
Present gathered information with the Business Analyst to Project Review Boards, Project Sponsors, project workgroups, and Technical Review Boards.
Consult with agency clients regarding complex IT processes and solutions.
Maintain effective communication plans with DTMB and agency clients regarding project-level metrics and bureau-level project reporting.
Assist Architects or DBAs in drafting technical database models that comply with audit separation-of-duty requirements, capture data-element requirements, and support application needs.
Review and approve updates to systems documentation.
Gather, review, and analyze potential impacts of proposed legislation, enhancement requests, government requests, and changes in governmental processes or procedures.
Provide technical expertise to DTMB AS PMO Managers and client agency managers and supervisors for IT project estimating and budgeting.
Serve as a team lead and development resource by directing code development and providing advice and guidance to development staff.
Evaluate and identify opportunities for programming process or tool standardization.
Perform disaster recovery planning and implementation.
Provide input to procedures and ensure proper change management for requested production-system fixes.
Review and approve test plans and incorporate identified security requirements into test plans.

Required Qualifications

Bachelor’s degree or equivalent technical study.
6+ years creating Data Warehouse BI applications, including ETL/data mart development, reporting, dashboards, and other information analysis and delivery systems.
2+ years of experience in Child Welfare Services, Juvenile Justice, Juvenile Services, or other related experience.
Knowledge of SQL.
Knowledge of Business Intelligence tools.
Experience with relational databases.

Preferred Skills

SQL Assistant/Teradata Studio experience.
Ability to work independently with little direction.

Other Desired Skills

Experience with the PMM/SUITE/Agile methodology.
End-user training experience.
Strong verbal and written communication skills.
Experience working with Data Modelers and developers.
Experience with data reconciliation, query/reporting performance, and analytical business value.
Experience presenting information to project review boards, project sponsors, project workgroups, and Technical Review Boards.
Experience consulting with agency clients regarding complex IT processes and solutions.
Experience with technical database modeling and systems documentation.
Experience analyzing impacts and risks to existing IT solutions.
IT project estimating and budgeting experience.
Team leadership and code-development guidance experience.
Experience with programming process or tool standardization.
Disaster recovery planning and implementation experience.
Experience with change management for production-system fixes.
Experience reviewing and approving test plans and incorporating security requirements into testing.

What Makes HTC A Great Place To Build Your Future

HTC Global Services wants you to join our team. Come build new things with us and advance your career. At HTC Global, you’ll collaborate with experts, work alongside clients, and be part of high-performing teams driving success together. You’ll have long-term opportunities to grow your career and develop skills in the latest emerging technologies.

At HTC Global Services, our employees have access to a comprehensive benefits package. Benefits can include Group Health (Medical, Dental, and Vision), Paid Time Off, Paid Holidays, 401(k) matching, Group Life and Disability insurance, Professional Development opportunities, Wellness programs, and a variety of other perks.

Our success as a company is built on inclusion and diversity. HTC Global Services is committed to providing a workplace free from discrimination and harassment, where every employee is treated with dignity and respect. We celebrate differences and believe that diverse cultures, perspectives, and skills drive innovation and success. HTC is an Equal Opportunity Employer and a proud National Minority Supplier. We seek to empower each individual, fostering an environment where everyone feels valued, included, and respected.

Apply Now