Designs and maintains scalable Azure data pipelines and ETL/ELT solutions across data lakes, warehouses, lakehouses, streaming platforms, and enterprise sources. Builds integrations using Azure Data Factory, Synapse, Databricks, Spark, Kafka, and related services; applies security, governance, monitoring, and performance optimization practices. Develops Power BI dashboards, reports, data models, and visualizations, while supporting analytics and AI/ML use cases. Collaborates in Agile teams and automates deployments through DevOps and CI/CD practices.
Description
About the Role:
We are seeking an experienced Azure Data Integration Engineer to support ATLAS, the VA’s open-architected, multi-cloud enterprise data management and analytics platform. In this role, you will design, develop, and maintain scalable Azure-based pipelines and ETL/ELT solutions that ingest, condition, curate, and transform multi-source data into standardized, consumable enterprise data products. You will use Azure Data Factory, Synapse, Databricks, Azure Data Lake, and related services to improve interoperability among key data platforms and provide consistent, secure access to trusted data regardless of its source or stage of curation. Working with analysts, data scientists, product teams, and enterprise users, you will help deliver actionable insights that enable evidence-based decisions and improve outcomes for Veterans and their families.
This hands-on role combines data integration engineering, cloud data architecture, governance, performance optimization, and analytics enablement across the ATLAS ecosystem.
Key Responsibilities:
As part of an Agile team, our Azure Data Engineer will:
- Design and implement scalable, secure, and efficient data pipelines using Azure Data Factory (ADF).
- Develop and optimize ETL processes to ingest, transform, and store data in Azure Data Lake, SQL, and Synapse Analytics.
- Automate data ingestion from structured and unstructured sources like APIs, databases, and IoT streams.
- Build and maintain data lakes, warehouses, and lakehouses using Azure Data Lake, Synapse, and Databricks.
- Optimize storage and retrieval of data using Parquet, Delta Lake, and columnar storage formats.
- Ensure high availability, scalability, and performance tuning for large-scale datasets.
- Implement batch and real-time data streaming solutions using Azure Stream Analytics, Event Hub, and Kafka.
- Work with big data processing frameworks such as Apache Spark (Databricks) and HDInsight.
- Integrate data from various sources like SQL Server, CosmosDB, SAP, and third-party APIs.
- Implement data security best practices, including RBAC, Azure AD, Managed Identities, and Key Vault.
- Work with Purview, Data Catalog, and metadata management tools to enforce data governance.
- Monitor and troubleshoot data pipeline performance using Azure Monitor, Log Analytics, and Application Insights.
- Optimize query performance in Synapse Analytics, SQL, and CosmosDB.
- Automate data quality checks, anomaly detection, and alerting mechanisms.
- Work closely with BI Developers and Cloud Engineers to support analytics and AI/ML use cases.
- Participate in Agile/Scrum ceremonies, design reviews, and technical discussions.
- Document data flows, best practices, and architecture decisions.
- Design, develop, and optimize Power BI dashboards and reports for business intelligence and analytics.
- Create interactive visualizations using advanced DAX, Power Query (M), and custom visuals.
- Develop paginated reports using Power BI Report Builder
- Ensure compliance with cloud security best practices and industry standards (ISO 27001, GDPR, HIPAA).
- Automate deployments with Azure DevOps, GitHub Actions, and CI/CD pipelines.
- Work closely with Cloud Engineers and DevOps teams to optimize deployment strategies.
- Collaborate with software engineers, architects, and DevOps teams to build robust applications.
- Participate in code reviews, sprint planning, and Agile/Scrum ceremonies.
- Document technical solutions and best practices.
Minimum Qualifications:
- Bachelor’s degree in computer science or a related technical field.
- Minimum of five (5) years of practical experience in cloud application development with Microsoft Azure.
- Expertise in Azure Data Factory (ADF), Synapse Analytics, Data Lake, Databricks, DAX, Power Query (M), and data modeling.
- Strong SQL skills with experience in T-SQL, query optimization, and database performance tuning.
- Experience in big data processing using Apache Spark, Python, or Scala.
- Experience integrating Power BI with Azure SQL, Data Lake, and Synapse Analytics.
- Understanding of ETL processes, data warehousing, and BI best practices.
- Strong knowledge of Row-Level Security (RLS) and Power BI service administration.
- Hands-on experience with real-time data streaming (Kafka, Event Hub, Stream Analytics).
- Familiarity with DevOps for data pipelines, CI/CD, and Infrastructure as Code (Terraform, Bicep).
- Knowledge of Azure AD authentication, security best practices, and cloud monitoring.
- Ability to obtain and maintain a Public Trust or Suitability/Fitness determination based on client requirements
- Knowledge of Agile, Scrum, and SAFe methodologies.
- Careful, reliable, and detail-oriented when performing high impact administration tasks
- Experience with Synapse Pipelines, Starburst, Azure Data Lake Service, Collibra for data cataloging, Azure ML/AI services, and Pyramid Analytics for visualization.
Preferred Qualifications:
- Microsoft Certified: Azure Data Engineer Associate (DP-203)
- Microsoft Certified: Power BI Data Analyst Associate (PL-300)
- Experience with CosmosDB, Delta Lake, and NoSQL solutions.
- Knowledge of Machine Learning and AI integration with data pipelines.
- Familiarity with Power BI, Looker, or Tableau for data visualization.
- Knowledge of Azure architecture such as Azure services and portal, Azure Government Cloud, SQL Administrator, SQL reporting, APIs, authorization methods for applications and APIs, migrating SQL schemas and data between environments
- Experience in embedded analytics and Power BI API integration.
Comprehensive healthcare coverage, HSA Plan, Life and Disability Insurance, and Retirement Savings Plan.
Similar Jobs
Cloud • Information Technology • Security • Software • Cybersecurity
Leads and grows a regional sales engineering organization, recruiting and developing team members while scaling discovery, technical qualification, and proof-of-concept processes. Partners with sales, product, engineering, customers, and partners to design and present value-based solutions, drive revenue, and close deals. Provides consultative AI guidance, cybersecurity and networking expertise, and supports strategic solutions in a matrixed go-to-market environment.
Top Skills:
Artificial IntelligenceCoding AssistantsCybersecurityGenerative AiLlmsNetworkingSaaSSaseZscaler Zero Trust Exchange
Aerospace • Hardware • Information Technology • Security • Software • Cybersecurity • Defense
Supports enterprise contract lifecycle management processes by translating business needs into requirements, mapping workflows, configuring CLM modules, validating data, supporting integrations and UAT, and coordinating deployment. Partners with legal, contracts, supply chain, proposal, IT, and program stakeholders. Provides user guidance and training, manages issue triage and backlog refinement, and supports compliance, governance, reporting, and continuous improvement of CLM capabilities.
Top Skills:
AgileContract Lifecycle Management (Clm) SystemsIcertis Contract Intelligence (Ici)SirionWaterfall
Aerospace • Hardware • Information Technology • Security • Software • Cybersecurity • Defense
Administers and configures Salesforce CRM systems, including interfaces, reports, dashboards, workflows, maintenance, upgrades, data integrations, and process improvements. Provides user support and training while collaborating with cross-functional teams. Ensures compliance with federal regulations and cybersecurity policies. The role requires substantial IT and Salesforce administration experience, with development, migration, integration, SDLC, and federal contracting experience preferred.
Top Skills:
ApexSalesforce CRMVisualforce
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
