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

Intake Coordinator

We are looking for an Intake Coordinator to support legal operations in Newark, ...
Location
Location
United States , Newark
Salary
Salary:
Not provided
https://www.roberthalf.com Logo
Robert Half
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Previous experience supporting client intake, records coordination, or administrative operations in a detail-focused setting
  • Ability to work accurately with client applications, document records, and high-volume data entry tasks
  • Familiarity with microfilm retrieval or archival record-handling processes is preferred
  • Experience using a content management system (CMS) to track, store, and manage information
  • Strong attention to detail and the ability to identify inconsistencies or missing documentation
  • Comfortable working in a production-driven environment with shifting priorities and deadlines
  • Effective written and verbal communication skills and a collaborative approach to problem-solving
Job Responsibility
Job Responsibility
  • Review and organize incoming client documents and application materials to ensure completeness and accuracy
  • Enter, update, and maintain case-related information within the content management system in a timely manner
  • Coordinate intake activities to support smooth document flow across a high-volume legal production environment
  • Retrieve, catalog, and manage records stored in microfilm and related archival sources when needed
  • Communicate with internal teams to clarify missing details and resolve discrepancies in submitted materials
  • Monitor intake queues and prioritize assignments to meet service expectations and operational deadlines
  • Prepare and maintain organized digital and physical files in accordance with established handling procedures
What we offer
What we offer
  • medical
  • vision
  • dental
  • life and disability insurance
  • 401(k) plan
  • Fulltime
Read More
Arrow Right
New

Store Associate

We're building a world of health around every individual — shaping a more connec...
Location
Location
United States , Brockton
Salary
Salary:
15.00 - 22.00 USD / Hour
https://www.cvshealth.com/ Logo
CVS Health
Expiration Date
July 04, 2026
Flip Icon
Requirements
Requirements
  • At least 16 years of age
  • Remaining upright on the feet, particularly for sustained periods of time
  • Lifting and exerting up to 35 lbs of force occasionally, up to 10 lbs of force frequently, and a negligible amount of force regularly to move objects to and from, including overhead lifting
  • Visual Acuity - Having close visual acuity to perform activities such as: viewing a computer terminal, reading, visual inspection involving small parts/details
Job Responsibility
Job Responsibility
  • Providing differentiated customer service by anticipating customer needs, demonstrating compassion and care in all interactions, and actively identifying and resolving potential service issues
  • Focusing on the customer by giving a warm and friendly greeting, maintaining eye contact and offering help locating additional items, when needed
  • Accurately perform cashier duties - handling cash, checks and credit card transactions with precision while following company policies and procedures
  • Maintaining the sales floor by restocking shelves, checking in vendors, updating pricing information and completing inventory management tasks as directed by store manager
  • Supporting opening and closing store activities, when needed
  • Providing customer support to all departments, including photo and beauty, ensuring departments are fully stocked and operational while remaining current with all updated services and tools
  • Assisting pharmacy personnel when needed, including working regular shifts in the pharmacy as part of opportunities for growth and career development
  • Embracing and advocating for new CVS services and loyalty programs that support our purpose of helping people on their path to better health
What we offer
What we offer
  • dental
  • vision
  • wellness resources
  • employee discounts
  • access to certain voluntary benefits
  • other programs
  • Parttime
Read More
Arrow Right
New

Surveillance Investigator

Allied Universal® is hiring a Surveillance Investigator. The Surveillance Invest...
Location
Location
United States , Odessa
Salary
Salary:
Not provided
aus.com Logo
Allied Universal®
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • High school diploma or equivalent
  • Post offer, must be able to successfully complete the Allied Universal Investigations' training/orientation course
  • Minimum of one (1) year of verifiable work experience, preferably involving investigations or other protective service-related field
  • Flexibility to work varied and irregular hours/days including weekends and holidays
  • Ability to type reports in Microsoft Word format with minimal grammatical and punctuation errors
  • Proficient in utilizing laptop computers, video cameras and cell phones
  • Capable of maintaining focus and multitasking effectively in a dynamic environment
  • Demonstrated ability to manage stressful situations with composure and professionalism
  • Ability to work in a very independent environment
Job Responsibility
Job Responsibility
  • Conduct independent investigations of insurance claims across a range of coverage types, including workers' compensation, general liability, property and casualty, and disability
  • Utilize various surveillance techniques and equipment to monitor subjects covertly
  • Document and report observations, activities, and any relevant information in a clear and concise manner
  • Collaborate with other investigators and law enforcement agencies as needed to gather information and coordinate efforts
  • Maintain confidentiality and adhere to legal and ethical standards in conducting surveillance operations
