Senior Business Systems Analyst (EDW) (Data mapping, SQL and ETL concepts)

Senior Business Systems Analyst (EDW) (Data mapping, SQL and ETL concepts)

26 Mar 2024
Missouri, Saintlouis, 63105 Saintlouis USA

Senior Business Systems Analyst (EDW) (Data mapping, SQL and ETL concepts)

Vacancy expired!

job summary:

Remote


8AM-5PM EST


Position Purpose: Design, build, test and maintain enablers of business processes, including technology and process solutions with a focus on medium to high complexity, multiple large application business processes and/or business relationships


Education/Experience: Bachelor's degree in Computer Science, MIS, related field or equivalent experience. 3+ years of related experience. Knowledge of programming languages, project management, and application or systems development methodologies, RFP, contracting and new business implementation may be required. Relational Database (Oracle, UDB, Sybase, SQLServer). Requires either healthcare data/systems/process experience, strong dimensional data modeling/data warehousing experience.


Walk me through the day to day responsibilities of this the role and a description of the project (Outside of Workday JD):



  • Gather data extract requirements from the business
  • Document and perform data mapping
  • Analyze the data set requested for and report any data quality or observations with the third party entity and internal team
  • Write SQL, analyze data sets for various standard extracts
  • Understand full vs incremental extracts
  • Understanding of stored procedures to create extracts or ETL processes
  • Some previous Pharmacy exposure would be a plus




Describe the performance expectations/metrics for this individual and their team:



  • Go to multiple meetings about our new PBM (ESI) and take notes
  • Write BRD and create data mapping documents




Tell me about what their first day looks like:



  • First day is to meet and greet with team members and work with leads to get access to various DBs




What previous job titles or background work will in this role?


Data Analyst / Business Analyst




Required Skills/Experience:




1.


Data mapping from various data sources


2.


Understanding of health care data sets


3.


SQL and ETL concepts




Preferred Skills/ Experience:




1.


Data Lake (Hadoop) understanding


2.


GreenPlum Database


3.


Pharmacy knowledge




Education Requirement:


Bachelor's degree




location: CLAYTON (ST. LOUIS AREA), Missouri

job type: Contract

salary: $37.47 - 42.15 per hour

work hours: 8am to 4pm

education: Bachelors



responsibilities:

Position Purpose: Design, build, test and maintain enablers of business processes, including technology and process solutions with a focus on medium to high complexity, multiple large application business processes and/or business relationships


Walk me through the day to day responsibilities of this the role and a description of the project (Outside of Workday JD):



  • Gather data extract requirements from the business
  • Document and perform data mapping
  • Analyze the data set requested for and report any data quality or observations with the third party entity and internal team
  • Write SQL, analyze data sets for various standard extracts
  • Understand full vs incremental extracts
  • Understanding of stored procedures to create extracts or ETL processes
  • Some previous Pharmacy exposure would be a plus








qualifications:


  • Experience level: Experienced
  • Education: Bachelors


skills:
  • Business Analysis
  • Business Systems Analyst
  • Data Warehouse
  • ETL
  • EDW
  • Data Analysis
  • SQL




  • Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

    At Randstad, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.

    Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).



    For certain assignments, Covid-19 vaccination and/or testing may be required by Randstad's client or applicable federal mandate, subject to approved medical or religious accommodations. Carefully review the job posting for details on vaccine/testing requirements or ask your Randstad representative for more information.

    Related jobs

    Job Details

    • ID
      JC49554064
    • State
    • City
    • Job type
      Contract
    • Salary
      USD37 - USD42
    • Hiring Company
      Randstad Technologies
    • Date
      2023-03-26
    • Deadline
      2023-05-25
    • Category

    Jocancy Online Job Portal by jobSearchi.