It Data Warehousing Analyst

Position:- IT Data Warehousing Analyst Remote Candidate should be local to MI
Duration: Contract to hire. JD:
Bachelor&#XX;s Degree, Minimum of X years applicable experience (X years in healthcare setting preferred) 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).
For an ideal candidate in Data-warehousing Skills:
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 X. Data Warehousing experience 3. Healthcare domain knowledge Candidate should be good in the following concepts of SQL and able to apply this knowledge.
A good understanding of the first X is a must.
1. Joins
2. Group by
3. Having clause
X. Select - case when
X. Sub Query X. Window functions
X. Set Operations
X. 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.