Azure Data Engineer

Analytica is seeking an Azure Data Engineer (ETL Developer) to support a dynamic federal government project. The ideal candidate will be responsible for the design, development, and implementation of the extract, transform, load (ETL) and reporting of the data warehouse dataset, as well as determining data accuracy and determine optimal structure for analysis and reporting purposes. 

Analytica has been recognized by Inc. Magazine as a fastest-growing private US small business. We work with U.S. government customers in health, civilian, and national security missions. Analytica offers competitive compensation with opportunities for bonuses, employer paid health care, training and development funds, and 401k match. 

 Responsibilities include (but not limited to): 

• Designing, developing, testing, and deploying data pipelines, data warehouses, and data lakes using Azure Data Factory, Azure Synapse, ADLS, T-SQL scripts and Python notebooks. 
• Manage data quality and integrity, resolving issues, and creating technical documentation.
• Automate data platform operations and manage the post-production system and processes. 
• Design efficient data models from a logical design based on business requirements and available use patterns. 
• Ability to triage and self-direct, prioritize and manage time effectively 

Basic Qualifications: 

• Bachelor’s Degree in Computer Science, IT, Computer Engineering, or related field 
• 5+ years in the software engineering profession 
• At least 3 years of experience in data engineering and data warehousing using Azure Data Factory, Azure Synapse, ADLS. 
• Proficient in Dimensional data modeling, T-SQL development, Python, and familiar with Spark 
• Experience with methodologies agile development and DevOps tools, such as Azure DevOps, GitHub, or GitLab 

Preferred Qualifications: 

•   Exposure to metadata management including data catalogs using Microsoft Purview 
• Exposure to Microsoft Fabric 
• Experience with creating Power BI reports and dashboards 
• Experience with data quality, data governance, and data security best practices   

About Analytica: Analytica is a leading consulting and information technology solutions provider to public sector organizations supporting health, civilian, and national security missions. The company is an award-winning SBA certified 8(a) small business that has been recognized by Inc. Magazine each of the past three years as one of the 250 fastest-growing companies in the U.S. Analytica specializes in providing software and systems engineering, information management, analytics & visualization, agile project management, and management consulting services. The company is appraised by the Software Engineering Institute (SEI) at CMMI® Maturity Level 3 and is an ISO 9001:2008 certified provider.