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

Certified Lifeguard

Calling all aquatic regulators! At Goldfish Swim Schools, being a lifeguard mean...
Location
Location
United States , Yonkers
Salary
Salary:
16.50 - 17.50 USD / Hour
goldfishswimschool.com Logo
Goldfish Swim School
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Must have active Lifeguard certification
  • Weekend availability required
  • Ability to work with children
  • Excellent interpersonal communication and organizational skills
  • Must pass background examinations (included with training)
  • High School Diploma/GED required
  • Some College preferred
  • Lifeguard, CPR/AED, and First Aid certification will be required (or complete within 3 months of employment)
Job Responsibility
Job Responsibility
  • Maintains constant surveillance of patrons in the facility
  • acts immediately and appropriately to secure safety of guests in the event of an accident or emergency
  • Communicates the rules of the facility to patrons fairly and consistently
  • Provides emergency care and treatment as required until the arrival of emergency medical services
  • Ensures that medical services are contacted by most appropriate means when necessary to respond to an emergency
  • Advance through cross-training in multiple roles and substitutes when necessary
  • Assists with cleaning/maintenance as necessary during the shift
  • Provide a Golden Experience to our students, families, and team members
What we offer
What we offer
  • Bonus based on performance
  • Company parties
  • Employee discounts
  • Flexible schedule
  • Free uniforms
  • Training & development
  • Paid training to kickstart your career
  • Opportunities for promotions and growth
  • Flexible hours, even just one shift per week (4 hours)
  • No late nights, with afternoon shifts ending at 8 pm
  • Parttime
Read More
Arrow Right
New

Swim Instructor

Calling all aquatic ambassadors! At Goldfish Swim Schools, being a swim instruct...
Location
Location
United States , New Rochelle
Salary
Salary:
16.50 - 17.00 USD / Hour
goldfishswimschool.com Logo
Goldfish Swim School
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Must pass background examinations (included with training).
  • Ability to work with children
  • Excellent interpersonal communication and organizational skills
  • High School Diploma/GED required, Some College preferred
  • Must pass background examinations (included with training)
Job Responsibility
Job Responsibility
  • Provides swim instruction based on the Goldfish Swim School curriculum
  • Enforces safety rules and regulations to prevent accidents
  • Evaluates students’ progress and completes required documentation in a timely manner
  • Interacts professionally with parents/guardians after each swim lesson on the activities and development of students’ swim skills
  • Uses problem-solving and creative thinking skills to identify and resolve challenges that students encounter
  • Assists with setting up the pool prior to lessons and cleaning up after lessons, including proper storage of all pool equipment and lane lines
  • Attend required/mandatory workshops and in-service training outside of regular working hours
What we offer
What we offer
  • Employee discounts
  • Bonus based on performance
  • Company parties
  • Flexible schedule
  • Free uniforms
  • Training & development
  • Paid training
  • Opportunities for promotions and growth
  • Flexible hours, even just one shift per week (4 hours)
  • No late nights, with afternoon shifts ending at 8 pm
  • Parttime
Read More
Arrow Right
New

General Manager

Are you looking for a great gig where the work is actually fun? Do you want to w...
Location
Location
United States , New Rochelle
Salary
Salary:
Not provided
goldfishswimschool.com Logo
Goldfish Swim School
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Ability to work with children
  • Excellent interpersonal communication and organizational skills
  • Must pass background examinations (included with training)
  • High school diploma or GED required
  • Lifeguard, CPR/AED and First Aid certifications required
Job Responsibility
Job Responsibility
  • Directs and controls the daily operations to ensure the school is running per GSS standard operating procedures
  • Manages the staff of GSS to ensure high productivity, excellent performance and positive employee satisfaction
  • Trains and oversees aquatics department to provide superior swim instruction to the students of GSS
  • Interacts with the Deck Supervisors and Lead Teachers on issues related to class scheduling, student progress, customer service and employee performance and training
  • Provides sales and marketing training to all qualified sales staff
  • Provides direction in the retail and vending departments to ensure a proper mix of products and pricing is achieved
  • Trains and oversees private party staff to ensure that the GSS standard operating procedures are being maintained
  • Gains knowledge and experience in the school's technology and software to achieve a high level of competence in bookings, class scheduling, reporting and administrative functions
  • Gains a high level of knowledge and experience in the GSS pool operations necessary to maintain a safe and sanitary swim environment
  • Initiates and oversees workplace employee activities (Fun Department) with the goal of achieving improved employee satisfaction
What we offer
What we offer
  • Leadership roles
  • Flexible hours
  • Great pay
  • Valuable work experience
  • Increased social opportunities
  • Future references/referrals
  • Paid training
  • Flexible scheduling
  • Paid on-the-job training
  • Shout awards
  • Fulltime
Read More
Arrow Right
New

Tui Service Support Rep

As a TUI Rep, you’ll be at the heart of each guest’s journey, creating unforgett...
Location
Location
Portugal , Funchal
Salary
Salary:
16000.00 EUR / Year
https://www.tui.com Logo
TUI
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Right to work in Portugal
  • Live in or close to Funchal
  • Fully conversational in English
  • Hold a driving license
  • Own a car
Job Responsibility
Job Responsibility
  • Create special moments for guests
  • Engage with guests to identify needs and offer tailored recommendations
  • Promote and sell experiences to match products with guests’ preferences
  • Handle changes and challenging situations
  • Collaborate with colleagues, teams, suppliers, and partners
  • Monitor progress with sales and service updates and guest feedback
