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

Forklift Driver Cold Environment

Randstad Ville Saint-Laurent is looking for a Forklift Operator working in a ref...
Location
Location
Canada , Saint-Laurent
Salary
Salary:
20.00 - 23.00 USD / Hour
https://www.randstad.com Logo
Randstad
Expiration Date
June 29, 2026
Flip Icon
Requirements
Requirements
  • Have experience with standing and medium in low temperature or refrigerated
  • Have a valid forklift card
  • Be comfortable with computers
  • Be resourceful and self-sufficient
Job Responsibility
Job Responsibility
  • Operate a stand up Raymond lift truck safely - Double Reach
  • Stocking, ability to move goods at height
  • Work in a low temperature environment
  • Order picking
  • Use of computer tool - scanner
What we offer
What we offer
  • Salary: $20 to $23 per hour based on experience
  • Great company in constant growth
  • Permanent and stable position
  • Social benefits after 3 months
  • Possibility to start quickly
  • Accessible by public transport and on-site parking
  • Fulltime
Read More
Arrow Right
New

Fixed Income Technical Lead - Vice President

Engineer the future of global finance. At Citi, our Tech team doesn't just suppo...
Location
Location
United Kingdom , Belfast
Salary
Salary:
Not provided
https://www.citi.com/ Logo
Citi
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Experience working in a front office support environment
  • Business knowledge/ understanding of financial markets and products, particularly Credit and Rates Derivatives Flow
  • IT/spreadsheet/analytical/modelling skills
  • Good UNIX (Solaris/Linux) knowledge and practical usage
  • Extensive Oracle SQL knowledge and practical usage
  • Previous experience of electronic markets and straight through processing
  • Strong analytical skills & attention to detail
Job Responsibility
Job Responsibility
  • Provide user and batch support for trade booking application 'Finance Workstation' and 'Positions'
  • Start of day checks, continuous monitoring of application and underlying infrastructure
  • Expected to be able to raise problems to appropriate technology and business teams, while adhering to Service Level Agreements
  • Develop and maintain technical support documentation
  • Act as a liaison between users/traders, interfacing internal technology groups and vendors
  • Participate in application releases, testing and deployment into production
  • Perform post release checkouts after application releases and infrastructure updates
  • Active involvement in and ownership of Support Project items, covering Stability, Efficiency and Effectiveness initiatives
  • Good interpersonal and communication skills, great teammate
What we offer
What we offer
  • 27 days annual leave (plus bank holidays)
  • A discretional annual performance related bonus
  • Private Medical Care & Life Insurance
  • Employee Assistance Program
  • Pension Plan
  • Paid Parental Leave
  • Special discounts for employees, family, and friends
  • Access to an array of learning and development resources
  • Fulltime
Read More
Arrow Right
New

Senior Data Engineer (Contractor)

As a Senior Data Engineer, you’ll design, build, and operate scalable, reliable ...
Location
Location
Poland , Warsaw
Salary
Salary:
Not provided
mypos.com Logo
myPOS
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor's degree in Computer Science, Engineering, or a related technical field (or equivalent practical experience)
  • 6+ years of experience as a Data Engineer, building and maintaining production-grade pipelines and datasets
  • Strong Python and SQL skills with a solid understanding of data structures, performance, and optimization strategies
  • Hands-on experience with orchestration (like Airflow, Dagster, Databricks Workflows) and distributed processing in a cloud environment
  • Experience with analytical data modeling (star and snowflake schemas), DWH, ETL/ELT patterns, and dimensional concepts
  • Experience building reliable incremental data ingestion pipelines from DBs and APIs.
  • Familiarity with at least one major cloud provider (GCP, AWS, Azure) and deploying data solutions in the cloud
  • Familiarity with CI/CD for data pipelines, IaC (Terraform), and/or DataOps practices
  • Strong troubleshooting mindset: ability to debug issues across data, infra, pipelines, and deployments
  • Collaborative mindset and clear communication across engineering, analytics, and business stakeholders
