Job Purpose:
To lead and own the Data platform for a Business vertical
Experience
With overall experience between 10 - 15 years, applicant must have minimum 7 years of hard core professional experience in data modeling for large Data Warehouse with multiple Sources.
Technical Skills
- Expertise in core skill of data modeling principles/methods including conceptual, logical & physical Data Models
- Ability to utilize BI tools like Power BI, Tableau, etc to represent insights
- Expert knowledge of metadata management, data modeling tools like ER Studio, Erwin or others.
- Hands-on experience in relational, dimensional and/or analytical modelling (using RDBMS, dimensional, NoSQL, ETL and data ingestion protocols).
- Good to have knowledge of -
- Azure powershell scripting or Python scripting for data transformation in ADF
- SSIS, SSAS, BI tools like Power BI
- Azure PaaS components like Azure Data Factory, Azure Data Bricks, Azure
- Data Lake, Azure Synapse (DWH), Polybase, ExpressRoute tunneling, etc.
- API integration
Responsibility
- Front face with business representatives to understand the data office requirements
- Understanding the business requirement, .translate them into data requirement, articulate the requirement to the ta engineers, build the data models for business consumption.
- Work with development team to implement the proposed data model into physical data model, build data flows
- Work with development team to optimize the database structure with best practices applying optimization methods.
- Analyze, document and implement to re-use of data model for new initiatives.
- Will interact with stakeholder, Users, other IT teams to understand the eco system and analyze for solutions
Qualifications
- Bachelors of Computer Science or Equivalent
- Should have certification done on Data Modeling and Data Analyst.
- Good to have a certification of Azure Fundamental and Azure Engineer courses (AZ900 or DP200/201)
Behavioral Competencies
- Should have excellent problem-solving and time management skills
- Strong analytical thinking skills
- Applicant should have excellent communication skill and process oriented with flexible execution mindset.
- Strategic Thinking with Research and Development mindset.
- Clear and demonstrative communication
- Efficiently identify and solves issues
- Identify, track and escalate risks in a timely manner