Azure Data Engineer

ATTAINX INC • Herndon, VA

80d

About The Position

We are seeking an experienced Azure Data Engineer with proven ability to evaluate, optimize, and modernize enterprise data warehouse environments. The role combines deep technical skills with practical data integration expertise to deliver secure, scalable, and future-ready solutions in alignment with the government’s evolving Data/AI strategies.

Requirements

• Bachelor’s degree in Computer Science, Information Systems, Data Science, or related field (or equivalent experience).
• 5+ years of demonstrated experience engineering Azure data solutions (ETL/ELT, ADF, Synapse, Data Lake, SQL) to optimize performance, automate pipelines, and deliver scalable, future-ready data environments aligned to organizational strategy.
• Microsoft Azure Data Engineer Associate certification.
• 5+ years in Azure Data Engineering (ADF, Synapse, Data Lake, SQL).
• Background in SQL, data modeling, OLAP, and ETL/ELT processes.
• Experience building and optimizing metadata-driven ETL pipelines.
• Understanding of programming concepts (Python, PowerShell, Java, JavaScript, PL/SQL) as relevant to the customer data environment.
• Familiarity with BI/reporting platforms (Microsoft Fabric, Power BI) to integrate engineering solutions.
• Must be a U.S. Citizen with an Active US Secret Clearance.

Nice To Haves

• Power BI Data Analyst Associate certification.
• MS Azure Solutions Architect Expert certification.
• ITIL v4 Foundation certification.
• SAFe Agile certifications (Agilist/Practitioner).
• Experience with data governance, metadata management, and compliance frameworks.
• AWS Certified Data Analytics – Specialty or Google Professional Data Engineer.
• Knowledge of AI/ML integrations in data analytics.
• Familiarity with government or regulated industry data environments.

Responsibilities

• Assess the current state of the enterprise data warehouse, identifying gaps and optimization opportunities.
• Build and maintain ETL/ELT pipelines, with emphasis on metadata models and automation scripts to improve performance and ensure smoother transitions.
• Deliver hands-on engineering solutions across Azure Data Factory, Synapse Analytics, Data Lake, and SQL/Managed Instances.
• Prepare designs for supporting database systems and implement measures to improve performance and scalability.
• Collaborate with cross-functional teams to align engineering delivery with strategic objectives and roadmap execution.
• Maintain awareness of industry trends in BI/reporting (Microsoft Fabric, Power BI) and apply them in support of engineering tasks.
• Support projection planning (must have at a minimum of 1–2 year execution roadmap; 3–5 year scalability alignment planning experience).
• Develop, enhance, and troubleshoot pipelines, datasets, SQL queries, stored procedures, and integrated runtimes in the Azure data environment.
• Manage connections between the data factory, SQL managed instances, Power BI, Power Apps, and external/on-prem environments.
• Research, engineer, and implement new technologies to enhance data factory operations, migrations, and integrations.
• Document all new and current configurations, implementations, and developments to ensure continuity and support.

Benefits

• Paid vacation
• Medical insurance
• Dental insurance
• Vision insurance
• Matching 401K plan
• Tuition/training reimbursement
• Long & Short-Term Disability

What This Job Offers

• Career Level: Mid Level
• Education Level: Bachelor's degree
• Number of Employees: 101-250 employees