Senior Data Modeller

• 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 Data.

We are looking for candidates with experience in the following:

• Extensive experience in enterprise data modelling, including conceptual, logical and physical data models.
• Strong understanding of data architecture principles, data governance and enterprise data management best practices.
• Experience translating business requirements into scalable data models and technical design documentation.
• Proven experience analysing business processes and designing data models to support reporting, analytics and operational systems.
• Strong data profiling, data analysis, data quality and data mapping experience, including source-to-target mapping and legacy data migration.
• Experience designing and implementing data models for data warehouses, data lakes, operational data stores (ODS) and data marts.
• Experience reverse engineering existing databases and optimising logical and physical data models.
• Strong SQL skills with experience writing complex queries, stored procedures and performance tuning.
• Experience working with relational databases and modern NoSQL platforms.
• Knowledge of ETL processes, data integration and data transformation techniques.
• Experience defining enterprise data standards, metadata management and naming conventions.
• Experience documenting data architecture, business rules, data dictionaries and technical specifications.
• Familiarity with UML and business process modelling techniques.
• Experience facilitating workshops, Joint Application Design (JAD) sessions and collaborating with business and technical stakeholders.
• Ability to mentor junior team members and promote data modelling best practices across delivery teams.
• Experience supporting testing activities, including data validation, reconciliation and data quality assurance.
• Strong analytical, problem-solving and stakeholder management skills.

• SQL Server, Oracle or PostgreSQL
• NoSQL databases such as MongoDB or Cassandra
• Erwin Data Modeler, ER/Studio or similar modelling tools
• TOAD or equivalent SQL development tools
• Azure Data Factory, Databricks or other modern data platforms
• Git, Azure DevOps or similar version control tools
• Power BI or other BI platforms
• PL/SQL or T-SQL

As part of a leading global Data and AI company, you can look forward to:

• A competitive salary with a generous bonus, private healthcare, critical illness life assurance at 4 x your annual salary, income protection insurance, and a rewarding pension.
• EXL provides everyday financial well-being solutions, such as cash back cards, in which you can earn cashback while enjoying discounts, promotions, and offers from top retailers. We also offer a Cycle Scheme where you can save money on bikes and cycling accessories.
• At EXL, we are committed to providing our employees with the tools and resources they need to succeed and excel in their careers. We offer a wide range of professional and personal development opportunities. We also support a range of learning initiatives that allow our employees to build on their existing skills and knowledge. From online courses to seminars and workshops, our employees have the opportunity to enhance their skills and stay up to date with the latest trends and technologies.
• As an Equal Opportunity Employer, EXL is committed to diversity. Our company does not discriminate based on race, religion, colour, national origin, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, age, or disability status.
• EXL employees are eligible to purchase stock as part of our Employee Stock Purchase Plan (ESPP).
• At EXL, we offer a flexible hybrid working model that allows employees to live a balanced, healthy lifestyle while strengthening our culture of collaboration.

To be considered for this role, you must already be eligible to work in the United Kingdom.