Job Responsibility
Job Responsibility
  • Build and maintain data pipelines for ingestion, transformation, and export across multiple sources and destinations
  • Develop and evolve scalable data architecture to meet business and performance requirements
  • Partner with analysts and data scientists to deliver curated, analysis-ready datasets and enable self-service analytics
  • Implement best practices for data quality, testing, monitoring, lineage, and reliability
  • Optimize workflows for performance, cost, and scalability (e.g., tuning Spark jobs, query optimization, partitioning strategies)
  • Ensure secure data handling and compliance with relevant data protection standards and internal policies
  • Contribute to documentation, standards, and continuous improvement of the data platform and engineering processes
  • Ensure secure, compliant handling of data and models, including access controls, auditability, and governance practices
  • Build and maintain MLOps automation: CI/CD for ML, environment management, artifact handling, versioning of data/models/code
What we offer
What we offer
  • Vibrant international team operating in hi-tech environment
  • Excellent compensation package
  • myPOS Academy for upskilling and training
  • Unlimited access to courses on LinkedIn Learning
  • Refer a friend bonus as we know that working with friends is fun
  • Teambuilding, social activities and networks on a multi-national level
  • Fulltime
Read More
Arrow Right
New

Steam Sterilization Superintendent - 2nd Shift

In the role of Steam Sterilization Superintendent at Baxter, you will guide our ...
Location
Location
United States , Cleveland
Salary
Salary:
88000.00 - 110000.00 USD / Year
https://www.baxter.com/ Logo
Baxter
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor's degree or equivalent experience required, preferably in a technical field
  • 5+ years of demonstrated ability in manufacturing
  • Experience in Steam Sterilization is a plus
  • Ability to manage department activities through full supervision of cost, methods, and employees
  • Proficient in interpreting and analyzing statistical data, financial reports, and resolving technical difficulties
  • Knowledge of World Class manufacturing methods (QLP, Lean, Six Sigma), GMP, FDA guidelines, and process validation
  • Ability to comprehend and adhere to safety and quality guidelines
  • Basic English written and oral communication skills
  • Flexibility to work any shift, primarily second shift Monday through Friday with occasional weekends
Job Responsibility
Job Responsibility
  • Meet production requirements and deliver quality products on time and within budget
  • Identify, prioritize, and provide resources to meet annual operating plans and budgetary commitments
  • Supervise daily manufacturing operations across one or multiple departments
  • Implement control systems and emphasize training to eliminate product discrepancies
  • Contribute to employee feedback and developmental processes
  • Promote a positive and equitable working environment, emphasizing Baxter's Shared Values: Respect, Responsiveness, and Results
  • Support and prioritize commitments to Safety and Quality
  • Collaborate with managers and customers to ensure quality commitments are met and personnel policies are consistently coordinated
  • Assist in preparing budgets and forecasts for areas of responsibility
  • Make staffing decisions and manage disciplinary issues
What we offer
What we offer
  • Medical and dental coverage starting on day one
  • Basic life, accident, short-term and long-term disability, and business travel accident insurance
  • Employee Stock Purchase Plan (ESPP)
  • 401(k) Retirement Savings Plan (RSP) with company matching
  • Flexible Spending Accounts
  • Educational assistance programs
  • Paid holidays
  • Paid time off ranging from 20 to 35 days based on length of service
  • Family and medical leaves of absence
  • Paid parental leave
  • Fulltime
Read More
Arrow Right
New

Senior Vice President and Chief Nursing Officer

Fresenius Medical Care has exclusively retained Kirby Bates Associates to conduc...
Location
Location
United States , Waltham
Salary
Salary:
Not provided
kirbybates.com Logo
Kirby Bates Associates
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Registered Nurse required
  • Master's degree in Nursing or related field required (doctorate preferred)
  • Senior nurse executive with large-scale, multi-site, national healthcare leadership experience
  • Proven success leading enterprise clinical strategy, quality, regulatory compliance, and transformation
  • Experience operating in complex, highly regulated healthcare environments
  • Demonstrated ability to translate clinical innovation into business value and scalable implementation
  • Comfort operating in a for-profit, publicly traded environment, with strong financial and operational acumen
  • Willingness to travel approximately 30%
  • Central or Eastern U.S. location preferred
