Data Modeler at Accenture

Mumbai, Maharashtra, India

Apply Now

Not SpecifiedCompensation

Senior (5 to 8 years)Experience Level

Full TimeJob Type

UnknownVisa

Technology, ConsultingIndustries

Requirements

Bachelor’s or Master’s degree in Computer Science, Information Technology, or related field (15 years full-time education)
Minimum 12 years of experience (with specific note of minimum 5 years in Large Language Models)
Strong expertise in dimensional modeling (star/snowflake schemas)
Hands-on experience with SQL for data modeling, querying, and optimization
Experience designing fact and dimension tables, slowly changing dimensions (SCD), and hierarchical structures
Familiarity with ETL/ELT processes and pipeline development
Exposure to cloud data platforms (AWS Redshift, Azure Synapse, BigQuery, Snowflake) is a plus
Knowledge of data governance, metadata management, and data quality best practices
Experience with BI and reporting tools such as Power BI, Tableau, or Looker
Understanding of big data frameworks (Spark, Databricks, Hadoop)
Experience with automation, CI/CD, or orchestration tools (Airflow, Prefect, Azure Data Factory)
Familiarity with Python or PySpark for data transformation
Strong analytical and problem-solving skills
Excellent communication and collaboration skills
Ability to work in cross-functional, agile teams
Detail-oriented with a focus on data quality and consistency
Data Modeling Techniques and Methodologies (must-have skill)

Responsibilities

Design and implement dimensional models (star schema, snowflake schema) to support business analytics and reporting needs
Collaborate with business stakeholders to understand requirements and translate them into logical and physical data models
Create fact and dimension tables, hierarchies, and relationships for data warehouses and analytics platforms
Optimize data models for query performance, scalability, and maintainability
Work with ETL/ELT developers to implement data pipelines that populate dimensional models
Ensure data consistency, integrity, and quality throughout the ETL process
Support migration and integration of data models from on-premise to cloud platforms (AWS, Azure, GCP)
Maintain comprehensive data modeling documentation including entity-relationship diagrams, data dictionaries, and metadata
Partner with BI developers and data analysts to enable accurate reporting and analytics
Conduct peer reviews of data models to enforce best practices and standards
Work with key business representatives, data owners, end users, application designers, and data architects to model current and new data

Skills

Data Modeling

Dimensional Modeling

Star Schema

Snowflake Schema

Data Warehousing

ETL

ELT

Data Architecture

Data Pipelines

Data Quality

Accenture

Global professional services for digital transformation

About Accenture

Accenture provides a wide range of professional services, including strategy and consulting, technology, and operations, to help organizations improve their performance. Their services assist clients in navigating digital transformation, enhancing operational efficiency, and achieving sustainable growth. Accenture's offerings include cloud migration, cybersecurity, artificial intelligence, and data analytics, which are tailored to meet the needs of various industries such as financial services, healthcare, and retail. What sets Accenture apart from its competitors is its extensive industry knowledge and ability to deliver comprehensive solutions that address both immediate challenges and long-term goals. The company's aim is to support clients in reducing their environmental impact while driving innovation and growth.

Dublin, IrelandHeadquarters

1989Year Founded

$8.5MTotal Funding

IPOCompany Stage

Consulting, Enterprise Software, CybersecurityIndustries

10,001+Employees

Risks

Rapid AI advancements may outpace Accenture's current capabilities, risking competitive disadvantages.

Integration challenges from multiple acquisitions could affect Accenture's operational efficiency.

The rise of AI-driven startups may disrupt Accenture's market share in customer service solutions.

Differentiation

Accenture's acquisitions enhance its capabilities in digital twin technology for financial services.

The company is expanding its expertise in net-zero infrastructure through strategic acquisitions.

Accenture's focus on software-defined vehicles positions it as a leader in automotive innovation.

Upsides

Accenture's investment in EMTECH supports central bank modernization amid digital currency evolution.

The acquisition of Award Solutions boosts Accenture's presence in the growing 5G and IoT markets.

Accenture's strategic acquisitions align with high-growth markets like digital twins and net-zero projects.

Land your dream remote job 3x faster with AI

Try Jobo Free