What we offer
What we offer
  • Competitive salary starting at 16,000€ gross/year
  • Company iPad
  • Uniform provided
  • 1.5 days off per week
  • 2 days of holidays per month
  • 37.5 working hours per week
  • Food allowance of 8.32€ per day worked
  • Paid training days
  • Free access to TUI Learning Hub, TUI Skills Academy & language lessons
  • Charity and sustainability initiatives
  • Fulltime
Read More
Arrow Right
New

Facility Maintenance And Cleaning

Company Overview Greetings! Welcome to Goldfish Swim School of Bethlehem! The #1...
Location
Location
United States , Bethlehem
Salary
Salary:
13.50 USD / Hour
goldfishswimschool.com Logo
Goldfish Swim School
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • High school diploma or equivalent GED required
  • 1+ year of experience as a cleaning personal, janitor or maintenance professional preferred
Job Responsibility
Job Responsibility
  • Responsible for cleaning all windows
  • Responsible for cleaning all bathrooms
  • Responsible for dusting changing huts, vents, storage units and front desk surfaces
  • Responsible for vacuuming facility
  • Responsible for cleaning all mirrors
  • Responsible for cleaning staff kitchen
  • Responsible for refilling shower products
  • Responsible for restocking retail items
  • Responsible for taking out trash
  • Responsible for spot cleaning and making sure facility is presentable
What we offer
What we offer
  • Paid Training
  • Flexible Schedules
  • All Are Welcome
  • Make Waves...In Your Community
  • Make Waves...In Your Career
  • High Fives & Tropical Vibes
  • Going for Gold!
  • Grow with Goldfish
  • Parttime
Read More
Arrow Right
New

Sales & Customer Service Representative

Location
Location
United States , Bethlehem
Salary
Salary:
15.00 USD / Hour
goldfishswimschool.com Logo
Goldfish Swim School
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Ability to work with children
  • Ability to work with families in a fast-paced environment
  • Experience with lead follow up and lead generation
  • Comfortable engaging with leads and leads follow up
  • Comfortable selling our swim program / product
  • Comfortable with lead conversion and lead tasks
  • Intermediate level computer skills required using Word, Excel, Google workspace
  • Great phone skills
  • Professional, kind and patient
  • Excellent interpersonal communication and organizational skills
Job Responsibility
Job Responsibility
  • Answers telephones, responds to inquiries, takes messages and screens and directs phone calls in a professional manner
  • Processes student registrations using effective sales/customer service techniques
  • Schedules and manages birthday/pool parties, if applicable
  • Resolves customer concerns/complaints using a professional approach
  • Assists members with purchases of merchandise and vending
  • Greets parents and students as they report to the front desk
  • Maintains cleanliness of the front desk area, Snack Shack area, changing areas, restrooms and observation area
  • Checks voicemail and email correspondence and responds in a timely manner
  • Updates informational displays with accurate and timely promotions and literature
  • Provides occasional administrative support for management personnel, including the General Manager and Assistant General Manager
What we offer
What we offer
  • Leadership roles
  • Competitive pay
  • Valuable work experience
  • Increased social opportunities
  • Future references /referrals
  • Paid Training
  • Flexible Schedules
  • Parttime
Read More
Arrow Right
New

Adaptive/Special Needs Swim Instructor-Golden Learner

Saving and changing lives, every single day. We have a mission to help children ...
Location
Location
United States , Roswell
Salary
Salary:
14.00 - 16.00 USD / Hour
goldfishswimschool.com Logo
Goldfish Swim School
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Experience working with children, especially children with special needs, preferred
  • Patient, compassionate, and positive attitude
  • Excellent communication and organizational skills
  • Ability to adapt teaching methods to meet individual swimmer needs
  • High energy and strong work ethic
  • Comfortable working in the water and leading group or one-on-one instruction
  • Must pass background examinations prior to training
Job Responsibility
Job Responsibility
  • Teach swimmers with varying abilities and special needs through our Golden Learner program using adaptive teaching techniques in accordance with our proprietary curriculum
  • Provide individualized support, encouragement, and positive reinforcement to swimmers
  • Foster a safe, patient, and inclusive learning environment
  • Communicate with parents and caregivers regarding swimmer progress and achievements
  • Collaborate with team members to ensure the best experience for all swimmers
What we offer
What we offer
  • Family discount for lessons
  • Flexible schedule
  • Free uniforms
  • Training & development
  • Paid on-the-job training
  • Flexible scheduling
  • Culture-driven company
  • Employee recognition programs
  • Rewarding opportunity to make a difference in children's lives
  • Parttime
Read More
Arrow Right
New

Part Time Swim Instructor

As a Swim Instructor, you are the face of the Goldfish curriculum. You'll help c...
Location
Location
United States of America , Louisville
Salary
Salary:
15.00 USD / Hour
goldfishswimschool.com Logo
Goldfish Swim School
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Experience: Non required. If you love working with kids, we will train you!
  • Background: Previous experience as a lifeguard, youth coach, camp counselor, or childcare provider preferred.
  • Skills: Strong communication skills and the ability to pass a background check.
  • Education: High school diploma or GED preferred.
Job Responsibility
Job Responsibility
  • Teach & Inspire: Provide high-quality swim instruction based on our proven curriculum.
  • Safety First: Enforce pool rules, prevent accidents, and maintain a safe environment.
  • Communicate: Act as a brand ambassador, giving parents regular updates on their child's progress and 'small wins.'
  • Problem Solve: Use creativity to help students overcome fears and reach their milestones.
  • Maintain Excellence: Ensure the pool area and equipment are clean, organized, and ready for class.
What we offer
What we offer
  • Employee discounts
  • Flexible schedule
  • Free uniforms
  • Training & development
  • Employees children swim free!
  • Paid Training
  • Flexible Schedules
  • Parttime
Read More
Arrow Right