CrawlJobs Logo

Data Warehouse Architect - Senior ETL/BI Developer

staffordgray.com Logo

The Stafford Gray Group

Location Icon

Location:
United States , Lansing, Michigan

Category Icon
Category:
IT - Software Development

Job Type Icon

Contract Type:
Not provided

Salary Icon

Salary:

Not provided
Save Job
Save Icon
Apply Position

Job Description:

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.

Job Responsibility:

  • 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

Nice to have:

  • 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

Additional Information:

Job Posted:
January 22, 2026

Work Type:
Hybrid work
Icon
The Stafford Gray Group - All Job Offers
Job Link Share:
Copy Link Icon
Facebook Icon Twitter Icon LinkedIn Icon

Looking for more opportunities? Search for other job offers that match your skills and interests.

Briefcase Icon

Similar Jobs for Data Warehouse Architect - Senior ETL/BI Developer

New

In Home Nursing LPN - Trach/Vent Young Adult (Weekend Overnights)

Location
Location
United States , Carrollton
Salary
Salary:
36.00 USD / Hour
aveanna.com Logo
Aveanna Healthcare
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Must have eligible good-standing license (LPN) for the state in which the clinician will practice
  • Current CPR certification
  • Must be comfortable providing in-home nursing care to infants, children, adolescents, and adults
Job Responsibility
Job Responsibility
  • Execution of physician’s prescribed plan of care and compliant documentation of care in system of record
  • Administration of prescribed medication, treatments, and therapies
  • Patient assessments and coordination of care
  • Health, promotion, teaching, and training of family members
What we offer
What we offer
  • Local/community cases allow us to match you to a case that’s close to home
  • 1-on-1 Personalized Care
  • 24/7 clinical and operational support for direct clinical, plus scheduling assistance
  • Competitive Weekly Pay
  • State-of-the-art technology allowing electronic charting at point of care
  • Flexible shifts and scheduling (8, 12, or 16-hour shifts
  • days/nights/weekends available)
  • Full-time and salaried career opportunities
  • Fulltime
Read More
Arrow Right
New

Bank Residential Support Worker - Children's Services

We are a growing, forward-thinking children’s residential care organisation with...
Location
Location
United Kingdom , Lanchester
Salary
Salary:
13.50 - 14.00 GBP / Hour
morethanloftladders.co.uk Logo
More Than Loft Ladders Worcester and Dudley
Expiration Date
June 12, 2026
Flip Icon
Requirements
Requirements
  • Children's residential care experience (preferred)
  • Full UK driving licence (essential) & access to a car (preferred)
  • Willingness to work a varied rota
Job Responsibility
Job Responsibility
  • Being a positive, grounding influence for young people
  • Building meaningful relationships based on trust
  • Supporting emotional development, independence, routines, learning & community involvement
  • Championing safeguarding and positive practice
  • Working as part of a supportive, reflective team
What we offer
What we offer
  • Frontline leadership support
  • Employee Assistance Programme
  • Birthday Off
  • Generous Referral Bonus
  • Wellness Allowance
  • Extra Annual Leave increasing with service
  • Donation Match Scheme
  • Fully Funded Qualifications (including Level 3 Residential Childcare Diploma)
  • Blue Light Card Access
  • Access to a Company Vehicle when needed for work
  • Fulltime
Read More
Arrow Right
New

EHS Specialist

Join Amazon’s mission to become Earth’s safest place to work! At Amazon, we’ve s...
Location
Location
United States , Aurora
Salary
Salary:
27.00 - 33.00 USD / Hour
Amazon
Expiration Date
May 17, 2026
Flip Icon
Requirements
Requirements
  • High school or equivalent
  • Knowledge of OSHA regulations, specifically 29 CFR 1910
  • A minimum of 1 year in an environmental Health & Safety (EHS) related field OR
  • A bachelors degree in EHS-relevant background OR
  • 6 months experience performing in a safety-related role within Amazon
  • Experience using Microsoft Word and Excel in a professional capacity
  • Experience maintaining confidentiality in matter involving security and/or personal issues in the workplace
