Data Engineer

Embedded Shishya; Deutschland; Vor Ort; EUR 105.087 - 157.631; Vollzeit

Benefits dieser Stelle

Health insurance

Paid time off

Career training

Performance bonuses

401K with company match

Federal holidays

Zusammenfassung

CTEC in the United States is hiring a senior data engineer to design, build, and operate scalable ETL pipelines on Azure Databricks and lakehouse architectures. You will ingest, transform, and govern data for federal projects, collaborating with data architects, BI analysts, and security teams.

The role requires 7+ years in data engineering, strong SQL/Python skills, and experience with CI/CD for data workflows.

Qualifikationen

• 7+ years in data engineering or large-scale data integration.
• Strong SQL and Python with PySpark experience.
• Experience with Azure cloud data platforms and lakehouse architectures.
• Knowledge of data governance, metadata management, and security.
• Experience with CI/CD for data workflows.

Aufgaben

• Design, develop, and maintain scalable ETL pipelines in Azure Databricks.
• Build and maintain Databricks data platforms and lakehouse layers.
• Support data migration and data mapping from legacy systems.
• Ensure data quality, governance, and security across domains.
• Collaborate with architects, analysts, and reporting teams; mentor juniors.

Kenntnisse

ETL pipelines

Azure Databricks

SQL

Python

Spark

CI/CD

Data modeling

Agile

Ausbildung

Bachelor's degree in Computer Science or related field

Tools

Azure Data Factory

Power BI

Git

Jobbeschreibung

CTEC is a leading technology firm that provides modernization, digital transformation, and application development services to the U.S. Federal Government. Headquartered in McLean, VA, CTEC has over 300 team members working on mission‑critical systems and projects for agencies such as the Department of Homeland Security, Internal Revenue Service, and the Office of Personnel Management. The work we do effects millions of U.S. citizens daily as they interact with the systems we build. Our best‑in‑class commercial solutions, modified for our customers’ bespoke mission requirements, are enabling this future every day.

The Company has experienced rapid growth over the past 3 years and recently received a strategic investment from Main Street Capital Corporation (NYSE: MAIN). In addition to our recent growth in Federal Civilian agencies, we are seeking to expand our capabilities in cloud development and footprint in national‑security focused agencies within the Department of Defense and U.S. Intelligence Community.

Client

CTEC develops and delivers innovative customer‑centric technologies and solutions that support the Office of Personnel Management’s (OPM) Health and Insurance business unit and Office of the Chief Information Officer (OCIO).

Duties and Responsibilities

• Data Pipeline & ETL Development: Design, develop, and maintain scalable ETL pipelines and data workflows to ingest, transform, and integrate data from legacy systems and external sources into modern cloud‑based data platforms.
• Cloud Data Platform & Databricks Implementation: Build, optimize, and maintain data processing solutions using Azure Databricks and lakehouse architectures to support analytical, operational, and reporting use cases.
• Data Migration Support: Support phased data migration from legacy databases and ETL tools to Azure Databricks environments, including transformation documentation and data mapping.
• Lakehouse & Data Layer Design: Implement layered lakehouse data architectures (e.g., bronze, silver, gold layers) in Databricks to support data quality, performance, and downstream reporting needs.
• Python & PySpark Development: Develop data processing notebooks, workflows, and distributed data transformations using Python and PySpark within Databricks environments.
• Data Quality & Validation: Develop data validation, reconciliation, and testing processes to ensure data accuracy, completeness, and consistency across data domains.
• Data Integration & Interoperability: Integrate Databricks data platforms with analytics and reporting tools to enable business intelligence and operational dashboards.
• Data Governance & Security Implementation: Support data governance initiatives including metadata management, data catalog integration, encryption, access controls, and compliance with federal data protection requirements.
• DevOps & CI/CD Support: Maintain source control and CI/CD pipelines for Databricks and data engineering workflows, supporting automated promotion across environments.
• Technical Collaboration: Work closely with data architects, solution architects, business analysts, and reporting teams to implement approved data solutions.
• Operational Support & Troubleshooting: Provide ongoing support for Databricks workflows, resolve pipeline failures, and troubleshoot complex data processing issues.
• Mentorship & Knowledge Sharing: Provide guidance to junior data engineers and contribute to documentation and team enablement.
• Works under minimal supervision with minor guidance from senior personnel.

Skills & Work Experience

• Professional Experience: 7+ years of experience in data engineering, ETL development, or large‑scale data integration environments.
• Strong experience designing and developing ETL pipelines and data transformations in Azure Databricks environments.
• Strong proficiency in SQL and Python, with hands on experience using PySpark for distributed data processing.
• Experience working with cloud‑based data platforms, data lakes, and lakehouse environments, preferably on Microsoft Azure.
• Experience implementing layered lakehouse data architectures (bronze, silver, gold) for enterprise analytics.
• Familiarity with Spark‑based big data processing frameworks.
• Experience supporting data migration from legacy databases and ETL tools to Databricks‑based platforms.
• Experience integrating Databricks platforms with business intelligence and reporting tools such as Power BI.
• Familiarity with data governance, metadata management, and data security best practices.
• Experience with source control and CI/CD pipelines for data engineering and Databricks workflows.
• Working knowledge of SDLC and Agile delivery methodologies.
• Excellent organizational, communication, and collaboration skills.

Preferred Skills

• Hands on experience with Azure Databricks workflows, Delta tables, and Databricks job orchestration.
• Experience with Azure Data Lake, Azure Data Factory, or similar Azure data services.
• Experience supporting federal IT modernization or large‑scale enterprise data transformation initiatives.
• Familiarity with healthcare, insurance, or benefits administration data environments.
• Experience implementing data governance or data catalog platforms.

Education

Bachelor’s degree in Computer Science, Engineering, Information Systems, or a related technical discipline. Equivalent education or professional experience will be considered in lieu of a degree.

Clearance

Must be a U.S. citizen and be able to obtain a Public Trust clearance.

Benefits

• Paid vacation & Sick leave
• Health insurance coverage
• Career training
• Performance bonus programs
• 401K contribution & Employer Match
• 11 Federal Holidays