ME

Senior Consultant - Data

MillenniumIT ESPlinkedin.com
Nov 17, 2026, 4:07 PM2d ago
Full-timeColombo, Western ProvinceSenior (6+ yrs)

About the role

The Senior Consultant - Data will lead the design and implementation of end-to-end data architectures for complex customer engagements, including data warehouses, lakes, lakehouses, and cloud-based platforms. The role involves designing data models and integration architectures, acting as the architect on projects, supporting pre-sales activities, engaging with customer stakeholders, and guiding technical teams through design and delivery. The consultant will also implement data governance and security controls, evaluate data platforms and tools, contribute to practice assets, and mentor junior team members. The position requires a strong background in data engineering, architecture, and hands-on experience with modern data platforms and integration tools.

Must have

  • Bachelor's degree or higher in Data Science, Information Technology, or a related field.
  • Minimum 6 years of experience in data engineering, database technologies, or enterprise data solutions, including experience in data architecture or solution design.
  • Proven delivery of end-to-end data platform projects, such as data warehouses, lakehouses, or analytics platforms, for external customers or large enterprises, preferably in a systems integration or IT services environment.
  • Strong knowledge of data modelling (dimensional, Data Vault, 3NF, and master data), data warehousing, data lakes, lakehouse architecture, and real-time processing, and of databases such as Oracle, SQL Server, PostgreSQL, MySQL, and NoSQL, including advanced SQL.
  • Hands-on experience with data platforms such as Databricks, Snowflake, Microsoft Fabric, Azure Synapse, Amazon Redshift, Google BigQuery, and OCI, and with integration tools such as Azure Data Factory, Informatica, Oracle Data Integrator, SSIS, Talend, dbt, APIs, CDC, and Kafka.
  • Good knowledge of data governance, quality, lineage, metadata, master data management, and security controls such as encryption, masking, and role-based access, using tools such as Microsoft Purview, Collibra, or Informatica Axon.
  • Understanding of BI tools (Power BI, Tableau, Oracle Analytics) and AI/ML data requirements, with working knowledge of DevOps and DataOps (Git, CI/CD, Terraform, Python or PySpark).
  • Experience in client-facing pre-sales and estimation, with strong communication, presentation, and stakeholder management skills.
  • Strong analytical, problem-solving, and design decision-making skills, with the ability to mentor and guide technical teams.

Nice to have

  • Domain experience in banking and financial services, telecom, or the public sector, and certifications such as Azure or AWS Data Engineer, AWS Solutions Architect, Google Professional Data Engineer, or DAMA CDMP, will be considered an advantage.

Technologies

  • AWS
  • Azure
  • Azure Data Factory
  • Azure Synapse
  • BigQuery
  • CI/CD
  • Data Engineering
  • Data Lake
  • Data Modeling
  • Data Science
  • Data Warehousing
  • Databricks
  • dbt
  • DevOps
  • Git
  • Kafka
  • Lakehouse
  • Machine Learning
  • Master Data Management
  • Microsoft Fabric
  • MySQL
  • NoSQL
  • Oracle
  • PostgreSQL
  • Power BI
  • Microsoft Purview
  • PySpark
  • Python
  • Redshift
  • Snowflake
  • SQL
  • SQL Server
  • SSIS
  • Tableau
  • Talend
  • Terraform
  • Vault