Dbt

Dbt Engineer Jobs

12 jobs found

2d ago

Lead Data Engineer

Daley and Associates Boston, MA

Boston, MA

2d ago

Full time Cloud Cloud Platform Data

Apply Now

Job Description

Daley and Associates seeks a Lead Data Engineer to specialize in data integration, dbt driven data modeling in Snowflake, and end to end data pipelines for investment data. This on site role in Boston, MA requires three days per week on site, supporting the Investment Data Management Office.

Responsibilities

Design, develop, and maintain dbt data models in Snowflake, implementing business logic and ensuring alignment with the established data architecture and standards.
Lead and contribute to dbt projects, ensuring high quality code, thorough documentation, and adherence to modular, scalable design patterns.
Architect, construct, and manage scalable data pipelines and a robust data warehouse to support reporting, analytics, and operational use cases.
Lead and participate in development activities; design and implement solutions that address business requirements aligned with program objectives.
Pursue ongoing enhancements of data quality, resilience, governance, efficiency, and monitoring capabilities.
Diagnose and resolve complex system interactions to identify root causes of issues.
Collaborate with the platform lead to design, develop, implement, and deploy new software components for the investment data platform.
Work with the data architect to evaluate and finalize the unified data model.
Coordinate with the integration architect to upgrade and integrate ingestion and delivery tools with the unified data platform.
Upgrade and integrate transformation, data validation, and orchestration tools with the unified data platform to enable data engineering, analytics engineering, and ongoing data maintenance capabilities.
Provide on call support during unexpected outages.

Requirements

Bachelor’s degree in Computer Science or a related discipline.
5 to 6 plus years of experience designing, developing, and delivering data oriented complex applications.
Minimum of 2 to 4 years of hands on experience progressing from SQL to Advanced SQL.
Experience developing and maintaining data models in dbt (Data Build Tool).
Experience in data integration (ETL/ELT), data warehouse, data analytics architecture, and a solid understanding of design principles; familiarity with Snowflake and other cloud native databases is highly preferred.
Development experience on cloud based PAAS platforms such as Microsoft Azure, Google GCP or Amazon AWS.
Strong understanding of Agile SDLC, DevOps, and Cloud technologies, with exposure to multiple technologies, platforms, and processing environments.
Knowledge of architectures and patterns such as unified data management (UDM), data mesh, event driven architecture, real time data flows, non relational repositories, and data virtualization.
Experience building solutions in the financial services domain with an understanding of financial instruments, transactions, and positions is desired.
Strong interpersonal and communication skills with the ability to lead cross team collaboration and partnerships across a variety of internal and external constituencies.

Technologies

dbt (Data Build Tool)
Snowflake
Microsoft Azure
Google Cloud Platform
Amazon Web Services

What We Are Looking For

Bachelor’s degree in Computer Science or related disciplines.
About five to six years of experience designing, developing, and delivering data oriented complex applications.
At least two to four years of hands on SQL experience, including advanced SQL techniques.
Experience in developing and maintaining dbt data models.
Background in ETL/ELT data integration, data warehousing, and analytics architecture; familiarity with Snowflake and other cloud native databases is highly preferred.
Development experience on cloud PAAS platforms such as Azure, AWS, or Google Cloud.
Strong grasp of Agile SDLC, DevOps, and cloud technologies, with exposure to diverse tech stacks and environments.
Knowledge of architectures like UDM, data mesh, event-driven patterns, real-time data flows, NoSQL stores, and data virtualization.
Experience delivering solutions in the financial services domain with an understanding of instruments, transactions, and positions is a plus.
Excellent collaboration and communication skills to coordinate with multiple internal and external stakeholders.

Preferred Qualifications

Experience within the asset management industry and investment data domain, with exposure to multi asset investment platforms and related data ecosystems.
Understanding of asset management concepts and knowledge of various financial instruments and products, including traditional and alternative asset classes.
Industry certifications in Snowflake, dbt, cloud data engineering platforms, data warehousing technologies, or financial markets and operations are highly valued.
Demonstrated interest in emerging AI technologies and an understanding of how AI driven tools can improve engineering processes, data quality, operational efficiency, and analytics workflows.
Familiarity with leveraging AI assisted development, automation, or data engineering best practices to enhance productivity and continuous improvement initiatives is a plus.