What we offer
What we offer
  • Medical, dental, vision, basic life, AD&D, retirement plan and disability insurance
  • Seven paid holidays annually, sick days available where required by law
  • Vacation time offered at an initial accrual rate of 3.08 hours biweekly
  • Auto and travel allowances
  • Fulltime
Read More
Arrow Right
New

Senior Accountant

We are looking for an experienced Senior Accountant to support essential account...
Location
Location
United States , New York
Salary
Salary:
Not provided
https://www.roberthalf.com Logo
Robert Half
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 6+ years of progressive accounting experience with strong involvement in operational accounting and ownership of month-end close activities
  • Bachelor's degree in Accounting or Finance
  • CPA is preferred
  • Solid knowledge of U.S. GAAP and foundational accounting practices
  • Demonstrated experience with general ledger accounting, journal entries, account reconciliations, and bank reconciliations
  • Background managing accounts payable activities and supporting payroll accounting processes
  • Experience preparing audit support materials and working with external auditors
  • Ability to manage multiple priorities effectively in a fast-paced environment while maintaining a high level of accuracy
  • Strong communication skills and a collaborative approach when partnering with cross-functional teams
Job Responsibility
Job Responsibility
  • Lead key aspects of the monthly close cycle, ensuring financial data is recorded accurately and reporting deadlines are met consistently
  • Manage general ledger activity by preparing and reviewing journal entries, maintaining supporting schedules, and resolving account discrepancies
  • Direct accounts payable workflows, including invoice review, payment processing, vendor coordination, and compliance with internal approval standards
  • Support payroll-related accounting by working with internal partners and external providers to reconcile payroll activity and record related month-end entries
  • Monitor cash transactions through routine tracking, bank reconciliations, and support for short-term cash planning activities
  • Oversee employee expense administration, including reimbursement processing, card reconciliation reviews, and adherence to company spending policies
  • Complete balance sheet reconciliations and investigate variances to strengthen accuracy across financial records
  • Assist with audit preparation by organizing documentation, responding to support requests, and helping maintain readiness for external review
  • Develop and refine accounting procedures to improve efficiency, reinforce controls, and create scalable operational practices
  • Collaborate with Finance, People Operations, and other business partners on accounting initiatives and process enhancements
What we offer
What we offer
  • medical insurance
  • vision insurance
  • dental insurance
  • life insurance
  • disability insurance
  • 401(k) plan
  • Fulltime
Read More
Arrow Right
New

Program Management Specialist

Mastercard powers economies and empowers people in 200+ countries and territorie...
Location
Location
Italy , Roma
Salary
Salary:
Not provided
mastercard.com Logo
Mastercard
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Previous 2-5 year of experience in all the aspects of product management (i.e. analyses of performances and consumer needs, operations, promotion and communication support to drive product performances, new product development, P&L ownership)
  • Previous Experience and knowledge of Loyalty Business and products
  • Strong business partnering / relationship management skills
  • Strong analytical skills
  • Attention to details and strong problem-solving skills
  • Operational focus / experience
  • Organization / project management – need to be able to keep track & manage multiple activities
  • Strong written and verbal communication skills and the ability to effectively communicate with different audiences, from low-level technical resources to customer leads
  • Ability to interact and coordinate effectively with internal and external business partners
  • Abide by Mastercard’s security policies and practices
Job Responsibility
Job Responsibility
  • Responsible for product management support for different Rewards & Offers products across Europe, with a focus on Merchants Offers Products
  • Support/manage all the operational aspects related to product changes/updates and new functionalities addition of the products managed
  • Develop and measure regional product performance through a data-driven, KPI-based framework
  • Proactively work with countries and customers to address new opportunities related to Rewards & Offers products
  • Work with customers to provide marketing suggestions and benchmarks on how to increase adoption and engagement of the different products managed
  • Analyze existing products and business models, internally and externally, to identify features issues/gaps and propose new improvements or areas of action
  • Take shared responsibility for growing the revenue of the Rewards and Offers business in Europe through effective and continually improving product management processes
  • Ensure global best practices for Rewards & Offers products are fully and consistently applied across the products managed in the different European Countries
  • Ensure relevant processes are followed to ensure quality and compliance
  • Support new product / new market readiness activities across the region
  • Fulltime
Read More
Arrow Right
New

Shift Supervisor

