Michigan Jobs

Data Warehouse Analyst

job details:

• location:Farmington, MI

• salary:$35 - $42 per hour

• date posted:Wednesday, January 13, 2021

• job type:Contract

• industry:Finance and Insurance

• reference:815417

job description

Data Warehouse Analyst

job summary:

Looking for a Data Warehouse Analyst with SQL, Linux Shell Scripting and ETL experience for a year long contract. This is a work from home role but candidates should be within reasonable driving distance of our clients technology office located in Farmington Hills Michigan, in case the role should turn into a fulltime permanent position. This role will be working at one of our best financial clients.

location: Farmington, Michigan

job type: Contract

salary: $35 - 42 per hour

work hours: 8am to 4pm

education: No Degree Required

responsibilities:

Looking for a Data Warehouse Analyst with SQL, Linux Shell Scripting and ETL experience for a year long contract. This is a work from home role but candidates should be within reasonable driving distance of our clients technology office located in Farmington Hills Michigan, in case the role should turn into a fulltime permanent position. This role will be working at one of our best financial clients.

Best Vs Average Candidate (BACKGROUND ) :

Large organization exp

SUMMARY OF DAY TO DAY RESPONSIBILITIES:

The role performs BAU and project activities:

• Development and maintenance of extract-transform-load (ETL) processes. strong SQL knowledge is required-preferably Teradata-as well as working knowledge of Linux and shell scripting. Python skills are a bonus.

• On call production support for daily batch processes with strong debugging and communication skills. Mainframe skills are a bonus but can be developed on the job.

• Backup for Hyperion/Essbase administration

Must have :

The role performs BAU and project activities:

• Development and maintenance of extract-transform-load (ETL) processes. strong SQL knowledge is required--as well as working knowledge of Linux and shell scripting. Python skills are a bonus.

• On call production support for daily batch processes with strong debugging and communication skills.

Nice to have :

Previous client experience

Backup for Hyperion/Essbase administration

preferably Teradata

Mainframe skills are a bonus but can be developed on the job.

Skills needed for submittals

Has this candidate worked as a former client Contractor via SOW? Yes or no

Has your candidate worked at our client as a Full Time employee? Yes or no

SQL- years

Assessments (Debugging/troubleshooting)-years

ETL-years

Proficiency in Linux shell scripting and system administration-years

Hyperion Essbase-years

Knowledge of Mainframe technology-years

Teradata-Yrs

qualifications:

• Experience level: Experienced

• Minimum 3 years of experience

• Education: No Degree Required

skills:

• SQL (3 years of experience is required)

• etl (2 years of experience is preferred)

• PRODUCTION SUPPORT (2 years of experience is preferred)

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.