Job Responsibility
Job Responsibility
  • Lead the clinical and nursing strategy for the largest dialysis platform in the U.S.
  • Oversee clinical education and workforce development for nursing, patient care technicians, social work, dietetics, and clinical leadership
  • Provide executive leadership for in-center and home dialysis modalities, supporting national expansion of home-based care
  • Drive clinical initiatives and performance improvement, translating evidence-based care into scalable national programs
  • Partner with finance, operations, IT, and analytics to link clinical performance to P&L, growth, and patient outcomes
  • Play a key leadership role in clinical workflow redesign and EHR modernization
  • Fulltime
Read More
Arrow Right
New

Consultant, Claims Processing Oversight

This senior-level consultant will provide hands-on configuration oversight, root...
Location
Location
United States
Salary
Salary:
Not provided
kirbybates.com Logo
Kirby Bates Associates
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 15+ years of payer claims operations leadership
  • Direct experience with major claims platforms — Facets, HealthRules, QNXT, NASCO, or proprietary platforms at production scale
  • Demonstrated RCA capability — has personally led root-cause analysis on claims defects that became regulator-facing issues
  • Track record of configuration root-cause work that has survived external audit
  • Federal program claims operations experience — FEHB, PSHB, Medicare Advantage, Medicaid, or Tricare
  • Must be able to be on site every other week
Job Responsibility
Job Responsibility
  • Provide hands-on configuration oversight
  • Root-cause analysis leadership
  • Provide executive advisory support
  • Ensure accuracy, integrity, and compliance of medical claims processing across FEHB and PSHB lines of business
What we offer
What we offer
  • Housing
  • Transportation
  • Regular travel home
  • Fulltime
Read More
Arrow Right
New

Consultant Reporting and Analytics

Kirby Bates Associates, a premier national healthcare leadership firm, is seekin...
Location
Location
United States , Missouri
Salary
Salary:
Not provided
kirbybates.com Logo
Kirby Bates Associates
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 15+ years healthcare analytics leadership, payer operations focus
  • Power BI mastery — has personally built and maintained production-scale Power BI environments at enterprise scale
  • Data warehouse and ETL design experience at production scale
  • Direct experience producing regulator-facing reporting (OPM, CMS, state DOI)
  • Vendor performance dashboard and SLA reporting design experience
  • Former Director, Analytics or VP, Data & Insights at a payer organization
  • Federal program reporting experience — FEHB, PSHB, Medicare Advantage, Medicaid
  • DAX expertise
  • advanced data modeling and report optimization in Power BI
  • Experience partnering with technology services or IT on data foundation design
Job Responsibility
Job Responsibility
  • Lead the Power BI build-out for Eligibility and Enrollment (E&E) and cost recovery functional areas, currently operating on Excel and SFTP without integrated dashboards
  • Recommend data foundations including warehouse design, ETL pipelines, and data quality monitoring
What we offer
What we offer
  • Housing
  • transportation
  • regular travel home
Read More
Arrow Right
New

Consultant, Dental Claims Configuration and Processing

Location
Location
United States
Salary
Salary:
Not provided
kirbybates.com Logo
Kirby Bates Associates
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 15+ years of dental claims experience, including deep expertise in claims processing and operations
  • 5+ years of leadership experience
  • Proven experience with dental claims configuration and benefit setup, translating benefit design into accurate claims adjudication
  • Experience working in highly regulated environments (e.g., state insurance departments, OPM, CMS, or similar)
  • Demonstrated ability to conduct thorough root-cause analysis and deliver insights that withstand external audit scrutiny.
What we offer
What we offer
  • Housing
  • Transportation
  • Regular travel home
  • Fulltime
Read More
Arrow Right