Data Modeler​/Analyst - Healthcare

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:

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.

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

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

• 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, Info Sphere 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 No
  
  SQL databases and able to write pseudo‑code for ETL requirements.
• Data validation and testing using SQL or any tool‑based testing methods.

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