Data Modelling Consultant
Accenture
Data Modelling Consultant
Job Description
We are:
Accenture’s Data & AI practice, the people who love using data to tell a story. We’re also the world’s largest team of data scientists, data engineers, and experts in machine learning and AI. A great day for us? Solving big problems using the latest tech, serious brain power, and deep knowledge of just about every industry. We believe a mix of data, analytics, automation, and responsible AI can do almost anything—spark digital metamorphoses, widen the range of what humans can do, and breathe life into smart products and services. Want to join our crew of sharp analytical minds?
About the Role:
As a Data Modeler, you will be responsible for designing and managing data models to support operational systems on Azure, with a focus on operational data models and NoSQL databases. Your key responsibilities include:
Developing and Maintaining Data Models: Create and manage conceptual, logical, and physical data models tailored for operational systems and integration use cases Azure SQL for operational data and NoSQL databases for flexible, scalable data structures. Analytical and dimensional modeling experience is a nice-to-have but not required.
Collaborating with Stakeholders: Work closely with business teams, including stakeholders and analysts, as well as IT professionals, to gather and refine data requirements for the program.
Data Profiling and Analysis: Perform data profiling and analysis to establish, refine, and maintain robust data models that meet business needs.
Conceptual Modeling: Build conceptual data models to identify key business entities and visualize their relationships, ensuring alignment with operational goals.
Logical Modeling: Develop detailed logical models that define entities, attributes, relationships, and their characteristics, optimized for both relational (Azure SQL) and NoSQL environments.
Physical Modeling: Convert logical models into physical models for Azure Data Lake, Azure SQL, and NoSQL databases, generating DDLs or equivalent schema definitions for implementation teams.
Testing and Deployment: Test DDLs and schema implementations to ensure consistency and performance across all environments (development, testing, production).
Design Workshops: Participate in and facilitate design workshops to align business data needs with the data model, ensuring clarity and consensus.
Conflict Resolution: Mediate and resolve model conflicts arising from competing business requirements, ensuring a balanced and effective solution.
Collaboration and Signoff: Partner with global business units, architecture, and delivery teams to review, finalize, and adopt data models.
Qualifications
What you need:
Bachelor’s degree or completion of a college diploma in a related field
5+ years of experience in designing Entity Relationship Models and operational data models, with specific expertise in data modeling for Azure Data Lake and Azure SQL, with hands-on experience in operational data structures.
5+ years of experience using ERWin as a data modeling tool (preferred)
Proficiency in NoSQL databases (e.g., Azure Cosmos DB or similar).
Strong experience with Azure cloud services, particularly Azure Data Lake and Azure SQL, for building and deploying data models.
Eligibility for reliability security clearance
Locations
Life at Accenture
Work where you're inspired to explore your passions and where your talents are nurtured and cultivated. Innovate with leading-edge technologies on some of the coolest projects you can imagine.
Training and Development
Take time away to learn and learn all the time in our regional learning hubs, connected classrooms, online courses and learning boards.
Work Environment
Be your best every day in a work environment that helps drive innovation in everything you do.
Learn more about Accenture
Our more than 742,000 people in more than 120 countries, combine unmatched experience and specialized skills across more than 40 industries. We embrace the power of change to create value and shared success for our clients, people, shareholders, partners and communities.
Our Expertise
Meet Our People
From entry-level to leadership, across all business and industry segments, get to know our people harnessing technology to make a difference, every day.
Stay connected
Join Our Team
Search open positions that match your skills and interest. We look for passionate, curious, creative and solution-driven team players.
Keep Up to Date
Stay ahead with careers tips, insider perspectives, and industry-leading insights you can put to use today–all from the people who work here.
Job Alert Emails
Personalize your subscription to receive job alerts, latest news and insider tips tailored to your preferences. See what exciting and rewarding opportunities await.