Azure Data Engineer
Analytica is seeking an Azure Data Engineer to support data and analytics. The ideal candidate will be comfortable working directly with clients in both a consulting and delivery capacity to tackle complex, enterprise cloud or on-premises software and technology projects. Analytica is looking for bright, motivated professionals looking to continue their career in the data analytics field.
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):
Data sourcing and source system analysis.
Implement and build data pipelines for a data warehouse using Azure Data Engineering Stack - Azure Data Factory, Azure Synapse and ADLS.
Combine technical expertise and problem-solving passion to work closely with clients, turning complex ideas into end-to-end solutions that transform our clients' business.
Lead, design, develop and deliver large-scale data systems, data processing and data transformation projects that deliver business value for clients.
Conduct technical feasibility assessments and provide project estimates for the design and development of the solution.
Provide technical inputs to agile processes, such as epic, story, and task definition to resolve issues and remove barriers throughout the lifecycle of client engagements.
Automate data platform operations and manage the post-production system and processes.
Mentor, help and grow junior team members.
Bachelor’s degree in Math, Statistics, Economics, Computer Science, or any other quantitative field.
7+ years of experience with data integration, and database technologies, including Oracle, SQL Server, Postgres etc.
7+ years of experience in a role encompassing industry standard ETL development techniques and implementation of end-to-end data pipelines.
3+ years of experience with Azure Cloud SaaS solutions and managed services serverless technologies, including Azure Data Factory, Synapse Analytics and ADLS
Experience with data analysis and profiling of source data while developing or
Knowledge of data validation, cleansing, transformation, consolidation, de-duplication, aggregation, de-aggregation, and enrichment
Hands-on experience with Azure Data Engineering Stack - ADF, Synapse, SQL, Data Lakehouse, Python Notebooks
Experience in data warehousing methodologies and dimensional data modeling.
Experience working with code repositories and continuous integration.
Test, plan, creation and test programming using automated testing frameworks, data validation and quality frameworks, and data lineage frameworks.
Experience with Azure Platform CI/CD or DevOps
Experience with reporting data visualization tools such as Power BI or Tableau
Exposure to metadata management including data catalogs using Microsoft Purview
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.
As a federal contractor, Analytica is required to verify that all employees are fully vaccinated against COVID-19. If you receive an offer and are unable to get vaccinated for religious or medical reasons, you may request a reasonable accommodation.