Data Engineer

Hunatek•Fort Belvoir, VA

29d•Onsite

About The Position

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. This position requires a government background check and the candidate must be a green card holder or be a US-citizen. 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.

Requirements

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
This position requires a government background check and the candidate must be a green card holder or be a US-citizen.

Nice To Haves

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

Responsibilities

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.