- 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
- Must be a US Citizen
- Bachelor's Degree in Computer Science, IT, Computer Engineering, or related field
- Minimum of 4 years of experience in data engineering and data warehousing using Azure Data Factory, Azure Synapse, ADLS.
- Minimum of 2 years of specialized experience 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
- 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
Azure Data Engineer - Washington, United States - Analytica
Description
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):
Basic Qualifications:
Preferred Qualifications:
Analytica LLC. is an Equal Employment Opportunity and Affirmative Action employer. We value diversity at all levels. All individuals, regardless of personal characteristics, are encouraged to apply. All qualified applicants will receive consideration for employment without regard to sex, pregnancy, race, religion or religious creed, color, gender, gender identity, gender expression, national origin, ancestry, physical or mental disability, medical condition, genetic information, marital status, registered domestic partner status, age, sexual orientation, military or veteran status, protected veteran status, or any other basis protected by federal, state, local law, ordinance, or regulation and will not be discriminated against on these bases.