Senior Data Engineer

Brooksource is recruiting a Senior Data Engineer for a homebuilding and residential construction client. The role builds and modernizes an enterprise data platform, delivering scalable cloud data solutions and pipelines that support analytics, operational intelligence, and AI-driven decision-making.

Responsibilities

• Design, build, and maintain efficient, scalable data pipelines and ETL/ELT processes for large volumes of structured and unstructured data
• Develop and optimize cloud-based data solutions using AWS and Snowflake
• Architect and implement data ingestion frameworks that support batch, incremental, and near real-time processing
• Optimize data storage and retrieval strategies to improve performance, scalability, and cost efficiency
• Build and maintain data quality frameworks, pipeline observability, monitoring, and alerting systems
• Collaborate with data scientists, analysts, and business stakeholders to understand requirements and translate them into scalable technical solutions
• Develop and manage integrations between enterprise applications, internal systems, APIs, and third-party data providers
• Conduct SQL tuning, performance optimization, and troubleshooting across complex data environments
• Write clean, modular Python code for ingestion, transformation, orchestration, and automation initiatives
• Establish and promote engineering best practices including testing, code review, version control, CI/CD, and deployment standards
• Create and maintain technical documentation for pipelines, data models, architectures, and operational processes
• Mentor junior and mid-level engineers while helping establish development standards across the team

Skills

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field
• 6+ years of experience in Data Engineering, Data Platform Engineering, or a related field with a track record of delivering enterprise-scale data solutions
• Advanced SQL skills including query optimization, performance tuning, and data modeling
• Strong Python development experience for data engineering and automation initiatives
• Experience designing, building, and supporting ETL/ELT pipelines in production environments
• Strong experience with AWS services such as S3, Glue, Lambda, EMR, EKS, EC2, AppFlow, CloudWatch, and related data services
• Experience with Snowflake including data modeling, performance optimization, security, and administration concepts
• Experience with dbt and modern data transformation frameworks
• Knowledge of data governance, security, data quality, and compliance best practices
• Experience working with REST APIs and enterprise system integrations
• Strong understanding of software development lifecycle (SDLC) practices, testing methodologies, code reviews, and version control
• Ability to communicate effectively with both technical and non-technical stakeholders
• Proven ability to mentor peers and contribute technical leadership across engineering initiatives
• Experience with Terraform or Infrastructure-as-Code (IaC) methodologies
• Experience with orchestration tools such as Airflow, Prefect, or similar workflow management platforms
• Experience with Qlik Replicate or similar data replication technologies
• AWS Certification
• Experience supporting enterprise analytics, reporting, and AI/ML initiatives

Benefits

• Hybrid (3 days onsite)
• Competitive medical, dental, vision, Health Savings Account, Dependent Care FSA, and supplemental coverage with plans that can fit each employee's needs.
• A 401(k) plan that includes a company match and is fully vested after you become eligible.
• Paid time off, sick time, and paid company holidays.
• An Employee Assistance Program (EAP) that provides services like virtual counseling, financial services, legal services, life coaching, and more.

Company Overview

Company H1B Sponsorship