Data Warehouse Architect 5 - Sr. ETL/BI Developer

Vital Tech Solutions • Lansing, MI

1d

About The Position

This role serves as a senior -level information technology analyst responsible for the design, development, enhancement, and support of enterprise -scale data warehouse applications built on a Teradata -based platform. The position plays a key role in complex, multi -team initiatives, coordinating work across data warehouse, reporting, and analytics teams. In addition, the role contributes to the evaluation and evolution of data warehouse standards, policies, and best practices.

The position requires strong expertise in SQL, Business Intelligence tools, and relational data warehouse concepts to support ETL processes, data marts, analytical queries, and reporting solutions in a highly regulated environment.

Requirements

• Bachelor’s degree or equivalent technical education
• 6+ years of experience developing data warehouse and BI solutions, including ETL, data marts, dashboards, reporting, and analytics delivery
• 2+ years of experience supporting complex, regulated program domains (e.g., human services, justice systems, or similarly structured enterprise data environments)

Nice To Haves

• Experience working within Agile or hybrid project management methodologies
• Strong SQL development experience on large -scale data warehouse platforms (e.g., Teradata)
• Experience supporting BI tools and end -user reporting
• Ability to work independently with minimal supervision
• Strong written and verbal communication skills across technical and non -technical stakeholders

Responsibilities

• Collaborate with business and technical teams to clarify requirements, define solutions, and develop implementation plans
• Analyze complex data needs and translate them into performant physical data models optimized for reporting and analytics
• Design solutions with attention to data reconciliation, performance, auditability, and business value
• Partner with architects, DBAs, and data modelers to develop and maintain compliant database designs
• Provide technical leadership, including code reviews, guidance to developers, and support for development standards
• Present technical findings and recommendations to project stakeholders and governance groups
• Assess impacts of enhancements, regulatory changes, or policy -driven requirements on existing systems
• Contribute to disaster recovery planning, change management processes, testing strategies, and production support

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level