We’re building a world of health around every individual — shaping a more connec...
Location
Location
United States , Bowie
Salary
Salary:
17.30 - 26.30 USD / Hour
https://www.cvshealth.com/ Logo
CVS Health
Expiration Date
July 06, 2026
Flip Icon
Requirements
Requirements
  • Deductive reasoning ability, analytical skills and computer skills
  • Advanced communication skills and supervision skills
  • Ability to work a flexible schedule, including some early morning, overnight and weekend shifts, to work overtime as needed, and to respond to urgent issues at the store when they arise
Job Responsibility
Job Responsibility
  • Work effectively with store management and store crews
  • Supervise the store's crew through assigning, directing and following up of all activities
  • Effectively communicate information both to and from store management and crews
  • Assist customers with their questions, problems and complaints
  • Promote CVS customer service culture (Greet, offer help, and thank)
  • Handle all customer relations issues in accordance with company policy and promote a positive shopping experience for all CVS customers
  • Maintain customer/patient confidentiality
  • Price merchandise
  • Stock shelves
  • Execute the displays, sign and inventory of weekly, promotional, and seasonal merchandise
What we offer
What we offer
  • Dental
  • Vision
  • Wellness resources
  • Employee discounts
  • Access to certain voluntary benefits
  • Other programs
  • Parttime
Read More
Arrow Right
New

Surveillance Investigator

Allied Universal® is hiring a Surveillance Investigator. The Surveillance Invest...
Location
Location
United States , Houston
Salary
Salary:
Not provided
aus.com Logo
Allied Universal®
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • High school diploma or equivalent
  • Post offer, must be able to successfully complete the Allied Universal Investigations' training/orientation course
  • Minimum of one (1) year of verifiable work experience, preferably involving investigations or other protective service-related field
  • Flexibility to work varied and irregular hours/days including weekends and holidays
  • Ability to type reports in Microsoft Word format with minimal grammatical and punctuation errors
  • Proficient in utilizing laptop computers, video cameras and cell phones
  • Capable of maintaining focus and multitasking effectively in a dynamic environment
  • Demonstrated ability to manage stressful situations with composure and professionalism
  • Ability to work in a very independent environment
  • Must possess a valid driver's license with at least one year of driving experience
Job Responsibility
Job Responsibility
  • Conduct independent investigations of insurance claims across a range of coverage types, including workers' compensation, general liability, property and casualty, and disability
  • Utilize various surveillance techniques and equipment to monitor subjects covertly
  • Document and report observations, activities, and any relevant information in a clear and concise manner
  • Collaborate with other investigators and law enforcement agencies as needed to gather information and coordinate efforts
  • Maintain confidentiality and adhere to legal and ethical standards in conducting surveillance operations
What we offer
What we offer
  • Medical, dental, vision, basic life, AD&D, retirement plan and disability insurance
  • Seven paid holidays annually, sick days available where required by law
  • Vacation time offered at an initial accrual rate of 3.08 hours biweekly
  • Auto and travel allowances
  • Fulltime
Read More
Arrow Right
New

Human Resources Manager

We are looking for an experienced Human Resources (HR) Manager to support a Cont...
Location
Location
United States , Westwood
Salary
Salary:
Not provided
https://www.roberthalf.com Logo
Robert Half
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Demonstrated experience in human resources management with strong exposure to employee relations and HR administration
  • Working knowledge of employee benefit programs and the ability to support enrollment and related employee inquiries
  • Hands-on experience with HRIS platforms and maintaining accurate employee data
  • Ability to coordinate onboarding activities and manage multiple tasks in a fast-paced environment
  • Strong understanding of HR policies, employment practices, and documentation standards
  • Effective communication and interpersonal skills with the ability to work confidently with employees and leadership
  • Strong organizational skills and attention to detail when handling confidential information
Job Responsibility
Job Responsibility
  • Guide managers and employees on workplace concerns, helping resolve issues fairly and in alignment with company policies
  • Oversee daily human resources administration, including maintaining personnel records, supporting policy execution, and ensuring accurate documentation
  • Administer employee benefit programs by coordinating enrollments, answering questions, and assisting with issue resolution
  • Manage onboarding activities for new hires, ensuring a smooth start through timely paperwork, system setup, and orientation support
  • Maintain and update HRIS data to support reporting accuracy, compliance, and efficient HR operations
  • Partner with leadership to promote positive employee experiences and reinforce consistent people practices across the organization
  • Monitor HR processes for compliance with applicable employment regulations and internal standards
  • Support HR-related operational changes or system updates as needed, including process adjustments tied to business requirements
What we offer
What we offer
  • Medical insurance
  • Vision insurance
  • Dental insurance
  • Life and disability insurance
  • 401(k) plan
Read More
Arrow Right