Skip to main content

(x2) Data Engineer

Technology
1 week ago
Service contract

Job description

    Project Overview: Maricopa County is migrating data from current environments to MS Dynamics Platform. Apex is providing subject matter expertise in MS Dynamics in support of the County's migration strategy, roadmap and work-streams related to the data migration Support the strategy and optimize for migrating from current environment to MS Dynamics Platform. Support migration activities as directed by County Migration Project The team will work at the direction of Maricopa County and will assist in migration of data from current environment to MS Dynamics. The Apex consultants will also seek to make recommendations for improvements to Governance, Architecture & Integration as well as outlining a strategic approach for laying the foundation of an effective data value pipeline.

    Person to have no less than Ten (10) years of experience with MS SQL Server in all of following areas:

    • Proficiency reading and writing TSQL.
    • Elite ability to create optimized database objects (examples: Store Procedures, Views, Tables, etc.)
    • Aptitude to learn/investigate with a minimum of handholding in the retrieval and analysis of data (Data Mining)
    • Creating simple Data Dictionaries allowing for information to be shared among the DBA Team
      • There are many techniques and tools one can use to achieve this task
    • Proficiency in tracing Applications to capture the detailed information in regard to associated database queries and/or inline code involved in the workings of the Application (example the use of SQL Server Profiler)
    • Create/Maintain/Update SSIS Packages to include notations and maintainability
    • Index and Performance tuning of SQL queries and services

    Required Skills

    Basic Qualification :

    Additional Skills :

    Background Check :Yes

    Drug Screen :Yes

    Notes

    Selling points for candidate :

    Project Verification Info

    Exclusive to Apex :Yes

    Face to face interview required :No

    Candidate must be local :No

    Candidate must be authorized to work without sponsorship ::No

    Interview times set :Yes

    Type of project :Development/Engineering

    Master Job Title :Data Analyst

    Branch Code :Phoenix

    Interested in this role?