Data Engineer - AWS/Databricks

Socket.dev; Reston (VA); On-site; USD 90,000 - 130,000; Full time

Job summary

Acuity Inc. is seeking a skilled Data Engineer to design and deliver AWS cloud-scale data platforms for federal clients. The role emphasizes Spark, Delta Lake, and Delta Lake-optimized pipelines in Databricks, with an eye toward enterprise data modernization.

You'll build scalable data pipelines, implement governance, and collaborate with architects to deploy cloud-native solutions on AWS. The position requires 2+ years in data engineering and a BA/BS degree, and offers the opportunity to impact

Qualifications

• 2+ years data engineering and Agile analytics experience.
• 2+ years retrieving, parsing, and processing structured/unstructured data.
• 1–2 years building scalable ETL/ELT workflows for reporting/analytics.
• 1+ years building cloud data solutions with AWS and Databricks.
• Experience with data quality, validation frameworks, and storage optimization.
• BA or BS degree.

Responsibilities

• Build and maintain PySpark-based data pipelines in Databricks for ingestion, transformation, and enrichment of data.
• Design Delta Lake tables optimized for ACID, partition pruning, schema enforcement, and query performance.
• Develop ETL/ELT workflows integrating multiple source systems into a centralized data warehouse.
• Leverage Spark SQL and DataFrame APIs for business rules and warehouse modeling.
• Collaborate with data architects to implement cloud-native data solutions on AWS (S3, Glue, RDS, IAM).
• Optimize pipeline performance with partitioning, caching, and cost-performance tuning.
• Deploy and version data assets using Git-integrated workflows and CI/CD tools (GitLab/Jenkins).
• Monitor pipeline health and cluster utilization via Databricks and AWS CloudWatch.

Skills

Spark

Delta Lake

Databricks

Data Pipelines

AWS

ACID compliance

Git & CI/CD

Data Quality

SQL

Schema enforcement

Education

BA or BS

Tools

Databricks notebooks

Job description

Overview

Acuity Inc. is seeking a highly skilled Data Engineer to join our Engineering Team, helping drive the design and delivery of AWS cloud-scale data platforms for federal clients. This role requires knowledge and/or experience with Spark, Delta Lake, and distributed data pipelines on Databricks. The ideal candidate brings both engineering and strategic insight into enterprise data modernization.

Why Acuity?

Are you ready to use your expertise in the areas of IT Modernization, Data Enablement, and Hyperautomation to make a real difference? Join Acuity, Inc., a technology consulting firm that supports federal agencies. We combine industry partnerships and long-term federal experience with innovative technical leadership to support our customers’ critical missions.

Responsibilities

• Build and maintain scalable PySpark-based data pipelines in Databricks notebooks to support ingestion, transformation, and enrichment of structured and semi-structured data.
• Design and implement Delta Lake tables optimized for ACID compliance, partition pruning, schema enforcement, and query performance across large datasets.
• Develop ETL and ELT workflows that integrate multiple source systems into a centralized, query-optimized data warehouse architecture.
• Leverage Spark SQL and DataFrame APIs to implement business rules, dimensional joins, and aggregation logic aligned to warehouse modeling best practices.
• Collaborate with data architects and engineers to implement cloud-native data solutions on AWS using S3, Glue, RDS, and IAM for secure, scalable storage and access control.
• Optimize pipeline performance through intelligent partitioning, caching, broadcast joins, and adaptive query tuning.
• Deploy and version data engineering assets using Git-integrated development workflows and automate deployment with CI/CD tools such as GitLab or Jenkins.
• Monitor pipeline health, job execution, and cluster utilization using native Databricks tools and AWS CloudWatch, identifying bottlenecks and optimizing cost-performance tradeoffs.
• Conduct technical discovery and mapping of legacy source systems, identifying required transformations and designing end-to-end data flows.
• Implement governance practices including metadata tagging, data quality validation, audit logging, and lineage tracking using platform-native features and custom logic.
• Support ad hoc data access requests, develop reusable data assets, and maintain shared notebooks that meet operational reporting and analytics needs across teams.

Qualifications

• 2+ years of experience in data engineering and Agile analytics
• 2+ years of experience creating software for retrieving, parsing and processing structured and unstructured data
• 1 to 2 years of experience building scalable ETL and ELT workflows for reporting and analytics
• 1 or more years experience building enterprise data engineering solutions in the cloud, with preferred experience with cloud native technologies from AWS and Databricks
• Experience with data quality, validation frameworks, and storage optimization strategies
• BA or BS degree

Clearance Requirement

Must be US Citizen with an ability to obtain and maintain US Suitability

About Acuity

At Acuity, your work matters- and so does your experience. We're a management and technology consulting firm supporting critical federal missions, where you'll have the opportunity to solve meaningful challenges, work alongside high-performing teams, and make a real impact from day one.

Why You'll Love Working Here

• Grow Your Career, Your WayWe invest in you with personalized development plans, mentorship, and up to $3,000 annually for training and certifications and up to $3,000 for degree seeking programs- so you can keep building the career you want.
• Be Part of Something InnovativeYou'll work on cutting-edge solutions that support important government missions, in an environment that encourages new ideas and continuous improvement.
• Thrive in a People-First CultureCollaboration, respect, and support aren't just values-how they're how we operate.
• Feel Valued and RewardedWe offer competitive compensation, comprehensive benefits, and a strong focus on work-life balance so you can perform at your best- at work and at home.
• Join an Award-Winning TeamOur employees consistently rank us among the best- earning honors like Best Places to Work (Washington Business Journal, 9+ years) and Top Workplaces (The Washington Post, 2022-2025).
• Bring Your Whole Self to WorkWe're committed to building a diverse, inclusive environment where everyone feels respected, supported, and empowered to succeed.

Make Your Impact Join Acuity and be part of a team where your ideas are valued, your growth is supported, and your work drives meaningful outcomes.

Learn more: www.myacuity.com

Acuity is an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.

Recruiting Scams and Fraud

Acuity Inc. has been made aware of fraudulent job postings and individuals impersonating company recruiters. These scams may include fake job offers, requests for sensitive personal information, or demands for payment.

Please note: Acuity never asks candidates to pay for job applications, equipment, or training. All official communications will come from an @myacuity.com email address. If you are unsure about a job posting or recruiter, please verify the opportunity on our Careers page. If you believe you have been targeted by a scam or have concerns about the authenticity of a job listing claiming to represent Acuity Inc., please contact us at [e-mail]. Protecting your security and trust is important to us.