Data Engineer at Hunatek

Fort Belvoir, Virginia, United States -

Full Time

Start Date

Immediate

Expiry Date

17 Jun, 26

Salary

110000.0

Posted On

19 Mar, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Azure SQL Managed Instance, Stored Procedures, Views, Functions, Python, Azure DevOps, Azure Data Factory, Pandas, Polars, SQL Alchemy, APIs, JSON, SFTP, DacPac, CI/CD, Data Modelling

Industry

IT Services and IT Consulting

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. 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. 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.

Responsibilities

The Data Engineer will design, develop, and manage high-quality solutions within an Azure SQL Managed Instance environment, focusing on applications and data pipelines, which includes writing and maintaining database objects like stored procedures and views. Key functions involve providing database performance-tuning expertise, managing environments, writing Python code for data manipulation, ingesting API data, creating flat files, and deploying updates using Azure DevOps CI/CD pipelines.