Master Data Modeler

Experience: 5 to 7 years
Location: Bengaluru, Gurgaon, Pune
Job code: 101111
Posted on: Jan 23, 2025

About Us:
AceNet Consulting is a fast-growing global business and technology consulting firm specializing in business strategy, digital transformation, technology consulting, product development, start-up advisory and fund-raising services to our global clients across banking & financial services, healthcare, supply chain & logistics, consumer retail, manufacturing, eGovernance and other industry sectors.
We are looking for hungry, highly skilled and motivated individuals to join our dynamic team. If you’re passionate about technology and thrive in a fast-paced environment, we want to hear from you.

Job Summary :
We are seeking a highly skilled candidate who will assist in physicalizing data models, focusing on the creation of mapping tables to harmonize data from various sources. This role emphasizes hands-on experience in SQL, Stored Procedures and Python/PySpark with a strong focus on handling master data.

Key Responsibilities :
1. Data Modeling and Design
*Develop and maintain conceptual, logical, and physical data models to meet business and technical requirements.
*Define data entities, attributes, relationships, and hierarchies to support master data management (MDM) and enterprise data strategies.
*Optimize data models for performance, scalability, and reusability across applications and systems.
*Implement data modeling standards, tools, and methodologies.

2. Data Analysis and Requirements Gathering
*Collaborate with business stakeholders, data architects, and analysts to gather and understand data requirements.
*Analyze source systems and data flows to ensure accurate representation of data within models.
*Document data definitions, mappings, and transformations.

3. Collaboration and Communication
*Work closely with cross-functional teams, including IT, data engineering, and business units, to ensure alignment between data models and organizational goals.
*Provide technical guidance and mentorship to junior team members on data modeling best practices.
*Present data model designs and changes to stakeholders for review and approval.

4. Data Governance and Standards
*Ensure compliance with organizational data governance policies and regulatory requirements.
*Establish and enforce data modeling standards and naming conventions.
*Maintain data dictionaries and metadata repositories.

5. Tools and Technology
*Use data modeling tools such as ER/Studio, Erwin, or similar platforms to create and manage data models.
*Collaborate with database administrators to implement physical data models in relational databases (e.g., SQL Server, Oracle, PostgreSQL).
Support data integration efforts with knowledge of ETL processes and tools.

Role Requirements and Qualifications :
*Proficiency in SQL for data querying, manipulation, and automation.
*Basic knowledge and practical experience in PySpark for data processing and transformation.
*Understanding of data warehousing concepts, ETL processes, and data integration methodologies.
*Ability to assist in creating and maintaining database schemas, 5+ years' experience
*Awareness of data governance principles and best practices.

Why Join Us:
*Opportunities to work on transformative projects, cutting-edge technology and innovative solutions with leading global firms across industry sectors.
*Continuous investment in employee growth and professional development with a strong focus on up & re-skilling.
*Competitive compensation & benefits, ESOPs and international assignments.
*Supportive environment with healthy work-life balance and a focus on employee well-being.
*Open culture that values diverse perspectives, encourages transparent communication and rewards contributions.

How to Apply:
If you are interested in joining our team and meet the qualifications listed above, please apply and submit your resume highlighting why you are the ideal candidate for this position.