View full job page →

2d ago

Data Architect / Principal Data Engineer III

Hudson Manpower Cincinnati, OH

Cincinnati, OH

2d ago

$55 - $60/hr Full time Senior Cloud Cloud Platform

Apply Now

Job Description

Onsite in Cincinnati, OH, this Data Architect / Principal Data Engineer III role focuses on designing scalable data solutions for a banking environment, leveraging DBT, Snowflake, and SQL. Compensation is USD 55 - 60 per hour.

Responsibilities

Design, develop, and support data solutions, APIs, tools, and processes to enable rapid delivery of business capabilities.
Collaborate with IT application teams, Enterprise Architecture, infrastructure, information security, and lines of business to translate strategies into data driven solutions for the bank.
Serve as a technical expert addressing challenges in system and application design, performance, integration, and security.
Research and develop using current trends in banking, data engineering and architecture, and data security.
Partner with developers to build CI/CD pipelines, self service build tools, and automated deployment processes.
Evaluate software products and provide documented recommendations as needed.
Provide support and troubleshooting for data platforms, including escalated on call assistance for complex incidents.
Participate in hardware and software planning processes.
Lead internal projects as needed, such as legacy system replacement, monitoring and analytics improvements, tool development, and technical documentation.
Provide technical guidance and mentoring for team members.
Manage and prioritize multiple assignments.

Requirements

Bachelor's degree in Computer Science, Information Systems, or an equivalent combination of education and experience.
Strong verbal and written communication skills to engage management, sponsors, business and IT teams, and technical resources.
Seven or more years of IT experience relevant to the position.
Working knowledge of application and data security concepts, best practices, and common vulnerabilities.
Experience in one or more of the following areas preferred: big data technologies, metadata management, commercial ETL tools, BI and reporting tools, messaging systems, data warehousing, Java, major version control systems, CI/CD tools, infrastructure automation/virtualization, major cloud platforms, or REST API design and development.
Experience collaborating with offshore teams is desirable.
Financial industry experience is a plus.

Technologies

DBT
Snowflake
SQL
Java

Benefits

Competitive base salary
Medical, dental, and vision insurance coverage
Optional life and disability insurance
401(k) with company match and optional profit sharing
Paid vacation time
Paid bench time
Training allowance
Referral bonuses

View full job page →

6d ago

Data Engineer

Centro, Inc North Liberty, IA

North Liberty, IA

6d ago

Full time Apache Airflow Data Analysis Data Analytics

Apply Now

Job Description

Centro, Inc is seeking a Data Engineer to design, build, and maintain the organization’s data infrastructure and pipelines that support reporting, analytics, and decision making. This role operates within Centro’s Harbor data platform to convert data into actionable information that informs business decisions. The position is based on site in North Liberty, Iowa.

Location

North Liberty, IA (onsite)

Responsibilities

Design, build, and sustain ETL pipelines to support enterprise reporting and analytics.
Create and manage data workflows across extraction, change data capture, transformation, and loading stages.
Schedule and trigger workflows for both routine and on-demand runs using Prefect.
Consolidate data from ERP, manufacturing, and business systems into centralized data platforms.
Stage and transform source data in MongoDB environments and load curated datasets into Microsoft SQL Server.
Apply incremental processing strategies using Redis-based CDC methodologies.
Transform complex, nested, and multi-value data into relational models optimized for reporting and analytics.
Develop and maintain dbt models, data tests, and related documentation.
Monitor pipeline performance and troubleshoot data quality issues, schema changes, and workflow failures.
Collaborate with business stakeholders to capture data requirements and design scalable solutions.
Produce and maintain technical documentation, operational procedures, and support resources.
Identify opportunities to automate manual processes and enhance data delivery efficiency.
Ensure data accuracy, consistency, security, and reliability across systems.
Keep current with emerging data engineering technologies, tools, and best practices.

