Published date Posted on Indeed on Jul 30, 2021 (60 d ago)
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


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.

Let us know

Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if:

Loading...
Success
Error on reporting

Related jobs

Blue Orange Digital Blue Orange Digital |
|
7 d ago

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

Liberty IT Solutions Liberty IT Solutions |
Today

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 Benefitfocus |
Today

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

HealthLabs.com HealthLabs.com |
Today

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

Arctic Information Technology Arctic Information Technology... |
12 d ago

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.

Arctic Information Technology Arctic Information Technology... |
12 d ago

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.

Arctic Information Technology Arctic Information Technology... |
27 d ago

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