Role Purpose

• 3+ years of strong experience with Data Transformation, Datawarehouse/Database creation & ETL on large data sets.
• 3+ years of Data Modelling experience (i.e. Relational, Dimensional, Columnar)
• 3+ years of complex SQL or NoSQL experience.
• Experience in advanced Data Warehouse concepts.
• Experience with Business Requirements definition and management, structured analysis, process design, use case documentation.
• Experience in professional software development capacity using SDLC, waterfall and Agile mode of development.
• Demonstrate exceptional organizational skills and ability to multi-task simultaneously with different parallel projects.
• Strong verbal & written communication skills to interface with business teams & lead towards successful business outcome.
• Must be self-managed, proactive and customer focused.
• Degree in Computer Science, Information Systems, Data Science or related field.

Good to have - Experience & knowledge with DBA activities in SQL Server 2008 R2, 2012, 2016, and 2017 as well as 2019 features along with any other cloud-based databases like Snowflake and Multidimensional databases

Stakeholder Interaction

Stakeholder Type

Stakeholder Identification

Purpose of Interaction

Internal

Team Leaders

Performance review

HR

Hiring and employee engagement and retention

Training Team

Capability development

Technical Lead

Training, issue escalation/ resolution

External

Client

Query Resolution

Display

Lists the competencies required to perform this role effectively:

• Functional Competencies/ Skill
  • Process Knowledge - Knowledge of assigned process, tools and systems - Foundation to Competent

Competency Levels

Foundation

Knowledgeable about the competency requirements. Demonstrates (in parts) frequently with minimal support and guidance.

Competent

Consistently demonstrates the full range of the competency without guidance. Extends the competency to difficult and unknown situations as well.

Expert

Applies the competency in all situations and is serves as a guide to others as well.

Master

Coaches others and builds organizational capability in the competency area. Serves as a key resource for that competency and is recognized within the entire organization.

• Behavioral Competencies
  • Collaborative working
  • Problem solving and decision making
  • Attention to Detail
  • Execution Excellence
  • Client (Internal) Centricity
  • Effective Communication

Deliver

No.

Performance Parameter

Measure

1.

Process

No. of cases resolved per day, compliance to process and quality standards, meeting process level SLAs, Pulse score, Customer feedback

2.

Self- Management

Productivity, efficiency, absenteeism, Training Hours, No of technical training completed

Data Analyst, Data Visualization (Tableau, Power BI), Data Modelling, Data Warehousing, SQL and Advance SQL