Data Warehouse Architect 5 - Sr. ETL/BI Developer Job at Vital Tech Solutions, Lansing, MI

SEVYREtsOHBZWXNFRyt3dHMvZ3ZaVkE0L1E9PQ==
  • Vital Tech Solutions
  • Lansing, MI

Job Description

Senior Data Warehouse / ETL & BI Developer

Position Overview

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.

 

Key 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

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)

Preferred / Additional Qualifications

  • 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

Vital Tech Solutions is an Equal Opportunity Affirmative Action employer. We prohibit discrimination in decisions concerning recruitment, hiring, compensation, benefits promotions, training, termination or any other condition of employment or career development.

All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, marital status, national origin, veteran status, disability status or any other legally protected status

Job Tags

Contract work,

Similar Jobs

BMO US

Director - Portfolio Management Commercial/Corporate Banking Job at BMO US

 ...lending decisions and processes for new and existing Commercial banking loans and credit solutions in an assigned portfolio of clients....  ...in credit or lending instruments or financial operations in a corporate or banking environment. Bachelors degree required, Masters... 

Downtown Overland Park Partnership

Events and Promotions Director Job at Downtown Overland Park Partnership

 ...enhance the overall experience of Downtown Overland Park for residents, businesses, and visitors.Position Summary:The Event and Promotions Director is a key member of the DOPP team, responsible for the planning, execution, and promotion of events and campaigns that support... 

NRG

Business Process Analyst Job at NRG

 ...encourage you to take charge of your career and development journey. We invite you to explore exciting opportunities across our businesses. Youll find that our dynamic work environment provides variety and challenge. Your growth is key to our ongoing successtake the... 

Merck & Co.

Scientist, Drug/Device Combo Products Job at Merck & Co.

 ...including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance Search Firm Representatives Please Read Carefully- Merck & Co., Inc., Rahway, NJ, USA, also known as Merck Sharp & Dohme LLC, Rahway, NJ, USA, does not accept unsolicited assistance from... 

Active Dental

Front Office Receptionist Job at Active Dental

 ...Come see why the Active Dental culture is different! Active Dental looking to add a dental Front Office Receptionist in Irving, TX! Candidates with no experience are welcome to apply! Competitive compensation, Respect, Bonuses, and Mentorship! Do you have a natural...