Jobs
>
Troy

    IT Data Warehousing Analyst - Troy, United States - Select Source International

    Default job background
    Description

    Job Description

    Job Description

    Title:

    • 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 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. Contract to hire position Remote for now, will eventually work from the HAP office in Troy


    • 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 function.

    Company DescriptionSelect Source International (SSI) is an IT, Health Care, and Engineering Services consulting firm that has been in business since 1998.

    SSI consultants have provided exceptional services that have been appreciated by clients, customers, and users alike at several large Fortune 500 companies, mid-size enterprises, and consulting companies.

    Company Description

    Select Source International (SSI) is an IT, Health Care, and Engineering Services consulting firm that has been in business since 1998.

    SSI consultants have provided exceptional services that have been appreciated by clients, customers, and users alike at several large Fortune 500 companies, mid-size enterprises, and consulting companies.



  • HCTec Troy, United States

    Position: 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 ...


  • Strategic Staffing Solutions Troy, United States

    STRATEGIC 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 ...


  • Integrated Resources Troy, United States

    Duties: · 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 ...


  • Strategic Staffing Solutions Troy, United States

    STRATEGIC 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 ...


  • A-Line Staffing Solutions Troy, United States

    Job 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 ...


  • Global Technology Associates Troy, United States

    IT 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 ...


  • Global Technology Associates Troy, United States

    Job 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 ...


  • InfiCare Technologies Troy, United States

    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/dayNOTE: Remote for now, will eventually work from the HAP office in Troy Will be using Datasta ...


  • Techlink Systems Troy, United States

    Job 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 ...


  • Abidi Solutions Troy, United States

    Job 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 ...

  • Hearst

    AI Data Engineer

    3 weeks ago


    Hearst Troy, United States

    Job 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 ...


  • 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 today's most innovative thinkers to solve the world's toughest ...


  • 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 toughest ...


  • Info Services Troy, United States

    Role: 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 · ...


  • Cummins Troy, United States Paid Work

    Senior 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 ...


  • 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 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 today's most innovative thinkers to solve the world's toughest ...


  • Cummins Inc. Troy, United States Paid Work

    Senior 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 ...


  • Hispanic Technology Executive Council Troy, United States

    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 problems. · We believe in flexibility for you to explore your pa ...


  • Hispanic Technology Executive Council Troy, United States

    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 problems. · We believe in flexibility for you to explore your pa ...