Job Description

Position Overview

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.

Key Responsibilities

Data Warehouse Development & ETL Engineering

• 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.

BI, Reporting & User Engagement

• 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.

Technical Leadership & Cross‑Team Collaboration

• 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.

Governance, Quality Assurance & Change Management

• 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.

Impact Analysis & Technical Consulting

• 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.

Requirements

Education & Experience

• 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.

Technical Skills

• 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.

Soft Skills

• 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.

Preferred Qualifications

• 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.

Job Tags

Similar Jobs