Job Responsibility
Job Responsibility
  • Drive comprehensive safety programs through data-driven strategies
  • Lead daily safety audits, incident investigations, and risk assessments while implementing innovative solutions to prevent injuries
  • Deliver engaging safety training that resonates with associates and promotes a proactive safety culture
  • Champion continuous improvement initiatives that enhance workplace safety while maintaining operational efficiency
  • Serve as a trusted safety advisor and advocate for associate wellbeing, building strong partnerships across all levels of the organization
  • Foster a culture where safety is everyone's priority through effective communication, coaching, and positive reinforcement
  • Develop strong relationships with frontline associates and leadership to drive behavioral changes and ensure safety best practices become natural habits
  • Transform safety data into compelling narratives that influence positive change and drive engagement in safety initiatives
What we offer
What we offer
  • Sign-on payments
  • Restricted stock units (RSUs)
  • Health insurance (medical, dental, vision, prescription, Basic Life & AD&D insurance and option for Supplemental life plans, EAP, Mental Health Support, Medical Advice Line, Flexible Spending Accounts, Adoption and Surrogacy Reimbursement coverage)
  • 401(k) matching
  • Paid time off
  • Parental leave
  • Fulltime
!
Read More
Arrow Right
New

Residential Support Worker - Children's Services

We are a growing, forward-thinking children's residential care organisation with...
Location
Location
United Kingdom , London
Salary
Salary:
34416.00 - 35424.00 GBP / Year ▼
morethanloftladders.co.uk Logo
More Than Loft Ladders Worcester and Dudley
Expiration Date
June 14, 2026
Flip Icon
Requirements
Requirements
  • Experience working with children/young people
  • Willingness to work a varied rota
  • Children's residential care experience
  • Full UK driving licence & access to a car
Job Responsibility
Job Responsibility
  • Being a positive, grounding influence for young people
  • Building meaningful relationships based on trust
  • Supporting emotional development, independence, routines, learning & community involvement
  • Championing safeguarding and positive practice
  • Working as part of a supportive, reflective team
  • You will be flexible with your working days to meet the needs of the home, including evenings, weekends, and sleep-ins
What we offer
What we offer
  • Frontline leadership support
  • Employee Assistance Programme for emotional & wellbeing support
  • Your Birthday Off — every year, no questions asked
  • Generous Referral Bonus when you help brilliant people join the team
  • Wellness Allowance to support your physical & mental health
  • Extra Annual Leave increasing with service
  • Donation Match Scheme to back causes you care about
  • Fully Funded Qualifications (including Level 3 Residential Childcare Diploma)
  • Blue Light Card Access for discounts & perks
  • Access to a Company Vehicle when needed for work
  • Fulltime
Read More
Arrow Right
New

Sr. Applied Scientist

We are seeking a Senior Applied Scientist to join the Alexa Availability team wi...
Location
Location
India , Chennai
Salary
Salary:
Not provided
Amazon
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 3+ years of building machine learning models for business application experience
  • PhD, or Master's degree and 6+ years of applied research experience
  • Experience programming in Java, C++, Python or related language
  • Experience with neural deep learning methods and machine learning
Job Responsibility
Job Responsibility
  • Lead the research and development of machine learning and statistical models that power Alexa's reliability at scale
  • Work on complex problems including time series multivariate modeling, statistical anomaly detection, LLM-based operational intelligence, and adaptive threshold systems
  • Design and implement production-grade ML solutions
  • Establish rigorous model evaluation frameworks
  • Ensure LLM-powered systems are grounded, reliable, and free from systematic bias
  • Apply techniques such as RAG, confidence scoring, knowledge graph integration, and counterfactual testing
  • Partner with software engineers, product managers, and operations leaders
  • Drive the scientific agenda for the team
  • Mentor fellow scientists
  • Influence the broader Alexa Excellence organization through technical leadership and cross-team collaboration
  • Fulltime
Read More
Arrow Right
New

Ehs Specialist

Join Amazon’s mission to become Earth’s safest place to work! At Amazon, we’ve s...
Location
Location
United States , Phoenix
Salary
Salary:
27.00 - 33.00 USD / Hour
Amazon
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • High school or equivalent
  • Knowledge of OSHA regulations, specifically 29 CFR 1910
  • A minimum of 1 year in an environmental Health & Safety (EHS) related field OR
  • A bachelors degree in EHS-relevant background OR
  • 6 months experience performing in a safety-related role within Amazon
  • Experience using Microsoft Word and Excel in a professional capacity
  • Experience maintaining confidentiality in matter involving security and/or personal issues in the workplace
  • Must be available to work flexible shifts including days, nights and/or weekends
  • For those that do not have an adult First Aid, CPR, AED certification from the American Heart Association or American Red Cross, must obtain within 3 weeks of start date
