Data Warehouse Architect - Senior ETL/BI Developer

Stafford Gray•Lansing, MI

About The Position

The Senior Data Warehouse ETL/BI Developer is responsible for designing, developing, enhancing, and maintaining enterprise‑level data warehouse applications within a large‑scale Teradata environment. The role supports complex data initiatives across multiple teams, including ETL engineering, data‑mart development, BI/reporting support, technical leadership, and coordinated project delivery. This position requires strong SQL expertise, data‑warehouse architecture knowledge, the ability to work independently, and the skills to collaborate with business stakeholders, analysts, developers, DBAs, and review boards.

Requirements

Bachelor’s degree or equivalent technical training.
6+ years of experience building data‑warehouse BI solutions, including ETL, data‑mart development, reporting, and dashboards.
2+ years of experience in child‑welfare, juvenile‑justice, or related human‑services domains.
Strong SQL proficiency, including experience working with Teradata tools such as SQL Assistant or Teradata Studio.
Proven experience developing ETL processes, data marts, and physical data‑warehouse models.
Understanding of DW concepts, relational modeling, reconciliation techniques, and performance optimization.
Experience collaborating with architects and DBAs on secure and scalable database designs.
Ability to work independently with minimal supervision.
Excellent written and verbal communication skills.
Strong analytical skills, including problem identification, fact‑gathering, and solution design.
Comfortable leading meetings, explaining technical topics, and presenting to leadership groups.

Nice To Haves

Experience with structured project‑management or Agile methodologies such as PMM/SUITE/Agile.
Previous experience leading code‑development tasks or mentoring developers.
Familiarity with test‑plan development, QA processes, and incorporating security requirements.
Experience in identifying opportunities for tool or process standardization.

Responsibilities

Design, develop, and maintain ETL processes, data marts, and BI applications on a Teradata data‑warehouse platform.
Write advanced SQL queries, transformations, and scripts supporting reporting, dashboards, and analytical workflows.
Collaborate with data modelers to optimize physical data models for reporting, reconciliation, and performance.
Ensure all solutions consider data accuracy, query performance, security requirements, and business value.
Support BI/reporting development through data modeling, dataset preparation, and optimized ETL feeds.
Meet with end users to gather requirements, clarify needs, and refine analytics and reporting deliverables.
Provide documentation updates, end‑user support, and training as needed.
Represent the data‑warehouse team on multi‑team initiatives and coordinate work across parallel DW projects.
Present technical findings, solutions, and design proposals to review boards and project leadership.
Offer expert guidance to other developers and contribute to process improvements and coding standards.
Review and approve test plans, ensuring all required security controls and validation steps are included.
Participate in change‑management processes and ensure all documentation is properly maintained.
Support disaster‑recovery planning and implementation for data‑warehouse components.
Analyze the impact of system changes, new legislation, business‑process changes, and enhancement requests on existing solutions.
Provide estimates, technical recommendations, and input for planning and budgeting activities.