Business/ Data Analyst (SQL/ ETL) – CA only Remote

Dice

MO, St Louis

This job has been expired

job summary:

If you feel you would be great fit for this , Kindly contact me @9543086103, [email protected]

Flexible – Anytime between 7:00 AM and 5:30 PM

No overtime required

Remote in CA only; Although this is a CA-only REMOTE position, it is preferred candidates is near Sacramento area and/or Woodland Hills area.

Primary Preference near Rancho Cordova’s Office;

Secondary Preference in near Woodland Hills’ Office.

exception – occasionally meet in-office for team meeting.

Please put candidates location at top of resume

This is contract-to-hire

Position Purpose: Plan, design, develop, and launch efficient information systems and operations systems in support of core organizational functions.

  • BI Foundation Tables is source-of-truth for the team’s analytics and this role requires someone to access team needs on the BI Foundation Tables and decide on how to best support the needs.
  • Responsible for code deployment and ETL implementation.
  • Drive Data architect design and best practice.
  • Monitor and report any data source discrepancy to Corp IT.
  • Assist in writing complex SQLs and in performance tunings of Teradata SQL.

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

  • Timely releases/publication of enhancement to BI Foundation Table.
  • Diagnose and Identify problems (performance, data discrepancy) and resolve issue within 24-48 hours.

Tell me about what their first day looks like:

  • Meeting with IT Dept to review system access setup
  • Attend online corporate compliance courses modules
  • Introduction meeting with Hiring Manager and/or team(s).
  • If time permit, training/shadowing sessions.

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

  • Data Analytics, Sr. System Analyst, Sr Business System Analyst, BI Developer

Required Skills/Experience:

  • strong SQL Skills (eg Create Table, Performance Tuning, Stored Procedures, etc.)

  • ETL (Extract, Transform, Load) Process Automation to load/extract data from various sources.

  • Knowledge of BI, Data Warehousing and Teradata architecture. This includes data modeling, database Management, and data mining.

    Preferred Skills/ Experience:

  • 5+ years of experience in using Teradata SQL, SAS, Oracle, Snowflake, and utilities like FASTLOAD, MULTILOAD, FAST EXPORT and BTEQ script.

  • 5+ years of experience with Information Technology.

  • Ability to create technical and business process workflow diagrams.

    Education Requirement:

    Bachelor in math, statistics, information systems, computer science, or related field.

    Education Preferred:

    Master in math, statistics, information systems, computer science, or related field.

    Software Skills Required:

    SQL, ETL application, Python

    location: Saint Louis, Missouri

    job type: Contract

    salary: $48.71 – 54.79 per hour

    work hours: 8am to 4pm

    education: Bachelors

    responsibilities:

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

    • BI Foundation Tables is source-of-truth for the team’s analytics and this role requires someone to access team needs on the BI Foundation Tables and decide on how to best support the needs.
    • Responsible for code deployment and ETL implementation.
    • Drive Data architect design and best practice.
    • Monitor and report any data source discrepancy to Corp IT.
    • Assist in writing complex SQLs and in performance tunings of Teradata SQL.

    qualifications:

    • Experience level: Experienced
    • Education: Bachelors

    skills:

    • Business Analysis
    • ETL

    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 [email protected]

    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.