Requirements

Bachelor’s degree in Computer Science, Information Systems, Data Engineering, Software Engineering, or a related field, or an equivalent combination of education and experience.
Proven experience designing, building, and supporting production data pipelines.
Proficiency in SQL and Python for enterprise data processing and integration tasks.
Experience working with structured, semi-structured, and unstructured data.
Demonstrated ability to troubleshoot and optimize data workflows and performance.
Strong analytical, organizational, and problem-solving abilities.
Effective written and verbal communication skills.
Ability to manage multiple priorities and adapt to evolving business needs.

Technologies

SQL
Python
Prefect
MongoDB
Microsoft SQL Server
Redis
dbt
Docker
Apache Airflow

Physical Requirements & Work Environment

Primarily office-based work performed in a professional business environment.
Occasional exposure to manufacturing environments, including production floor areas.
Ability to sit, stand, walk, and use computer equipment for extended periods.
Occasional travel may be required.
Typical schedule is Monday through Friday, 8:00 a.m. to 5:00 p.m., with flexibility as business needs require.

Why Join Centro?

Centro is a leader in rotational molding with a longstanding emphasis on innovation, quality, and employee development. The company fosters a collaborative environment where team members influence business processes and support strategic growth through technology and data‑driven decision making.

Equal Opportunity Employer

Centro is an Equal Opportunity Employer.

View full job page →

8d ago

Data Engineer

Booz Allen Hamilton Fayetteville, NC

Fayetteville, NC

8d ago

$78k - $176k/yr Full time Apache Airflow Automation AWS

Apply Now

Job Description

Booz Allen Hamilton is seeking a Senior Data Engineer to help design and build scalable data platforms and pipelines, migrate data to cloud environments, and implement CI/CD within a complex enterprise setting. This onsite role in Fayetteville, NC offers a salary range of USD 77,500 to 176,000 per year and requires a minimum of two years of experience along with a high school diploma or GED.

Responsibilities

Design, build, and maintain scalable data pipelines and platforms.
Develop secure, efficient Python for data processing, automation, and warehousing.
Migrate and integrate data from on-premises systems to cloud environments.
Implement CI / CD pipelines to automate build, test, and deployment workflows.
Develop SQL scripts and stored procedures for data processing and transformation.
Apply data modeling best practices.
Support data governance, metadata tagging, and access controls.
Partner with cross-functional teams to deliver end-to-end data solutions.
Provide technical guidance in a complex enterprise environment.

Requirements

2+ years of experience as a data engineer supporting large-scale enterprise systems.
Experience writing clean, secure, and efficient Python for data engineering use cases.
Experience moving data from on-prem environments to the cloud and automating development workflows, including building, deploying, or managing applications.
Experience with CI / CD practices.
Experience with SQL, including stored procedures and data modeling.
Experience with data governance and data tagging.
Knowledge of AWS services, such as S3, IAM, EventBridge, Step Functions, or Lambda.
Ability to work independently and manage tasks with minimal supervision.
TS/SCI clearance.
HS diploma or GED.

Technologies

Python
SQL
AWS (S3, IAM, EventBridge, Step Functions, Lambda)
dbt
Airflow
Pipeline Builder
AIP
Foundry
Apache Iceberg
Terraform
CloudFormation
NoSQL databases
Graph databases

Benefits

Health benefits
Life insurance
Disability benefits
Financial benefits
Retirement benefits
Paid leave
Professional development
Tuition assistance
Work-life programs
Dependent care
Recognition awards program

Work Model

Onsite: Work will primarily be performed at a Booz Allen office or customer facility, where collaboration with colleagues and clients occurs as required by the role.

Identity Statement

As part of the hiring process, you will complete an identity verification process that leverages advanced biometrics and artificial intelligence to ensure authenticity and protect against identity fraud. Interviews and assessments require you to be on camera, and Booz Allen may take your picture to verify identity and prevent fraud.

Candidate AI Usage Policy

AI is part of Booz Allen's daily work, and the company supports responsible and ethical use of AI tools. The candidate process should rely on your own skills and knowledge; using AI or other tools to assist with interview responses is prohibited unless explicit permission is provided.

