Senior Technical Specialist
Technology, Data & Digital · Data, AI & Analytics · Data Engineering · Business Intelligence · Data Analysis
In short
Senior Technical Specialist needed in Bangalore, Karnataka, India, for data modeling and Business Intelligence solutions. Responsibilities include engaging with users to understand information needs, developing logical and physical data models, and collaborating with BI teams to optimize performance and maintain metadata.
Responsibilities
- Engage business users to assess their information needs.
- Review business processes and conceptualize entities.
- Develop entity relationship diagrams.
- Develop a logical data model and validate it.
- Transform As-Is non-dimensional modeling layer to scaled dimensional model.
- Transform the logical representation of the model into a physical representation.
- Collaborate with BI and Analytics teams.
- Optimize the model for predictable performance.
- Maintain the metadata.
- Recommend and establish standards, guidelines, and procedures for design and maintenance.
- Architect, design, and develop solutions.
- Support as a Subject Matter Expert.
- Ensure knowledge up-gradation and work with new technologies.
- Ensure a sufficient pool of skilled professionals.
- Gather specifications and deliver solutions to the client organization.
- Support competency development with envisioning and articulating propositions.
- Recommend client value creation initiatives and implement industry best practices.
Requirements
- Proficient in industry standard techniques for data modeling.
- Proficient in 3rd normal form relational modeling.
- Proven experience in an enterprise environment developing relational databases.
- Proven experience developing models for Business Intelligence solutions.
- Strong analytical, data profiling and problem-solving skills.
- Strong verbal and written communication skills.
- Advanced SQL skills.
- In-depth knowledge of modeling methodologies and techniques.
- In-depth knowledge of facilitation and conflict resolution processes.
- Excellent teaming and communication skills.
- Strong consultative, facilitation and consensus building skills.
Desired Qualifications
- Dimensional modeling experience would be a strong added value for online analytical processing.
- Experience with Business Intelligence products.
#Data Modeler#Data Mart developer#Data Modeling#Dimensional Modeling#Business Intelligence