Senior Data Analyst - Data Engineering / Modeling at Exusia | Torre

Senior Data Analyst - Data Engineering / Modeling

Emma highlights
This highlight was written by Emma’s AI. Ask Emma to edit it.
Full-time

Legal agreement: Employment

Provide your expected compensation while applying
location_on
Remote (for India residents)
Shared by
Emma of Torre.ai
6 months ago

Responsibilities


DescriptionDepartment:                             Client Delivery Team - EmpowerIndustry:                                Information Technology & Services, Computer Software, Management ConsultingLocation:                              Pune/Bangalore/Hyderabad/Remote (Anywhere in India)Experience Range:                        5+ yearsBasic Qualification:                    Master/Bachelor of Engineering or EquivalentTravel Requirements:           Not requiredWebsite:                           www.exusia.comWhat’s the Role?Full-time job to work with Exusia's global (Americas, Europe, Africa, Asia) clients to deliver on bleeding-edge data-driven solutions by performing business and data analysis, data modelling, 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 5 years of experience working as a Data Analyst and Data ModelerMaster 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 modelling experience is mandatory preferably for DWH/Data martsSelf-motivated and proactive in a fast-paced environment.Excellent communication, creative problem solver, flexible, proactive, attitude to learn newer tools/technologiesResponsibilitiesOwn and Lead Data Analysis and data modeling activitiesDiscuss & 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 modelsData profiling and cleaning data for data analysis. Interpret data, analyze results, prepare data analysis reports.Perform Data validation and testing to certify dataCollect, analyze and disseminate significant amounts of information to project team & business stakeholders.Manage changing priorities during the software development lifecycle (SDLC)RequirementsMandatory SkillsAble to create Logical and Conceptual data models for business and functional usersUnderstanding of ER and Dimensional modeling techniques like Star, Snowflake or ConstellationHands on experience in implementing Star Schema and Relational (Normalized including 3NF) models is mandatoryShould have implemented physical data models for a variety of RDBMS and cloud hosted databasesStrong understanding of different types of facts and dimensionsHands 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 profilingTransforming business/functional requirements into technical specifications.Capturing data mapping / data transformation and business rules logic using source to target mapping templatesHands-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 methodsNice to have skillsExposure to scrum master or product owner role will be desirableKnowledge of data processing / ETL using Ab Initio / SAS / SSIS / Python / Scala / Apache Spark / DatabricksExposure to one or more Cloud platforms – Amazon Web Services (AWS), Microsoft Azure, Google Cloud PlatformExposure to Data Governance projects including Metadata Management, Data Dictionary, Data Glossary, Data Lineage and Data Quality aspects.Experience and knowledge of one or more domains – Banking or Healthcare