Description

HunaTek is seeking a Data Engineer who will be responsible for design, development and management of high quality, efficient and effective solutions in an Azure SQL Managed Instance environment to support a number of applications as well as several data pipelines/import & export tasks. This includes the ability to write and maintain stored procedures, views, functions or other database objects to support the applications. Experience with Python, Azure DevOps and Azure Data Factory is highly desired.   Essential Job Functions:

• Provide database performance-tuning expertise for Azure SQL Managed Instance databases. Identify and solve performance bottlenecks in Azure SQL Managed Instance database platforms supporting numerous applications including transactional databases and Data Warehouses. 
• Manage Azure SQL Managed Instance database environments that support transactional data as the backend for numerous applications.  
• Write Python code to manipulate data using DataFrame libraries such as Pandas/Polars & connecting to an Azure SQL Managed Instance using an Object Relational Mapper (ORM) such as SQL Alchemy.
• Ingest data from Application Programming Interfaces (APIs) and work with JSON data ranging from being simple in structure to deeply nested/complex.
• Create flat files with varying delimiter/line-termination requirements and automate the import/export of those files using Secure File Transfer Protocol (SFTP).
• Deploy database definition updates utilizing DacPac tasks in Azure DevOps Continuous Integration/Continuous Deployment (CI/CD) release pipelines.
• Automating the delivery of reports with varying frequencies (daily, weekly, monthly, quarterly, etc.) and manually delivering reports as needed.
• Demonstrate a strong background in data modelling, data management and data manipulation, code management and version control.  

Skills and Qualifications Required:  

• Demonstrate a logical and structured approach to time management and task prioritization.  Work within project timelines and budgets. Be able to organize own time, schedule tasks for completion and deliver work to that schedule. 
• Self-motivated and willing to "do what it takes" to get the job done 
• A strong level of attention to detail in order to spot and address data anomalies/discrepancies when they arise.
• Capable of reasoning and thinking through problems and developing desired solutions, independently or with others as required  

Skills and Qualifications Preferred:  

• Experience creating and maintaining Azure Data Factory pipelines
• Excellent written and verbal communication and presentation skills 

Please note, this position is required to be on-site at Fort Belvoir 5 days per week.   About Us: At HunaTek, we build teams of people from all backgrounds with varying levels of experience, knowing firsthand that diversity of thought will strengthen our ability to deliver for our customers. We work hand in hand with Federal civilian and military staff, pulling together to further the interests of our nation and home and abroad. Whenever possible, we provide opportunities for our employees to learn new skills, obtain certifications, attend industry events, and have some fun together.   Our Benefits: We offer a comprehensive benefits package designed to make sure our employees and their families have access to good health care, are insured against catastrophic health events, can put money aside for retirement and are able to maintain a healthy work-life balance. These benefits include: Comprehensive medical, dental and vision Long-term and short-term disability insurance and term life insurance 401(K) with safe harbor contribution Paid time off and 11 paid holidays Tuition and career development assistance A selection of voluntary benefits   This job description will be reviewed periodically as duties and responsibilities change with business necessity. Essential and marginal job functions are subject to modification.   Equal opportunity employer as to all protected groups, including protected veterans and individuals with disabilities.

PI280380671