Data Warehouse Analyst

2 weeks ago


Little Ferry, New Jersey, United States Dice Full time
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Select Source International, is seeking the following. Apply via Dice today

Job Description:

Job Title:
IT Data

Location:
Remote Role (Troy, Michigan)

Duration: 6 Months (C2H)

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

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 across the application(s).
Works closely with customers, vendors, business analysts and application development project teams to resolve information flow and content issues.
Ensure data integrity and compliance by performing data profiling and data validations.
Facilitates meetings with clients to gather and document requirements and explore potential solutions.
Gathers data and reporting requirements.

Detects and summarizes patterns in data and findings by producing simple reports and works with development teams for problem resolutions.

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 Will be using Datastage/Cognos/PowerBI
Conversion Salary will be largely based on performance and number of years of relevant experience.

Specifics:
SQL skillset This has to be good
Data Warehousing experience (can be relaxed if #1 & #3 are good)
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.

Joins
Group by
Having clause
Select - case when
Sub Query
Window functions
Set Operations
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.

Data Warehouse Analyst
#J-18808-Ljbffr
  • HR Data Analyst

    2 weeks ago


    Little Ferry, New Jersey, United States Dice Full time

    Dice is the leading career destination for tech experts at every stage of their careers. Our client, SGS Consulting, is seeking the following. Apply via Dice today Responsibilities:Be adept at sourcing data and executing reporting deliverables in accordance with detailed local, national and international regulationsUse tools and programming languages like...


  • Little Ferry, New Jersey, United States Ambry Genetics Full time

    A company is looking for a Principal Data Architect. Key Responsibilities:Lead and manage a team of data engineers, database administrators, and data analysts Develop and implement real-time data streaming solutions Establish data governance policies and standards for data management Required Qualifications:Bachelor's or master's degree in computer science...

  • Business Analyst

    2 weeks ago


    Little Ferry, New Jersey, United States Dice Full time

    Dice is the leading career destination for tech experts at every stage of their careers. Our client, Kforce Technology Staffing, is seeking the following. Apply via Dice todayRESPONSIBILITIES:Kforce's client in NYC is seeking an experienced Business Analyst to join their team on a contract basis Summary:The ideal candidate will understand complex business...

  • Lead Data Engineer

    2 weeks ago


    Little Ferry, New Jersey, United States Cryptorecruit Full time

    Company We are looking for a Lead Data Engineer who is passionate about learning new technologies and enjoys building enterprise-level data warehouses and data platforms.Are you an experienced Data Engineer who loves to collaborate across the enterprise with strong cross-functional planning and prioritisation skills? Do you have a passion for evolving...


  • Little Ferry, New Jersey, United States Litera Corp. Full time

    Job Description Company Overview: At Litera, we leverage the power of data to drive innovation and business growth. We are looking for a visionary Director of Data Engineering to lead our data engineering efforts within a robust Azure and Power BI ecosystem. Our ideal candidate thrives in a fast-paced environment, is passionate about building...

  • Underpayments Analyst

    2 weeks ago


    Little Ferry, New Jersey, United States R1 RCM Full time

    A company is looking for a Revenue Cycle Analyst Underpayments. Key Responsibilities:Research hospital accounts for additional revenue opportunities Evaluate reimbursement calculations and pursue underpayment resolutions with payers Document accounts and diagnose root causes of underpayments Required Qualifications:Bachelor's degree or 2+ years' experience...


  • Little Ferry, New Jersey, United States ConcertAI Full time

    Job Requirements Company Overview ConcertAIs mission is to accelerate insights, advance research, and improve patient outcomes in oncology and across life sciences. ConcertAIs leading real-world evidence, AI technology and software-as-a-service solutions support healthcare decision-making across clinical research & development through commercialization....


  • Little Ferry, New Jersey, United States Ensemble Health Partners Full time

    Thank you for considering a career at Ensemble Health Partners Ensemble Health Partners is a leading provider of technology-enabled revenue cycle management solutions for health systems, including hospitals and affiliated physician groups. They offer end-to-end revenue cycle solutions as well as a comprehensive suite of point solutions to clients across the...

  • Business Analyst

    2 weeks ago


    Little Ferry, New Jersey, United States Stride Full time

    Meet StrideSuccess StoriesResponsibility and Inclusion Over 20 years ago, Stride was founded to provide personalized learning — powered by technology. We reached students where they were in their own journeys. We knocked down their barriers to great education. And we gave every learner equal opportunity to succeed — however they defined success. Stride...

  • Business Analyst

    2 weeks ago


    Little Ferry, New Jersey, United States Talentify Full time

    Employer Industry: Telecommunications Why Consider This Job Opportunity Excellent medical, dental, vision, and life insurance policy optionsOpportunities for career advancement with an industry leading companyProfessional development, training, and tuition reimbursement programsFlexible time off policy401K Company match (up to 4% - dollar for dollar) What To...


  • Little Ferry, New Jersey, United States MPG II, LLC Full time

    ABOUT MPGMarket Performance Group, LLC (MPG) is an innovative consulting and sales management services company that specializes in helping manufacturers and retailers define a better path forward to accelerate growth and profitability. We are an experience-based team that revels in the opportunity to collaborate with our clients - from large multinational...

  • Staff Product Manager

    2 weeks ago


    Little Ferry, New Jersey, United States Materialize Full time

    Who We Are:Materialize is an operational data warehouse. It's the same SQL, same workflows, same architecture as an analytical data warehouse, but with a continuous computation model instead of batch. Your data is always up to date, always consistent, and always immediately accessible, so you can build real-time automation, engaging customer experiences, and...


  • Little Ferry, New Jersey, United States Calix Full time

    This is a remote position that could be based anywhere in the United States. Calix is leading a service provider transformation to deliver a differentiated subscriber experience around the Smart Home and Business, while monetizing their network using Role based Cloud Services, Telemetry, Analytics, Automation, and the deployment of Software Driven Adaptive...


  • Little Ferry, New Jersey, United States Talentify Full time

    Employer Industry: Market Research Why Consider This Job Opportunity Competitive pay up to $95K/yearOpportunity for career advancement and growth within the organizationExpertise in financial analysis and modelingWork remotely or in Austin, TX or Shelton, CTCollaborative team environmentComprehensive benefits package What To Expect (Job Responsibilities)...


  • Little Ferry, New Jersey, United States Talentify Full time

    Employer Industry: Financial Services Why Consider This Job Opportunity Salary up to the Low $100's plus bonusExcellent benefits packageGenerous PTO programOpportunity for growth and advancement within the organizationRemote/hybrid work environmentRapidly growing company with ample room for career progression What To Expect (Job Responsibilities) Contribute...


  • Little Ferry, New Jersey, United States DATAMAXIS Full time

    Location: Northern VA (Remote) Rate: Depending on experience. Work Authorization: USC or GC **Qualifications: 1. bachelor's degree in computer science, Information Technology, Finance, or a related field. 2. 5+ years of experience as an Oracle Fusion Financials Integration Developer or similar role. Strong understanding of Oracle Fusion Financials modules,...


  • Little Ferry, New Jersey, United States Global Channel Management Full time

    Report Developer Programmer needs 5+ years of reporting development and/or programming experience required Report Developer Programmer requires: BA or BS in a STEM (Science, Technology, Engineering or Math) or related field or equivalent work experience required. Equivalent years of experience are determined as one year of technical experience for every...


  • Little Ferry, New Jersey, United States Talentify Full time

    Employer Industry: Respiratory Diagnostics Why Consider This Job Opportunity Opportunity for career advancement and growth within the organization Competitive salary and benefits package Remote work flexibility available Collaborative and diverse work environment Chance to make a significant impact on business performance What To Expect (Job...

  • Account Manager

    2 weeks ago


    Little Ferry, New Jersey, United States Circana Full time

    Let's be unstoppable together Circana (formerly IRI and NPD) is the leading advisor on the complexity of consumer behavior. Through unparalleled technology, advanced analytics, cross-industry data and deep expertise, we provide clarity that helps almost 7,000 of the world's leading brands and retailers take action and unlock business growth. At Circana, we...


  • Little Ferry, New Jersey, United States Persefoni Full time

    Click the 'Apply' button to learn more about Persefoni and the role. Then, you can choose to apply directly with Persefoni or use AI to assist your application powered by Offered.Customer Success ManagerCompany IntroductionOur mission is to enable every organization to be climate conscious and positive with the world's best climate software and data...