It Data Warehousing Analyst

Job Title - IT Data Warehousing Analyst (Remote)
Location - Troy, MI 48083 Hourly Pay Rate - $46/hr. Contract to hire position
Shift - Mon-Fri 8 hour/day NOTE: Remote for now, will eventually work from the HAP office in Troy Will be using Datastage/Cognos/PowerBI.
Conversion Salary will be largely based on performance and number of years of relevant experience.

The tentative range is 80k 95k. Job Description: **REQUIRED: Bachelor's Degree, Minimum of 5 years applicable experience (3 years in healthcare setting preferred)**
Remote Position: Local candidates preferred.
For an ideal candidate in SQL, we do expect below things (rating: >7 out of 10):
Proficient in usage of different analytical functions (Partition By, Rank, Sum, Group By, Order By clauses, Lead, Lag, etc )
Optimize SQL queries/Performance Tunning
Integration and working with multiple sources/ different datasets
Expertise in using Nested, Sub and inner Queries and its appropriate usage. Experience in handling errors and fixing the SQL issues For an ideal candidate in Healthcare Domain: (Average to above average).
Healthcare domain is negotiable, someone might have other domain experience. Irrespective of the domain, candidate need to be proficient with their respective domain For an ideal candidate in Data-warehousing Skills: (Average to above average).
Understands Star Schema, Snowflake, Data warehousing methodologies like Bill Inmon and Ralph Kimball.
Good understanding on slowly changing dimensions (SCD's) and its types/usage.
Responsible for designing, building, and supporting the components of data warehouse, such as ETL processes, databases, reports, and reporting environments Expertise in creation of BRD, STM and solution design documents.

1. SQL skillset This has to be good
2. Data Warehousing experience (can be relaxed if #1 & #3 are good)
3. Healthcare domain knowledge (can be relaxed if #1 & #2 are good)
Candidate should be good in the following concepts of SQL and able to apply this knowledge. A good understanding of the first 5 is a must.
1. Joins
2. Group by
3. Having clause
4. Select - case when
5. Sub Query
6. Window functions
7. Set Operations
8. Cast & Date Functions
Since this is an analyst position, along with technical skillsets, its important that the candidate is able to clearly explain the functional aspects of his work, this is applicable irrespective of whether the candidate has healthcare experience or not.