View full job page →

9d ago

BI Developer/Analytics Engineer

Speed Express Montebello, CA

Montebello, CA

9d ago

$95k+/yr Full time Analytics Business Analytics Business Intelligence

Apply Now

Job Description

Speed Express is seeking a BI Developer / Analytics Engineer to design, develop, and maintain enterprise reporting and analytics solutions in Montebello, California. The role centers on transforming raw data into actionable business insights through close collaboration with analysts and data engineering teams to build dashboards, semantic models, data marts, and self-service reporting.

Responsibilities

Improve dashboard performance, data refresh efficiency, and query execution times
Troubleshoot reporting and data performance issues
Ensure scalability and maintainability of BI solutions

Requirements

Bachelor’s or Master’s degree in Computer Science, Information Systems, Data Analytics, Business Analytics, or related field
3+ years of experience in BI development, analytics engineering, or business intelligence solutions
Proven ability to develop dashboards and enterprise reporting solutions
Advanced SQL skills with experience optimizing analytical queries
Experience with dimensional modeling and data warehousing concepts
Strong analytical, problem-solving, and communication skills
Experience with Power BI and/or Tableau
Web-based dashboard development and self-service reporting platforms
Experience with SQL, dimensional modeling, data marts, semantic/business modeling, and KPI/metrics design

Technologies

Power BI
Tableau
SQL
dbt

Benefits

401(k)
Dental insurance
Health insurance
Life insurance
Paid time off
Parental leave
Vision insurance

Governance and Standards

Standardize metrics and reporting definitions across departments
Maintain data accuracy, consistency, and reporting quality standards
Implement BI development best practices and documentation standards
Support user acceptance testing (UAT) and dashboard validation activities

Collaboration and Support

Work closely with Business Analysts and stakeholders to understand reporting requirements and business processes
Partner with data engineers to ensure reliable and high-quality data pipelines
Provide support and enhancements for existing dashboards and reporting solutions
Train and support business users on self-service reporting capabilities

Preferred Additional Skills

Experience with data warehouse or lakehouse environments
Familiarity with dbt or analytics engineering workflows
Knowledge of ETL/ELT processes
Experience with DAX, Tableau calculations, or similar analytical languages
Understanding of data governance and reporting standards

Preferred Qualifications

Experience supporting enterprise BI environments
Experience working with cross-functional business teams
Familiarity with cloud-based analytics platforms
Experience with performance tuning for large-scale reporting environments
Understanding of financial, operational, or executive reporting

Key Competencies

Business intelligence development
Data visualization and storytelling
Analytical thinking
Data modeling and KPI design
Attention to detail and data accuracy
Cross-functional collaboration
Problem-solving and performance optimization

Equal Employment Opportunity

Pay: From $95,000 per year

Application Question

Will you require sponsorship from the company?

Language

Mandarin is required

Work Location

Onsite in Montebello, CA

View full job page →

17d ago

Data Engineer

Major League Baseball (MLB) New York, NY

New York, NY

17d ago

$115k - $140k/yr Full time Python Analytics Apache Airflow

Apply Now

Job Description

Join MLB's LAI team in New York on site to build production data pipelines using Airflow and dbt on Google Cloud Platform. You will design pipelines, data models, and infrastructure that power analytics across clubs and the Commissioner's Office. This role offers a collaborative culture, emphasis on data quality and governance, and the opportunity to influence league analytics with hands-on engineering work.

Responsibilities

Develop production-grade pipelines with Airflow and dbt to orchestrate batch and streaming transformations on GCP, delivering trusted data for downstream analysts and engineers.
Design clean, layered data models (staging, intermediate, mart) that serve as the league's single source of truth, applying dbt best practices for materialization, testing, and documentation.
Operate the ingestion layer with Pub/Sub, GCS, Dataflow, and Knowledge Catalog DataPlex to land both batch and streaming sources into the lakehouse.
Establish observability and monitoring standards to surface data quality issues proactively before stakeholders notice them.
Manage code through GitHub-based CI/CD, contributing to deployment workflows that keep the platform reliable and changes safe.
Adhere to data governance practices to keep proprietary baseball data secure and compliant.

