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
· 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.
· Perform Data validation and testing to certify data
· Manage changing priorities during the software development lifecycle (SDLC)
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.
Novartis
Pennylane
The Back Room Outsourced Professionals
AssistRx
Addepar