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.
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
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.
Let us know
Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if:
Senior Data Analyst: This is a full-time fully remote position for Latin-American-based applicants within +/- 2 hours of Eastern Standard Timezones (NYC).Applicants must have very strong written and oral communication in English.—Data Analyst:Blue Orange is looking for a Se
Senior Staff Software Architect Are you passionate in architecting Enterprise Software? Would developing cutting-edge energy solutions excite you? Join our Enterprise Technology team Our Enterprise technology team is developing cutting-edge and innovative solutions to monitor, co
Summary: Liberty IT Solutions, a Booz Allen company, is hiring a Database Developer/Database Administrator to provide configuration, design, build out and support of cloud native data management platforms. The Database Developer/Database Administrator is responsible for developin
Benefitfocus, Inc. (NASDAQ: BNFT) is a leading provider of cloud-based benefits software solutions for consumers, employers, insurance carriers and brokers. Benefitfocus has served numerous consumers on its platform that consists of an integrated portfolio of products and service
Description:HealthLabs.com's mission is to provide easy, accessible and affordable online health care services for everyone. Everything we do focuses on helping our patients become healthier and happier. We have easy-to-use online platforms that provide fast, convenient, private.
More jobs by this company
Job Reference 21-0241Post Date 9/15/2021CARC YesCity/Location TelecommutePoint of Hire Nationwide, USACompany AIT-Arctic Information Technology, Inc.Type of Position Regular Full-TimeFLSA Status ExemptDescription The Application Developer- Finance will utilize best practices and.
Job Reference 21-0244Post Date 9/15/2021CARC YesCity/Location TelecommutePoint of Hire Nationwide, USACompany AIT-Arctic Information Technology, Inc.Type of Position Regular Full-TimeFLSA Status ExemptDescription The SQA Analyst is responsible for supporting the planning, design.
Job Reference 21-0223Post Date 8/31/2021CARC YesCity/Location TelecommutePoint of Hire Nationwide, USACompany AIT-Arctic Information Technology, Inc.Type of Position Regular Full-TimeFLSA Status ExemptDescription The Application Developer will utilize best practices to design, cu