Data Modeler Analyst Healthcare

unlimited holidays - extra parental leave
Work set-up: 
Full Remote
Contract: 
Salary: 
104 - 104K yearly
Experience: 
Senior (5-10 years)
Work from: 

Offer summary

Qualifications:

Minimum 8 years of experience as a Data Analyst and Data Modeler., Bachelor's or Master's degree in Engineering, Computer Science, or related fields., Proficiency in SQL and experience with data modeling, especially for data warehouses or data marts., Experience working in an agile environment and knowledge of healthcare data is preferred..

Key responsibilities:

  • Lead data analysis and data modeling activities, including data profiling and validation.
  • Collaborate with cross-functional teams to gather and document data requirements.
  • Translate business requirements into technical specifications and data models.
  • Manage data analysis projects and adapt to changing priorities during the SDLC.

Exusia logo
Exusia SME http://www.exusia.com/
201 - 500 Employees
See all jobs

Job description

Description

Department: Client Delivery Team Empower

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

Location: ChicagoNew JerseyRemote (Anywhere in United States)

Experience Range: 8 + years

Basic Qualification: MasterBachelor of Engineering or Equivalent

Travel Requirements: Not required

Website: www.exusia.com

What’s the Role?

Fulltime job to work with Exusias clients in the United States to deliver on bleedingedge datadriven 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 DesignersDevelopers.


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 DWHData marts

· Selfmotivated and proactive in a fastpaced environment.

· Excellent communication, creative problem solver, flexible, proactive, attitude to learn newer toolstechnologies


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, sourcetotarget 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 businessfunctional requirements into technical specifications.

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

· Handson exposure to SQL and NoSQL databases and able to write pseudocode for ETL requirements.

· Data validation and testing using SQL or any toolbased 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.


Required profile

Experience

Level of experience: Senior (5-10 years)
Spoken language(s):
English
Check out the description to know which languages are mandatory.

Other Skills

  • Proactivity
  • Self-Motivation
  • Communication
  • Problem Solving

Data Insight Analyst Related jobs