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

Job Type Icon

Contract Type:
Not provided

Salary Icon

Salary:

Not provided

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
Job Link Share:

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

Business Development Representative

Location
Location
United States , Philadelphia
Salary
Salary:
Not provided
Hybrid News Limited
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Self-motivated mentality with a relentless desire to win
  • 1 Years Sales experience preferred
  • Persuasive communicator, able to build rapport with senior stakeholders and understand business needs
  • Driven, energetic, tenacious, confident, and determined to succeed in their career
  • Open to coaching and learning new sales methodology, whilst also able to put your own stamp on your outreach
Job Responsibility
Job Responsibility
  • 360 New Business sales role from prospecting new opportunities to closing the business (and everything in between)
  • Employ modern approaches to sales including balanced prospecting, and discovery-led pitching putting prospects first to maintain high conversions
  • Utilise data-driven market knowledge to identify relevant clients in Higher Education
  • Build interest from Higher Education Senior Leadership through impactful pitching and clear articulation of our digital media products and services
What we offer
What we offer
  • Work for a global market leader with new offices in the heart of Philadelphia
  • Huge potential for progression in line with our ambitious growth plans
  • Monthly contribution to your physical health or wellbeing costs (e.g. gym membership, art classes) and Headspace subscription
  • Paid training for career accreditations
  • Internal mobility options and established career paths
  • Incentive schemes, financial advice and company pension contributions
  • Generous PTO entitlement
  • Comprehensive Health, Vision, Dental insurance
  • 401k
  • Charity fundraising challenges and volunteering days
  • Fulltime
Read More
Arrow Right
New

Staff Research Engineer, MetaAI Assistant Measurement

Meta Superintelligence Labs is seeking a Staff Research Engineer to provide tech...
Location
Location
United States , Bellevue
Salary
Salary:
257000.00 USD / Year
meta.com Logo
Meta
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor's degree in Computer Science, Computer Engineering, relevant technical field, or equivalent practical experience
  • Track record of driving technical strategy and landing large-scale research or product impacts in a time-sensitive environment
  • Proven technical vision regarding the future trajectory of Generative AI, specifically in how model performance translates to user utility
  • Expertise in designing and implementing online and offline measurement systems, benchmark building, and data synthesis techniques
  • Experience leading complex, cross-functional technical initiatives, driving consensus across engineering, research, and product boundaries
  • Proficiency in Python and deep learning frameworks (e.g., PyTorch), with the ability to prototype and implement complex methodologies
Job Responsibility
Job Responsibility
  • Architect Scientific Strategy: Define and lead the execution of the scientific roadmap for AI Assistant measurement, ensuring methodologies are rigorous, scalable, and aligned with product goals
  • Innovate & Build: Spearhead the research and development of novel offline and online evaluation metrics, automated benchmarks, and synthetic data generation pipelines to close the loop between model training and deployment
  • Cross-Functional Technical Leadership: Serve as the primary scientific liaison to pre-training, post-training, and product teams, ensuring that measurement insights directly influence model architecture and training recipes (the "evaluation flywheel")
  • Mentorship & Influence: Provide technical mentorship and guidance to senior research engineers and applied scientists, fostering a culture of scientific rigor and code without direct management responsibilities
  • Hands-on Contribution: Remain hands-on in code and research, building prototypes for new evaluation frameworks and validating novel measurement theories
What we offer
What we offer
  • bonus
  • equity
  • benefits
Read More
Arrow Right
New

Account executive

Location
Location
United States , Philadelphia
Salary
Salary:
Not provided
Hybrid News Limited
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Self-motivated mentality with a relentless desire to win
  • 3 Years Sales experience preferred
  • Persuasive communicator, able to build rapport with senior stakeholders and understand business needs
  • Driven, energetic, tenacious, confident, and determined to succeed in their career
  • Open to coaching and learning new sales methodology, whilst also able to put your own stamp on your outreach
Job Responsibility
Job Responsibility
  • 360 New Business sales role from prospecting new opportunities to closing the business (and everything in between)
  • Employ modern approaches to sales including balanced prospecting, and discovery-led pitching putting prospects first to maintain high conversions
  • Utilise data-driven market knowledge to identify relevant clients in Higher Education
  • Build interest from Higher Education Senior Leadership through impactful pitching and clear articulation of our digital media products and services
