Data Modeler

EXL; Pune District; On-site; INR 2,000,000 - 3,500,000; Full time

Job summary

EXL in Pune, India seeks an experienced Data Architect with 8+ years in data modelling and architecture to lead complex data initiatives. The role requires hands-on design with tools like Erwin, ERStudio or PowerDesigner, strong SQL, and cloud/on-prem architecture knowledge.

Management and consulting experience are valued, with a mix of technical leadership and stakeholder collaboration. You'll work across data integration, warehousing, and modern data platforms (Snowflake, Redshift, Hadoop) in

Qualifications

• 7-10 years industry implementation experience with data modelling tools such as Erwin, ERStudio, PowerDesigner.
• Minimum of 8 years of data architecture or data modelling experience.
• 5-7 years of management experience required.
• 5-7 years consulting experience preferred.
• Experience with dimensionally modelled data.
• Bachelor’s degree or equivalent; Master’s degree preferred.
• Cloud and on-prem architectures (Azure, AWS, GCP, Snowflake preferred).

Skills

Data modelling

Data architecture

SQL scripting

Data warehousing

Dimensional modelling

SDLC knowledge

Big data platforms

Education

Bachelor's degree

Master's degree preferred

Tools

Erwin

ER/Studio

PowerDesigner

Job description

• 7-10 Years industry implementation experience with one or more data modelling tools such as Erwin, ERStudio, Power Designer etc.
• Minimum of 8 years of data architecture, data modelling or similar experience
• 5-7 years of management experience required
• 5-7 years consulting experience preferred
• Experience working with dimensionally modelled data
• Bachelor’s degree or equivalent experience, Master’s Degree Preferred
• Understanding of cloud (Azure, AWS, GCP, Snowflake preferred) and on premises architectures
• Experience in data analysis and profiling
• Strong data warehousing and OLTP systems from an integration perspective
• Strong understanding of data integration best practices and concepts
• Strong SQL skills required scripting preferred
• Strong Knowledge of all phases of the system development life cycle
• Experience with major database and big data platforms (e.g. RDS, Aurora, Redshift, Data bricks, MySQL, Oracle, PostgresSQL, Hadoop, Snowflake, etc.)
• Understanding and experience with major Data Architecture philosophies (Dimensional, ODS, Data Vault, etc.)
• Understanding of modern data warehouse capabilities and technologies such as real-time, cloud, Big Dat