-
IT Data Warehousing Analyst
2 weeks ago
HCTec Troy, United StatesPosition: Data Warehousing Analyst · Length: 6 months with possible conversion at the end · Location: Troy, MI · Onsite/Remote: Remote, prefer local candidate but open to out of the area candidates · Covid Vaccination: Optional · Job Scope/Summary: · Bachelor's Degree, Minimum of ...
-
IT Data Warehousing Analyst
3 weeks ago
Strategic Staffing Solutions Troy, United StatesSTRATEGIC STAFFING SOLUTIONS (S3) HAS AN OPENING · Title: IT Data Warehousing Analyst · Duration: 12+ Months · Location: Troy, MI (Remote in Michigan) · Job/Role Description This individual will serve as a critical resource in the day-to-day development and maintenance of the ...
-
IT Data Warehousing Analyst
3 weeks ago
Integrated Resources Troy, United StatesDuties: · PRINCIPLE DUTIES AND RESPONSIBILITIES: · Collects, analyzes and summarizes data to support business decisions. · Identifies opportunities for reuse of data across the enterprise. Validates data sources. · Keeps abreast of new Tools & Technology and functionalities acro ...
-
IT Data Warehousing Analyst
3 weeks ago
Strategic Staffing Solutions Troy, United StatesSTRATEGIC STAFFING SOLUTIONS (S3) HAS AN OPENING · Title: IT Data Warehousing Analyst · Duration: 12+ Months · Location: Troy, MI (Remote in Michigan) · Job/Role Description · • This individual will serve as a critical resource in the day-to-day development and maintenance of the ...
-
IT Data Warehousing Analyst
2 weeks ago
A-Line Staffing Solutions Troy, United StatesJob Description · Job DescriptionTitle: IT Data Warehousing Analyst · Location: Troy, MI (Role is currently Remote but may require Onsite availability in the future) · Note: This position is a contract on W2, and is NOT open to C2C · The IT Data Warehousing Analyst will be respon ...
-
IT Data Warehousing Analyst
1 week ago
Global Technology Associates Troy, United StatesJob Description · Job DescriptionIT Data Warehousing Analyst · Job ID: · Location: Troy, MI REMOTE POSITION) · Pay Rate: $42-$45/hour · Additional Benefits: Health, Dental, Vision, 401(k), company-paid holidays and more · Type of hire: 6-month contract to hire position. · Posit ...
-
IT Data Warehousing Analyst
1 week ago
Global Technology Associates Troy, United StatesIT Data Warehousing Analyst · Job ID: · Location: Troy, MI REMOTE POSITION) · Pay Rate: $42-$45/hour · Additional Benefits: Health, Dental, Vision, 401(k), company-paid holidays and more · Type of hire: 6-month contract to hire position. · Position Responsibilities :Collec ...
-
IT Data Warehousing Analyst
3 weeks ago
Select Source International Troy, United StatesJob Description · Job DescriptionTitle:- IT Data Warehousing Analyst · Duration:- 6+ Month · Location:- Remote Assignment · **REQUIRED: Bachelor's Degree, Minimum of 5 years applicable experience (3 years in healthcare setting preferred). · Proficient in usage of different ana ...
-
IT Data Warehousing Analyst
3 weeks ago
Techlink Systems Troy, United StatesJob Description · Job DescriptionJob Title: IT Data Warehousing Analyst · Location : Troy, MI (remote, local candidates preferred) · Contract Duration: Contract until 12/31/2024 with possible extension or conversion to Full-time · PRINCIPLE DUTIES AND RESPONSIBILITIES: · Collects ...
-
Sr. Datastage Developer
2 weeks ago
Abidi Solutions Troy, United StatesJob Description · Job DescriptionJob Title: Sr. Datastage Developer · Work Environment: Hybrid in Troy, MI · Contract Length: 4 Month Contract to Hire · Interview: ASAP 1st round teams, second round on-site · Enterprise Req Skills · Pl/sql,datastage · Top Skills Details · 1. Dat ...
-
AI Data Engineer
3 weeks ago
Hearst Troy, United StatesJob Description · MOTOR Information Systems, an operating group of Hearst, is actively seeking a team of enthusiastic, creative, and driven technologists. People with a proven track record, who are willing to experiment with new ideas, invest time in them, fail-fast, and move on ...
-
Senior WMS Techno-Functional Business Analyst
3 weeks ago
Cummins Troy, United StatesSenior WMS Techno-Functional Business Analyst · Description · Our culture believes in POWERING YOUR POTENTIAL . We provide global opportunities to develop your career, make your community a better place and work with today's most innovative thinkers to solve the world's toughest ...
-
Senior WMS Techno-Functional Business Analyst
17 hours ago
Cummins Troy, United StatesSenior WMS Techno-Functional Business Analyst · Description · Our culture believes in POWERING YOUR POTENTIAL . We provide global opportunities to develop your career, make your community a better place and work with todays most innovative thinkers to solve the worlds toughest ...
-
Senior Datastage Developer
1 week ago
Info Services Troy, United StatesRole: Sr. Datastage Developer - · Location: Troy, MI Hybrid role - 2 days onsite in Michigan · Long term contract · Job Type: W2 Only. · Top Skills' Details · 1. Datastage Development · 2. PL/SQL Development · 3. Data Warehousing experience · Secondary Skills - Nice to Haves · ...
-
Senior IT Business Analyst
4 weeks ago
Cummins Troy, United States Paid WorkSenior IT Business Analyst · Description · Our culture believes in POWERING YOUR POTENTIAL . We provide global opportunities to develop your career, make your community a better place and work with today's most innovative thinkers to solve the world's toughest problems. · We beli ...
-
Senior WMS Techno-Functional Business Analyst
3 weeks ago
Cummins Troy, United States**Senior WMS Techno-Functional Business Analyst** · **Description** · Our culture believes in _POWERING YOUR POTENTIAL_ . We provide global opportunities to develop your career, make your community a better place and work with todays most innovative thinkers to solve the worlds ...
-
Cummins Troy, United StatesSenior WMS Techno-Functional Business Analyst · Description · Our culture believes in POWERING YOUR POTENTIAL . We provide global opportunities to develop your career, make your community a better place and work with today's most innovative thinkers to solve the world's toughest ...
-
Senior IT Business Analyst
1 month ago
Cummins Inc. Troy, United States Paid WorkSenior IT Business Analyst · Description · Our culture believes in POWERING YOUR POTENTIAL . We provide global opportunities to develop your career, make your community a better place and work with today's most innovative thinkers to solve the world's toughest problems. · We beli ...
-
Senior WMS Techno-Functional Business Analyst
3 weeks ago
Hispanic Technology Executive Council Troy, United StatesOur culture believes in Powering Your Potential. We provide global opportunities to develop your career, make your community a better place and work with todays most innovative thinkers to solve the worlds toughest problems. · We believe in flexibility for you to explore your pa ...
-
Hispanic Technology Executive Council Troy, United StatesOur culture believes in Powering Your Potential. We provide global opportunities to develop your career, make your community a better place and work with todays most innovative thinkers to solve the worlds toughest problems. · We believe in flexibility for you to explore your pa ...
IT Data Warehousing Analyst - Troy, United States - InfiCare Technologies
Description
Job Description
Job DescriptionJob Title - IT Data Warehousing Analyst (Remote)Location - Troy, MI 48083Hourly 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 good2. 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.