HunaTek · 1 month ago
Data Engineer
Fort Belvoir, VA
Full-time
Onsite
Mid LevelHunaTek 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. The role includes writing and maintaining stored procedures, managing database environments, and automating report delivery.
Information TechnologyIT InfrastructureStaffing Agency
No H1B
U.S. Citizen Only
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
Qualification
Required
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
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
Preferred
Experience creating and maintaining Azure Data Factory pipelines
Excellent written and verbal communication and presentation skills
Benefits
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
Company
HunaTek
HunaTek is an IT company that specializes in information security, cloud migration, and staffing solutions.
Founded in 1999
51-200 employees
Funding
Current Stage
Growth StageLeadership Team
Mike Torres
President & CEO
Anna Jullien
Chief Financial Officer
Company data provided by crunchbase