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

dnlUWi9iVlNJb2tzTS82NU5hYnhVcW5FTnc9PQ==
  • 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

Comic Book Resources (CBR)

Anime Features Writer Job at Comic Book Resources (CBR)

 ...This is a paid freelance, remote position. CBR is the #1 entertainment website and publishes up-to-the-minute news on blockbuster movies...  ..., sports, technology, automotive, gaming, lifestyle and travel. Valnet is committed to producing premium content, and we therefore... 

Johns Hopkins Medicine

Supply Chain Performance Improvement Analyst Job at Johns Hopkins Medicine

 ...Summary The Supply Chain Performance Improvement Analyst is responsible for assessing, identifying, and implementing performance improvement...  ...or residency/externship experience in the supply chain or healthcare-related field, or applicants with a Masters Degree (MBA,... 

Cennox

Legal Assistant and Licensing Administrator Job at Cennox

 ...We are seeking a highly organized, proactive, and detail-oriented Legal Assistant and Licensing Administrator to provide comprehensive support to our legal team. This position plays a critical role in managing administrative operations, coordinating licensing compliance... 

Nutrition that Works, LLC

Registered dietitian Job at Nutrition that Works, LLC

 ...Registered Dietitian Part-Time | Buzzards Bay, MA Nutrition That Works, LLC is seeking a registered dietitian to support a 99-bed...  ...Documenting with the Nutrition Care Process in the electronic medical record system Collaborating with the interdisciplinary care... 

University of Vermont

Assistant/Associate Professor - Orthopaedic Spine Surgeon Job at University of Vermont

 ...Larner, M.D. College of Medicine at The University of Vermont and The University of Vermont Health Network is seeking an orthopaedic spine surgeon for a full-time position as assistant or associate professor on the clinical scholar pathway. Responsibilities include elective...