Senior Data Engineer

Brooksource
Kansas City, United States of America
6 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 125K

Job location

Kansas City, United States of America

Tech stack

API
Artificial Intelligence
Azure
Big Data
Google BigQuery
Cloud Computing
Computer Programming
Continuous Integration
Data Validation
Data Governance
ETL
Data Transformation
Data Warehousing
Web Development
Data Flow Control
Python
PostgreSQL
Machine Learning
Metadata
Meta-Data Management
Node.js
OAuth
Performance Tuning
Openid Connect
Cloudera
SQL Databases
TypeScript
Web Applications
Openapi
Data Processing
Enterprise Software Applications
Data Ingestion
Tailwind
React
Infrastructure as Code (IaC)
Rate Limiting
GIT
WebPack
PySpark
Infrastructure Automation Frameworks
Information Technology
Data Lineage
Deployment Automation
Kafka
Front End Software Development
REST
Pagination
Stream Processing
Webhooks
Software Version Control
Data Pipelines
Confluent
Databricks

Job description

We are looking for a data engineer with 8+ years of experience responsible for designing and building reliable data pipelines and transforming raw data into clean, consumable datasets. The role focuses on developing and maintaining ETL and ELT workflows, data modeling, and ensuring data quality and lineage for downstream users. You will collaborate with product and analytics teams to translate business requirements into scalable data products. This position is hands-on and involves coding, optimizing queries, troubleshooting pipelines, and implementing best practices for data governance and reliability.

Role & Responsibilities:

  • Design, develop, and maintain scalable and reliable data pipelines and platforms to support enterprise analytics and reporting.
  • Collaborate with business and technical teams to understand data requirements and translate them into efficient data engineering solutions.
  • Build data ingestion frameworks using Kafka Confluent and integrate data from multiple cloud and on-premises sources.
  • Implement ELT and ETL pipelines using PySpark, SQL, Dataform, DBT, and Dataproc for efficient data transformation and processing.
  • Design and manage data models, schemas, and data warehousing structures optimized for performance and scalability.
  • Ensure data quality, consistency, and integrity through effective data validation and monitoring mechanisms.
  • Implement data governance practices including data lineage, metadata management, privacy, and compliance.
  • Develop automated monitoring and alerting mechanisms to ensure reliability, availability, and performance of data pipelines.
  • Collaborate with cross-functional teams to enable downstream reporting, analytics, and AI/ML model consumption.
  • Follow best practices for version control, documentation, and CI/CD workflows using Git and infrastructure-as-code tools.
  • Provide operational support for data pipelines and proactively troubleshoot performance issues.
  • Continuously optimize data processing, query execution, and resource utilization in Azure environments.
  • Build and maintain RESTful API integrations to support data ingestion from and synchronization with web applications and enterprise systems.
  • Contribute to lightweight web application development efforts where data pipelines interface directly with front-end or full-stack components.

Requirements

  • Bachelor Degree in Computer Science or related field and 8 years related professional experience Required or Required
  • Associate Degree and 10 years related professional experience Required or Required
  • High School Diploma/GED and 12 years related professional experience Required

Required Skills

  • Strong programming skills in Python and PySpark for large-scale data processing.
  • Proficiency in SQL for data manipulation, analysis, and performance tuning.
  • Experience with Dataform, Dataproc, and BigQuery for data pipeline development and orchestration.
  • Understanding of Data Governance principles and implementation practices.
  • Experience using Git for version control and CI/CD pipelines for automated deployments.
  • Experience building and consuming RESTful APIs, including enterprise integrations (OAuth2, OpenID Connect, webhooks, pagination, rate limiting, retry logic, error handling).
  • Some hands-on web application development experience (full-stack or front-end).Nice to Have :
  • Experience configuring and building pipelines within Databricks
  • Working knowledge of Infrastructure as Code (IaC) for cloud resource management and automation
  • Familiarity with DBT, Machine Learning, and AI concepts is a good advantage
  • Hands-on experience with Kafka and Confluent for real-time data streaming
  • Knowledge of Cloud Scheduler and Dataflow for automation and workflow management
  • Full-stack application development experience using Node.js, TypeScript, React, and Express
  • Experience designing contract-first APIs (OpenAPI, Orval, Zod)
  • Proficiency with React, Vite, Tailwind CSS, shadcn/ui, and TanStack Query
  • Experience with PostgreSQL and ORM frameworks (Drizzle ORM preferred)
  • Experience integrating engineering, construction, ERP, or project management systems
  • Experience working with metadata-driven applications, configurable mappings, and schema transformation frameworks
  • Candidates must be legally authorized to work permanently (i.e., without time limitations, without restrictions or without need for work sponsorship) in the country where this position is located.

Benefits & conditions

Pulled from the full job description Health insurance 401(k) matching Paid time off Vision insurance Health savings account Dental insurance Flexible spending account, * EEO: We are committed to creating an inclusive environment for all employees and applicants. We do not discriminate on the basis of race, color, religion, creed, sex, sexual orientation, gender identity or expression, national origin, ancestry, age, disability, genetic information, marital status, military or veteran status, citizenship, pregnancy (including childbirth, lactation, and related conditions), or any other protected status in accordance with applicable federal, state, and local laws.

  • Benefits & Perks: Brooksource offers competitive medical, dental, vision, Health Savings Account, Dependent Care FSA, and supplemental coverage with plans that can fit each employee's needs. We offer a 401k plan that includes a company match and is fully vested after you become eligible, paid time off, sick time, and paid company holidays. We also offer an Employee Assistance Program (EAP) that provides services like virtual counseling, financial services, legal services, life coaching, etc.
  • Pay Disclaimer: The pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.

Pay: $55.00 - $60.00 per hour

Benefits:

  • Dental insurance
  • Health insurance
  • Vision insurance

About the company

* Disclaimer: Brooksource, Medasource, and Calculated Hire are part of the Eight Eleven Group family of companies and operate under Eight Eleven Group, LLC. All employees receive the same benefits, policies, and terms of employment.

Apply for this position