Remote Jobs
Overview
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
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.
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 - 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.
#J-18808-Ljbffr
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
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.
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 - 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.
#J-18808-Ljbffr