What we offer
What we offer
  • Work for a global market leader with new offices in the heart of Philadelphia
  • Huge potential for progression in line with our ambitious growth plans
  • Monthly contribution to your physical health or wellbeing costs (e.g. gym membership, art classes) and Headspace subscription
  • Paid training for career accreditations
  • Internal mobility options and established career paths
  • Incentive schemes, financial advice and company pension contributions
  • Generous PTO entitlement
  • Comprehensive Health, Vision, Dental insurance
  • 401k
  • Charity fundraising challenges and volunteering days
  • Fulltime
Read More
Arrow Right
New

Software Engineer, Systems

Meta Platforms, Inc. (Meta), formerly known as Facebook Inc., builds technologie...
Location
Location
United States , Menlo Park
Salary
Salary:
188000.00 - 200200.00 USD / Year
meta.com Logo
Meta
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor’s degree (or foreign degree equivalent) in Computer Science, Computer Software, Computer Engineering, Human-Computer Interaction, Applied Sciences, Mathematics, Physics or related field and 3 years of experience in the job offered or in a computer-related occupation
  • 3 years of experience in the following: Coding in an industry-standard language (e.g. Java, Python, C++, or JavaScript)
  • C, C++, C#, or Java
  • Python, PHP, or Haskell
  • Relational databases and SQL Software development tools: Code editors (VIM or Emacs), and revision control systems (Subversion, GIT, or Perforce)
  • Linux, UNIX, or other *nix-like OS including file manipulation and simple commands
  • Core web technologies: HTML, CSS, or JavaScript
  • Building highly-scalable performant solutions
  • Distributed systems including sharding, consistency, and availability
  • Algorithms
Job Responsibility
Job Responsibility
  • Research, design, develop, build and test operating systems-level software, compilers, and network distribution software for large distributed components that run Facebook
  • Build new features and improve existing products
  • Work on problems of moderate scope, push code, drive the development of the systems behind Facebook's products create web applications that reach billions of people, build high volume servers, and be a part of a team to connect people around the globe
  • Develop a strong understanding of relevant product area, codebase, and/or systems
  • Demonstrate proficiency in data analysis, programming and software engineering
  • Produce high quality code with good test coverage, using modern abstractions and frameworks
  • Receive general instructions on routine work and detailed instructions on new projects or assignments, work independently, use available resources to get unblocked, and complete tasks on-schedule by exercising strong judgement and problem-solving skills
  • Master Facebook’s development standards from developing to releasing code in order to take on tasks and projects with increasing levels of complexity
  • Actively seek and give feedback in alignment with Facebook’s Performance Philosophy
What we offer
What we offer
  • bonus
  • equity
  • benefits
Read More
Arrow Right
New

Paid Media Executive

We are looking for an experienced Paid Media Executive to create and develop Sea...
Location
Location
Malaysia , Kuala Lumpur
Salary
Salary:
Not provided
Hybrid News Limited
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Minimum of 3 years of experience in planning, managing, and optimising paid advertisements/PPC campaigns
  • Experience in setting up and troubleshooting conversion tracking in GA4, Tag Manager, and other paid online advertising platforms
  • Experience working with large client accounts to research, plan, optimise, and complete paid media campaigns
  • Must be able to take a strategic approach with the ability to add market knowledge, insight, and intelligence
  • Prior experience working across multiple platforms in an agency environment is also desirable
Job Responsibility
Job Responsibility
  • Develop plans and manage the buying of paid advertising campaigns across Google Ads and ideally have experience working with Meta, TikTok, Twitter and other leading social advertising platforms
  • Handle the day-to-day management and optimisation of Search, Programmatic, Display, etc. campaigns for our clients
  • Give recommendations and build campaigns - executing paid media campaigns to an industry-standard best practice
  • Use analytics to report to produce reports to analyse the performance of paid campaigns and promotions
  • Monitor KPIs for campaigns and develop recommendations to improve them
  • Be capable of analysing data to draw conclusions on campaign performance and recommend improvements that will help achieve commercial goals, i.e. incremental sales growth, new customer acquisition etc
  • Be confident in delivering paid media insights to clients when required
  • Take campaign learnings to inform media planning decisions and feed into the overarching media strategy
  • Support the business in keeping constantly informed of the latest developments in the Paid Media analytics, bringing those to the wider team
What we offer
What we offer
  • ‘Your Career at Hybrid’ Programme which include clear career pathways, ongoing training, and professional growth
  • Be part of a creative powerhouse committed to delivering exceptional work
  • Innovate with a fast-growing company
  • Regular team events, exciting incentives, and social activities
  • Incentive schemes, financial advice and company pension contributions
  • Collaborate with talented professionals from around the world
Read More
Arrow Right
New

Sales Development Representative