Job Responsibility
Job Responsibility
  • Drive comprehensive safety programs through data-driven strategies
  • Lead daily safety audits, incident investigations, and risk assessments while implementing innovative solutions to prevent injuries
  • Deliver engaging safety training that resonates with associates and promotes a proactive safety culture
  • Champion continuous improvement initiatives that enhance workplace safety while maintaining operational efficiency
  • Serve as a trusted safety advisor and advocate for associate wellbeing, building strong partnerships across all levels of the organization
  • Foster a culture where safety is everyone's priority through effective communication, coaching, and positive reinforcement
  • Develop strong relationships with frontline associates and leadership to drive behavioral changes and ensure safety best practices become natural habits
  • Transform safety data into compelling narratives that influence positive change and drive engagement in safety initiatives
What we offer
What we offer
  • health insurance (medical, dental, vision, prescription, Basic Life & AD&D insurance and option for Supplemental life plans, EAP, Mental Health Support, Medical Advice Line, Flexible Spending Accounts, Adoption and Surrogacy Reimbursement coverage)
  • 401(k) matching
  • paid time off
  • parental leave
  • sign-on payments
  • restricted stock units (RSUs)
  • Fulltime
Read More
Arrow Right
New

Senior Product Manager - Technical, Quick Sight - Structured Data Analytics

Amazon Quick is a decision intelligence service for the AI era. Today, thousands...
Location
Location
United States , Seattle
Salary
Salary:
151200.00 - 204600.00 USD / Year
Amazon
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor's degree
  • Experience owning/driving roadmap strategy and definition
  • Experience with feature delivery and tradeoffs of a product
  • Experience contributing to engineering discussions around technology decisions and strategy related to a product
  • Experience managing technical products or online services
  • Experience in representing and advocating for a variety of critical customers and stakeholders during executive-level prioritization and planning
Job Responsibility
Job Responsibility
  • Drive product delivery in deep partnership with engineering, applied science, and design
  • Be hands-on with the technology
  • Own the customer journey from first contact through enterprise-wide adoption for critical engagement
  • Engage directly with enterprise customers, ISV partners, and AWS field teams
  • Directly contribute to business outcomes — adoption, revenue, competitive win rates, customer retention
What we offer
What we offer
  • Sign-on payments
  • Restricted stock units (RSUs)
  • Health insurance (medical, dental, vision, prescription, Basic Life & AD&D insurance and option for Supplemental life plans, EAP, Mental Health Support, Medical Advice Line, Flexible Spending Accounts, Adoption and Surrogacy Reimbursement coverage)
  • 401(k) matching
  • Paid time off
  • Parental leave
  • Fulltime
Read More
Arrow Right
New

It Sox Audit Consultant

We are seeking an IT SOX Audit Consultant to support IT Sarbanes-Oxley (SOX) com...
Location
Location
United States , Layton
Salary
Salary:
Not provided
https://www.roberthalf.com Logo
Robert Half
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 2–4 years of relevant experience
  • Strong working knowledge of logical access controls, including user provisioning, deprovisioning, and segregation of duties
  • Strong working knowledge of change management, including SDLC and code migration controls
  • Strong working knowledge of IT operations controls, including job monitoring, backups, and incident management
  • Experience with control testing methodologies
  • Experience with sampling approaches
  • Experience with reperformance testing techniques
  • Experience with audit evidence evaluation, not just evidence gathering
  • Experience with drawing conclusions regarding design and operating effectiveness
  • Understanding of SOX compliance frameworks
Job Responsibility
Job Responsibility
  • Perform IT SOX control testing and clearly document testing results
  • Participate in process walkthroughs with stakeholders
  • Update Risk and Control Matrices (RCMs) and process flows when changes to systems, environments, or controls are identified
  • Assess and document control design and operating effectiveness
  • Review and evaluate audit evidence, drawing initial conclusions based on findings
  • Prepare clear, organized, and defensible workpapers
  • Ensure audit procedures are properly aligned to control objectives and conclusions
What we offer
What we offer
  • Medical
  • Vision
  • Dental
  • Life and disability insurance
  • 401(k) plan
  • Fulltime
Read More
Arrow Right