Requirements

2 to 4 years of production data engineering experience.
Expert-level SQL, capable of writing complex freehand queries and reviewing others' queries to spot issues.
Strong Python skills for data processing, scripting, and automation.
Hands-on dbt experience building models across staging, intermediate, and mart layers, with tests and production deployments.
Production Airflow experience, including DAG authoring, dependency management, and debugging failed runs.
Deep familiarity with Google Cloud Platform (BigQuery, GCS, Pub/Sub) or equivalent depth in AWS/Azure with willingness to convert.
Git-based development workflows, including branches, PRs, and code reviews.
Clear communication with engineers and non-engineers, receptive to feedback and collaborative in approach.
Execution mindset with the ability to own a project from requirements to deployment with minimal oversight.

Technologies

Airflow
dbt
Python
SQL
GitHub
BigQuery
GCS
Pub/Sub
Dataflow
Knowledge Catalog DataPlex
Terraform

Benefits

Competitive Benefits Package
Company Contributed 401K Plan
Paid Time Off and Holidays
Paid Parental Leave
Access to Free Tickets to Baseball Games and MLB.TV
Discounts at MLB Store
Employee Assistance Programs (EAP)
Onsite and Online Training and Development Programs
Tuition Reimbursement
Disability Benefits (short term and long term)
Life and Accidental Death Insurance
Pet Insurance

Salary

Base salary: $115,000 – $140,000 per year, plus bonus.

NICE-TO-HAVE

A degree in Computer Science, Engineering, or a related field, or equivalent practical experience
Experience with Terraform or other Infrastructure-as-Code tools
Experience with AI-assisted development or enterprise AI tooling (Gemini Enterprise, Vertex AI)
A passion for baseball or prior experience in sports, media, or entertainment
Ability to build creative solutions for unusual problems

View full job page →

21d ago

Data Engineer

Crumbl Provo, UT

Provo, UT

21d ago

Full time Cloud Cloud Platform Data Architecture

Apply Now

Job Description

Based at Crumbl HQ in Provo, Utah, this Data Engineer role focuses on designing, building, and maintaining scalable data pipelines with dbt and Prefect to support data-driven decision making across the organization.

Responsibilities

Design, implement, and maintain scalable data pipelines using ELT/ETL extraction methods to ensure reliability.
Collaborate with data scientists, analysts, and other stakeholders to capture data requirements and uphold data quality.
Create and maintain documentation such as data dictionaries, workflow diagrams, and data flow diagrams.
Safeguard data integrity and security through appropriate controls and ongoing monitoring.
Optimize pipelines for efficient processing and improved query performance.
Implement and enforce data security policies, including access controls, encryption, and data masking.
Design and implement data processing workflows with dbt and Prefect to support data science and machine learning initiatives.
Develop and maintain data ingestion pipelines to bring external data into the organization’s data environment.
Identify performance bottlenecks in pipelines and collaborate with infrastructure and operations teams to optimize performance.
Test and validate data pipelines to verify correct operation and alignment with business requirements.
Participate in code reviews and help establish engineering best practices.
Stay informed about emerging data engineering and data science technologies and identify opportunities to adopt them internally.

Requirements

Bachelor’s or Master’s degree in Data Science, Information Systems, or a related field
3+ years building and maintaining production data pipelines (degree in a related field or equivalent experience)
Advanced SQL including window functions, CTEs, and performance tuning on large datasets
Strong Python for data engineering with modular, testable pipeline code
Hands-on dbt experience: models, tests, macros, and incremental materializations
Production Snowflake experience: schema design, performance tuning, and warehouse/cost optimization
AWS data services such as S3, Glue, and Lambda
Data quality and observability with dbt plus Elementary
Infrastructure as code with Terraform and version control with Git
Dimensional data modeling (star/snowflake schemas, SCDs) and lakehouse concepts
Strong problem-solving skills and clear communication with analysts, scientists, and stakeholders