We are looking to onboard several exceptional Sales Development Representatives ...
Location
Location
United Kingdom , Bristol
Salary
Salary:
Not provided
Hybrid News Limited
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Self-motivated mentality with a relentless desire to win
  • 1 year of sales experience preferred
  • Persuasive communicator, able to build rapport with senior stakeholders and understand business needs
  • Driven, energetic, tenacious, confident, and determined to succeed in their career
  • Open to coaching and learning new sales methodology, whilst also able to put your own stamp on your outreach
Job Responsibility
Job Responsibility
  • New Business sales role from prospecting new opportunities, conducting cold outreach, and setting appointments for a sales manager to close the deal
  • Employ modern approaches to sales, including balanced prospecting and discovery-led pitching, putting prospects first to maintain high conversions
  • Utilise data-driven market knowledge to identify relevant clients in Higher Education
  • Build interest from Higher Education Senior Leadership through impactful pitching and clear articulation of our digital media products and services
What we offer
What we offer
  • Competitive base salary + market-leading commission scheme with a realistic and uncapped OTE of £50k - £70k first year
  • Highly refined onboarding & sales training program (across sales and digital solutions) with our experienced and talented sales leaders to get you up to speed at pace
  • Unrivalled career progression opportunities in line with our ambitious growth plans
  • Monthly contribution to your physical health costs (e.g. gym membership)
  • Online training, tools, and resources, including 1:1 coaching sessions to help manage your wellbeing
  • Paid training for career accreditations
  • Internal mobility options and established career paths
  • A fun and lively work culture with regular team events, incentives, social activities, charity fundraising challenges and volunteering days
  • Fulltime
Read More
Arrow Right
New

Embedded Software Engineer

At Meta, we're building innovative products that make it easier for people to co...
Location
Location
United States , Sunnyvale, CA +5 locations
Salary
Salary:
122000.00 - 181000.00 USD / Year
meta.com Logo
Meta
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 2+ years of software development experience in industry settings, or PhD degree +9 months of experience
  • Experience in large-scale C/C++ code base
  • Embedded software engineering experience
  • Currently has, or is in the process of obtaining a Bachelor's degree in Computer Science, Computer Engineering, relevant technical field, or equivalent practical experience. Degree must be completed prior to joining Meta
Job Responsibility
Job Responsibility
  • Design and implement software components at all layers of the system, including kernel, synchronization primitives, resource allocators, memory management, security, I/O systems, persistence, etc
  • Develop drivers and services that operate efficiently in constrained environments and deliver large volumes of data with low-latency and high-bandwidth
  • Lead hardware bring-up, peripheral drivers and communication, silicon integration, and power and performance management and optimization efforts
  • Debug complex, system-level, multi-component issues that span multiple layers from kernel to application
  • Profile performance problems and drive optimizations across the entire software stack
  • Analyze, design, develop, and debug firmware for a wide variety of devices, including novel sensing and imaging systems, haptic devices, and audio prototypes
  • Collaborate closely with cross-functional teams, including silicon architects, hardware designers, OS team, and algorithm and model development teams
  • Understand and implement power-management, boot loaders, scheduling, inter-processor communication, computer vision, and firmware/system interfaces on RTOS and/or bare-metal environments
  • Design, develop, and architect models and infrastructure building blocks of Virtual Platforms, integrating internal models and vendor IP models
What we offer
What we offer
  • bonus
  • equity
  • benefits
Read More
Arrow Right
New

Production Systems Engineer

Meta is seeking a Production Systems Engineer to join our Hardware Design and Re...
Location
Location
Ireland , Dublin
Salary
Salary:
Not provided
meta.com Logo
Meta
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • An engineering degree is typical, or related technical discipline, or equivalent work experience
  • 4+ years experience coding in a higher-level language (Python, PHP, Java, Go, Rust, C++)
  • Experience building, maintaining and debugging production services or platforms - usually (but not necessarily) in a linux/unix environment
  • Knowledge of server architecture and components across Compute/Storage/AI Systems/Networking
Job Responsibility
Job Responsibility
  • Build and develop tooling solutions to automate business critical processes in service of managing the health of the Meta production hardware fleet
  • Troubleshoot, diagnose and root cause system failures, working with key partners to identify and deliver solutions
  • Proactively identify opportunities to fix or enhance tooling, hardware and processes
  • Build subject matter expertise in one or more of the specialist areas covered by the RTP (Release To Production) team in Dublin
  • Scientific approach to troubleshooting, root-cause analysis and investigation
Read More
Arrow Right