Stafford Gray, LLC · 20 hours ago
Data Warehouse Architect - Senior ETL/BI Developer
Lansing, Michigan, United States
Full-time
Hybrid
Senior LevelStafford Gray, LLC is seeking a Senior Data Warehouse ETL/BI Developer responsible for designing and maintaining enterprise-level data warehouse applications. The role involves collaboration across multiple teams to support complex data initiatives, ensuring data accuracy and performance.
Cloud ComputingConsultingCyber Security
Responsibilities
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
Qualification
Required
Strong SQL expertise
Data-warehouse architecture knowledge
Ability to work independently
Skills to collaborate with business stakeholders, analysts, developers, DBAs, and review boards
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
Company
Stafford Gray, LLC
Technology consulting and services.
11-50 employees
H1B Sponsorship
Stafford Gray, LLC has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (2)
Funding
Current Stage
Early StageLeadership Team
Ward Beauchamp
President and CEO
Company data provided by crunchbase