Data vault

We are hiring a Data vault

Experience: 5+

Location: Hyd, blr,Chennai, pune, mumbai, Gurgaon, Noida

Notice Period: Immediate to 15 Day

Your key responsibilities

Be responsible for the development of the conceptual, logical, and physical data models, the

implementation of RDBMS, operational data store (ODS),

data marts, and data lakes on target platforms (SQL/NoSQL).

Work as a Senior team member to contribute in various technical streams EY DNA implementation project.

To oversee and govern the expansion of existing data architecture and the optimization of data query performance via best practices.

Should be able to work independently and collaboratively.

Implement business and IT data requirements through new data strategies and designs across all data platforms (relational, dimensional, and NoSQL).

Work with business and application/solution teams to implement data strategies, build data flows, and develop conceptual/logical/physical data models

Define and govern data modelling and design standards, tools, best practices, and related development for enterprise data models.

Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated dataloads, security concerns, analytic models, and data visualization.

Hands-on modelling, design, configuration, installation, performance tuning, and sandbox POC.

Work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks.

Skills and attributes for success

Use an issue-based approach to deliver growth, market and portfolio strategy engagements for corporates

Strong communication, presentation and team building skills and experience in producing high quality reports, papers, and presentations.

Experience in executing and managing research and analysis of companies and markets, preferably from a commercial due diligence standpoint

To qualify for the role, you must have:

BE/BTech/MCA/MBA with 5-9 years of industry experience with machine learning, visualization, data

science and related offerings.

At least around 6+ years of experience in BI and Analytics.

To be have ability to do end to end data solutions from analysis, mapping, profiling, ETL architecture and data modelling.

Knowledge and experience of at least 1 Insurance domain engagement Life & Annuity or Property & Casualty.

Understanding of Business Intelligence, Data Warehousing and Data Modelling.

Good experience using CA Erwin or other similar modelling tool is absolute must.

Strong knowledge of data vault 2.0 implementation knowledge

Work experience in Data Vault 2.0 Modelling

Develop logical and physical data flow models for ETL applications.

Translate data access, transformation and movement requirements into functional requirements and mapping designs.

Strong knowledge of data architecture, database structure, data analysis and SQL skills

Experience in data management analysis. Analyse business objectives and evaluate data solutions to meet customer needs.

Establishing scalable, efficient, automated processes for large scale data analyses and management

Prepare and analyse historical data and identify patterns

To collaborate with technology team and support the development of analytical models with the effective use of data and analytic techniques.

To validate the model results and articulate the insights to the business team.

Drive the Business requirements gathering for analytics projects

Intellectual curiosity - eagerness to learn new things

Experience with unstructured data is added advantage

Ability to effectively visualize and communicate analysis results

Experience with big data and cloud preferred

Experience, interest and adaptability to working in an Agile delivery environment.

Ability to work in a fast-paced environment where change is a constant and ability to handle ambiguous requirements

Exceptional interpersonal and communication skills (written and verbal)

Ideally, youll also have

Good exposure to any ETL tools.

Good to have knowledge about L&A Insurance.

Understanding of Business Intelligence, Data Warehousing and Data Modelling.

Must have led a team size of at least 4 members.

Experience in Insurance and Banking domain

Prior Client facing skills, Self-motivated and collaborative