Jobs
>
Troy

    IT Data Warehousing Analyst - Troy, United States - InfiCare Technologies

    Default job background
    Description

    Job Description

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



  • 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

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


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


  • Select Source International Troy, United States

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


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