Job Description
Apply On-line

Title Data Engineer
Job Reference 21-0185
Post Date 7/29/2021
CARC Yes
City/Location Telecommute
Point of Hire Nationwide, USA
Company AIT-Arctic Information Technology, Inc.
Type of Position Regular Full-Time
FLSA Status Exempt
Description

JOB SUMMARY:  

The Data Engineer’s main responsibility is to be the single Point-of-Contact for the data related requirements and design, data integrity and security, data mapping for application migration and integration, and data flows during Dynamics 365 implementation projects for Arctic IT.  Responsibilities include but are not limited to analyzing Client’s existing data and the solution requirements to design how all data will be handled, including how data will be migrated, how data flows through all the integrated systems, how the data will be used and analyzed, complete data mapping, understand and develop database schemas, and designing/developing/managing SQL databases.  The Data Engineer will be responsible for making decisions about the technologies and the architecture to be used to support the data requirements on projects.  A strong understanding of Microsoft SQL Server and Microsoft Azure is required along with a base understanding of third-party data management tools.  

ESSENTIAL FUNCTIONS:  

  • Thorough understanding of legacy data models (through analysis and investigation) to complete data migration and integration 

  • Design, create, and maintain the Dynamics 365 entity model to support extended functionality for Client needs 

  • Creates data models utilizing best practices to ensure optimal and acceptable performance  

  • Create and manage data flow diagrams and responsible for understanding the overall data ecosystem of large enterprise systems 

  • Create data mappings and data migration plans 

  • Designs and implements data integrations between disparate systems 

  • Create and manage SQL database(s) used for data archiving and/or report servers, and other needs for Arctic IT Clients utilizing Microsoft Azure SQL and SQL Server 

  • Work with project teams on reporting related questions, tasks, and implementation 

  • In coordination with development and/or QA team members create and execute load testing plans to validate database performance  

  • Coordinate with project Architects to ensure consistency in implementation tools and processes among the various systems. 

  • Responsible for data privacy and security and ensuring compliance with federal, state, and other applicable laws 

  • Functions as the liaison to work with Client IT or other team members as it relates to data to ensure the work is completed and transitioned 

  • Functions as a data Subject Matter Expert and accountable to the Senior Program Manager regarding data (questions, challenges, risks, etc.) 

  • Other duties as assigned 

Requirements

QUALIFICATIONS: 

  • Bachelor’s degree in Business, Computer Science, or equivalent education and experience 

  • Minimum 5 years of experience working in Microsoft SQL data initiatives such as data integration, database administration, data migration, reporting, etc. with progressive responsibilities 

  • Excellent Microsoft SQL Server skills: Certifications preferred but not required 

  • Expertise in Extract-Transform-Load process definition and execution 

  • Expertise with data migration tools such as, SSIS, Scribe, Kingsway Soft  

  • Knowledge of the Microsoft Power Platform including LogicApps 

  • Experience supporting performance and load testing, analysis, and evaluation of results, and providing recommendations 

  • Skilled in understanding and maintaining data integrity, developing documentation, and ability to be accountable for overall data validation 

  • Able to assimilate unstructured information and produce clear data plans for large enterprise-level IT projects 

  • Must have valid state driver’s license, reliable personal transportation, and auto insurance 

  • Applicants subject to government security investigations and must meet eligibility requirements related to the clearance process 

WORKING ENVIRONMENT:  The majority of work for this role is performed in a home office and interacts with a wide variety of people with differing functions, personalities, and abilities.  Telecommuters are expected to have sufficient home office space that appears neat, organized, and professional when on video meetings. Overnight travel up to 10% may be required. 

PREFERENCE STATEMENT: Arctic Information Technology, Inc. grants preference to qualified Doyon Shareholders first, and second to qualified shareholders of other Alaska Native corporations that grant a similar preference in all phases of employment and training, which include, but are not limited to hiring, promotion, layoff, transfer, and training. 

  • Except as provided otherwise under applicable law, all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, or national origin. We are also an equal opportunity employer of individuals with disabilities and protected veterans.
  • Please view Equal Employment Opportunity Posters provided by OFCCP here.
Apply On-line
Send This Job to a Friend