Progilisys

  • BI/ETL SQL Developer

    Job Locations US-AZ-Phoenix
    Posted Date 3 months ago(10/9/2018 6:15 PM)
    Job ID
    2018-2188
    # of Openings
    3
    Category
    Information Technology
  • Type

    Contract

    Type Details

    Potential FTE, 1099 - Long-Term Contract, W2 - Long-Term Contract

    Complete Description

    Our Customer located in Phoenix, AZ is looking for a BI ETL Business Analyst that will be responsible for gathering requirements, building requirements documents, wireframes, user stories, and general data analysis and data flows for the design and development of our Customers medical records environment for their enterprise data warehouse.  The role will assist with full systems development life cycle (SDLC) phases including requirements gathering, data analysis, system design, development, implementation, and post-implementation support.  During the design phase, the role will work closely with the ETL development team and business stakeholders to follow industry best practices and company standards.  During the development phase and under the guidance of Senior staff, the role will perform business requirements definition and analysis for the normalization of customer data. 

     

    Education & Experience

    Required

    • Bachelor's Degree in Business Administration, Computer Science, Mathematics, Engineering, or related field with programming and database systems coursework, OR equivalent database development experience.
    • 5+ years of experience with ETL in Data Management, Data Warehousing, or Business Intelligence
    • 5+ years of experience with SQL
    • Experience with mapping, architecting, profiling, analysis, integrity checking of data, etc.
    • Experience in gathering business requirements from cross functional teams
    • Experience with SSIS, MSSQL Server and Visual Studio
    • Working knowledge of TFS, or comparable source control tool

     

    Preferred

    • Experience with SQL Server Integration Services (SSIS) version 2015 and MSSQL Server 2015
    • Experience in Agile-Scrum environment
    • Experience with data analysis in the healthcare industry
    • Familiar with star and snowflake schemas

     

     Key Responsibilities

    • Participates in gathering ETL requirements from business analysts and owners to produce requirements documents.
    • In collaboration with the Sr. Developers, assists with developing database object analysis, and creates ETL requirments.
    • Analyses and validates databases, table spaces, tables, indexes, triggers, procedures, and other database objects.
    • Helps define the content and structure of the database (schema) and advises users on efficient techniques for extracting data. Works within defined content and structure of the database (schema).
    • Work with team to implement changes and provide post-implementation user support and system support.
    • Identifies and advocates beneficial change opportunities.
    • Serves as a point of contact for application and data users, data administrators and others.
    • Ensures compliance with Company’s HIPAA, privacy and government security policies.
    • Performs other duties as assigned.
    • Regular and reliable attendance is required.

     

    Competencies

    Technical Skills

    Working knowledge of data warehouse design; data modeling; proficiency with SQL; experience with data extraction, transformation, and loading (ETL); working knowledge of report and dashboard development; knowledge of SQL Server databases; working knowledge of Oracle databases.

     

    Problem Solving / Analysis

    Ability to solve problems through systematic analysis of processes with sound judgment; Has a realistic understanding of relevant issues.

     

    Organizational Skills

    Ability to organize people or tasks, adjust to priorities, learn systems, within time constraints and with available resources; Detail-oriented.

     

    Multi-Tasking / Time Management

    Prioritize and manage actions to meet changing deadlines and requirements within a high volume, high stress environment.

     

    Information Management

    Ability to manage large amounts of complex information easily, communicates clearly, and draws sound conclusions.

     

    High Intensity Environment

    Ability to function in a fast-paced environment with multiple activities occurring simultaneously while maintaining focus and control of workflow.

     

    Coping / Flexibility

    Resiliency in adapting to a variety of situations and individuals while maintaining a sense of purpose and mature problem-solving approach is required.

     

    Computer Literacy

    Ability to function in a multi-system Microsoft environment using Word, Outlook, Company Intranet, the Internet, and department software applications.

     

    Communication / People Skills

    Ability to influence or persuade others under positive or negative circumstances; Adapt to different styles; Listen critically; Collaborate.

    If you are interested in this opportunity, please send us your resume, availability to interview and salary requirements immediately.  If you are not and know of someone that qualifies or is looking for opportunities, please forward their contact information.  We compensate for referrals that are successfully placed.

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed