Data Modeler / Analyst - Healthcare

2 Weeks ago • 8 Years + • Data Analyst

Job Summary

Job Description

This full-time Data Modeler/Analyst role at Exusia involves working with clients to create data-driven solutions. Responsibilities include data analysis, modeling, mapping, translating functional requirements into technical specifications, and collaborating with cross-functional teams. The role requires proficiency in SQL, experience with data warehousing (DWH/Data marts), and agile methodologies. Candidates should be able to create logical and conceptual data models, implement star schema and relational models, and have experience with data modeling tools like Erwin or ER Studio. The ideal candidate will have a strong understanding of facts and dimensions, and experience with various RDBMS and cloud-hosted databases. Healthcare domain knowledge is a plus.
Must have:
  • 8+ years Senior Data Analyst/Data Modeler experience
  • Proficient in complex SQL
  • DWH/Data mart experience
  • Agile methodology experience
  • Logical & Conceptual data modeling
  • Star Schema & Relational model implementation
  • Data modeling tools (Erwin, ER Studio etc.)
Good to have:
  • Snowflake experience
  • Scrum Master/Product Owner experience
  • ETL using Snowflake/DBT/Python
  • Cloud platform experience (AWS, Azure, GCP)
  • Data Governance project experience
  • Healthcare domain knowledge

Job Details

Description

Department:                           Client Delivery Team - Empower

Industry:                                  Information Technology & Services, Computer Software, Management Consulting

Location:                                 Chicago/New Jersey/Remote (Anywhere in United States)

Experience Range:                 8 + years

Basic Qualification:               Master/Bachelor of Engineering or Equivalent

Travel Requirements:           Not required

Website:                                  www.exusia.com

 

What’s the Role?

Full-time job to work with Exusia's clients in the United States to deliver on bleeding-edge data-driven solutions by performing business and data analysis, data modeling, data mapping and translating functional requirements into technical specifications.

Work with Client Product Owners & Business SMEs, Exusia Solution Architects and Senior Application Designers/Developers.


Criteria for the Role!

·      Have a minimum of 8 years of experience working as a Senior Data Analyst and Data Modeler. Must be hands on with the ability to write complex SQL.

·      Master of Science (preferably in Computer and Information Sciences or Business Information Technology) or an Engineering degree in the above areas.

·      Experience working in an agile software delivery model is required.

·      Prior data modeling experience is mandatory preferably for DWH/Data marts

·      Self-motivated and proactive in a fast-paced environment.

·      Excellent communication, creative problem solver, flexible, proactive, attitude to learn newer tools/technologies


Responsibilities

·      Own and Lead Data Analysis and data modeling activities, previous experience and certification with Snowflake preferred.

·      Discuss & document data and analytics requirements with cross functional teams and business stakeholders.

·      Analyze requirements and come up with technical specifications, source-to-target mapping, data and data models

·      Data profiling and cleaning data for data analysis. Interpret data, analyze results, prepare data analysis reports.

·      Perform Data validation and testing to certify data

·      Collect, analyze and disseminate significant amounts of information to project team & business stakeholders.

·      Manage changing priorities during the software development lifecycle (SDLC)

Requirements

Mandatory Skills

·        Able to create Logical and Conceptual data models for business and functional users

·        Understanding of ER and Dimensional modeling techniques like Star, Snowflake or Constellation

·        Hands on experience in implementing Star Schema and Relational (Normalized including 3NF) models is mandatory

·        Should have implemented physical data models for a variety of RDBMS and cloud hosted databases

·        Strong understanding of different types of facts and dimensions

·        Hands on experience with data modeling tools like Erwin, ER Studio, InfoSphere Data Architect (IDA)

·        Strong SQL or python skills for carrying out data analysis and data profiling

·        Transforming business/functional requirements into technical specifications.

·        Capturing data mapping / data transformation and business rules logic using source to target mapping templates

·        Hands-on exposure to SQL and NoSQL databases and able to write pseudo-code for ETL requirements.

·        Data validation and testing using SQL or any tool-based testing methods

 

Nice to have skills

·        Exposure to scrum master or product owner role will be desirable

·        Knowledge of data processing / ETL using Snowflake / DBT / Python / Scala / Apache Spark / Databricks

·        Exposure to one or more Cloud platforms – Amazon Web Services (AWS), Microsoft Azure, Google Cloud Platform

·        Exposure to Data Governance projects including Metadata Management, Data Dictionary, Data Glossary, Data Lineage and Data Quality aspects.

·     Experience and knowledge of Healthcare domain preferred – knowledge of healthcare data and data models required. Knowledge of Claims (Medical and Pharmacy), EMRs, EHR required.

Similar Jobs

Netflix - Data Engineer (L4) - Security

Netflix

Los Gatos, California, United States (Hybrid)
1 Week ago
The Walt Disney Company - Sr Machine Learning Engineer

The Walt Disney Company

Seattle, Washington, United States (On-Site)
5 Months ago
PwC - Director Cybersecurity - Financial Sector (Dutch)

PwC

Amsterdam, North Holland, Netherlands (On-Site)
6 Months ago
N-iX - Senior Frontend Engineer

N-iX

Ukraine (Remote)
1 Week ago
Meta - Data Engineer, Product Analytics

Meta

Menlo Park, California, United States (On-Site)
5 Months ago
WebMD - Lead, Data Engineering

WebMD

Newark, New Jersey, United States (On-Site)
5 Months ago
Canva - Senior Accessibility Compliance Analyst

Canva

Melbourne, Victoria, Australia (Remote)
4 Weeks ago
NVIDIA - Technical Marketing Manager - Data Analytics Specialist

NVIDIA

Santa Clara, California, United States (On-Site)
3 Weeks ago
Scopely - Senior Data Analyst, Marketing Analytics

Scopely

Mexico City, Mexico City, Mexico (Hybrid)
2 Months ago
ION - Data Scientist

ION

Noida, Uttar Pradesh, India (On-Site)
6 Months ago

Get notifed when new similar jobs are uploaded

Similar Skill Jobs

ION - Lead Java Developer, New York

ION

New York, New York, United States (Hybrid)
6 Months ago
Netflix - Data Engineer (L4) - Security

Netflix

United States (Hybrid)
2 Months ago
Ness Digital - Senior BI Developer

Ness Digital

Iași, Iași County, Romania (Remote)
1 Month ago
DraftKings - Senior Software Engineer – Streaming & Real-Time Systems

DraftKings

Sofia, Sofia City Province, Bulgaria (On-Site)
1 Month ago
Resolver, a Kroll Business - Performance Test Engineer

Resolver, a Kroll Business

Hyderabad, Telangana, India (On-Site)
6 Months ago
Gaming Innovation Group  - Associate Big Data Engineer

Gaming Innovation Group

Manchester, England, United Kingdom (Hybrid)
2 Weeks ago
ByteDance - Senior Software Developer, Routing Verification & Emulation

ByteDance

San Jose, California, United States (On-Site)
1 Month ago
Trendyol - Backend Developer

Trendyol

Ankara, Ankara, Türkiye (Hybrid)
6 Months ago
The Walt Disney Company - Senior Data Engineer

The Walt Disney Company

Seattle, Washington, United States (On-Site)
1 Week ago
Netflix - Distributed Systems Engineer, Membership Engineering (L4)

Netflix

Los Gatos, California, United States (On-Site)
1 Week ago

Get notifed when new similar jobs are uploaded

Jobs in United States

Overwolf - Full Stack Developer - Nitro

Overwolf

Chicago, Illinois, United States (On-Site)
2 Weeks ago
Google - Senior Technical Program Manager II, Google Networking Technologies

Google

Atlanta, Georgia, United States (On-Site)
1 Week ago
Meta - Software Engineer, iOS

Meta

Burlingame, California, United States (On-Site)
5 Months ago
Activision - Senior Manager, Accounting

Activision

Los Angeles, California, United States (On-Site)
3 Months ago
Lionbridge Games - Business Development Director, Games

Lionbridge Games

United States (On-Site)
2 Months ago
NVIDIA - Senior Costing Analyst

NVIDIA

Santa Clara, California, United States (On-Site)
1 Week ago
Rockstar Games - Marketing Manager, Live Services

Rockstar Games

New York, New York, United States (On-Site)
4 Months ago
ByteDance - Student Researcher (Doubao (Seed) - Generative AI)

ByteDance

San Jose, California, United States (Hybrid)
1 Week ago
ByteDance - Software Engineer Intern (Privacy & Security - Global Payment)

ByteDance

San Jose, California, United States (On-Site)
1 Month ago
Next Level Business Services - SAP RMCA Functional Consultant

Next Level Business Services

Sunnyvale, California, United States (On-Site)
5 Months ago

Get notifed when new similar jobs are uploaded

Data Analyst Jobs

Ness Digital - Big Data Engineer

Ness Digital

Timișoara, Timiș, Romania (Remote)
1 Month ago
ION - Debt Restructuring Analyst

ION

Mumbai, Maharashtra, India (On-Site)
6 Months ago
ByteDance - Data Analyst - BytePlus Recommend

ByteDance

Singapore (On-Site)
1 Week ago
Supercell - Data Engineer, Marketing Data

Supercell

Helsinki, Uusimaa, Finland (On-Site)
6 Months ago
HP - Data Engineer

HP

Athens, Greece (On-Site)
2 Weeks ago
UXBERT Labs - Senior Data Analyst

UXBERT Labs

Riyadh, Riyadh Province, Saudi Arabia (Hybrid)
3 Months ago
Activision - Game Security Analyst

Activision

Los Angeles, California, United States (Hybrid)
6 Days ago
Wildlife Studios - Business Intelligence Analyst

Wildlife Studios

São Paulo, State Of São Paulo, Brazil (On-Site)
6 Months ago
GoTo Group - Senior Data Analyst - Driver Risk

GoTo Group

Jakarta, Jakarta, Indonesia (On-Site)
4 Months ago
ION - DCM Data Analyst - 1018

ION

Mumbai, Maharashtra, India (On-Site)
6 Months ago

Get notifed when new similar jobs are uploaded

About The Company

Hyderabad, Telangana, India (Remote)

United States (Remote)

Hyderabad, Telangana, India (Remote)

Hyderabad, Telangana, India (Remote)

Hyderabad, Telangana, India (Remote)

Hyderabad, Telangana, India (Remote)

View All Jobs

Get notified when new jobs are added by EXUSIA

Level Up Your Career in Game Development!

Transform Your Passion into Profession with Our Comprehensive Courses for Aspiring Game Developers.

Job Common Plug