Senior Data Warehouse Architect, ETL/BI Developer
Stafford Gray LLC
contract
Posted on:
Location Type: Hybrid
Location: Lansing • Missouri • United States
Visit company websiteExplore more
Job Level
About the role
- 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.
- 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.
- 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.
- 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.
- 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
- 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.
- 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.
- 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.
- 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.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
ETL processesdata martsBI applicationsadvanced SQLdata modelingdataset preparationreportingdashboardsperformance optimizationdisaster recovery
Soft Skills
communication skillsanalytical skillsproblem identificationsolution designindependent workleadershipcollaborationdocumentationtrainingprocess improvement
Certifications
Bachelor's degreetechnical training