Data Warehouse Architect 5 - Sr. ETL/BI Developer

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