Back to search

Senior Consultant - Data

Lead the design of end-to-end data architectures for assigned complex customer engagements, covering data warehouses, data lakes, lakehouses, and cloud-based platforms.

  • Colombo, Western Province, Sri Lanka
  • Contract
  • Posted Jan 1, 2024
INDUSTRYSoftware & InternetSaaS & Enterprise SoftwareData & Analytics

Responsibilities

  • Lead the design of end-to-end data architectures for assigned complex customer engagements
  • Design conceptual, logical, and physical data models and integration architectures
  • Act as architect on assigned engagements, reviewing build work against the agreed architecture
  • Support pre-sales on assigned data opportunities, preparing solution designs, effort estimates, bills of materials, and proposal and RFP content
  • Engage customer IT and business stakeholders to gather requirements, present architectures, and advise on data modernization and cloud migration options
  • Guide data engineers, BI developers, and partner teams through design decisions and technical issues
  • Implement data governance, quality, lineage, metadata, and security controls within assigned solutions
  • Provide architectural guidance for data engineering, business intelligence, analytics, and AI/ML workstreams on assigned engagements
  • Evaluate data platforms, technologies, and tools for assigned solutions, and recommend options based on business and technical requirements
  • Contribute to reference architectures, design patterns, templates, and estimation models for the data practice
  • Ensure solutions are documented, tested, and handed over to support with runbooks and monitoring
  • Mentor data engineers and consultants, promoting technical excellence and knowledge sharing across the team

Requirements

  • Bachelor's degree or higher in Data Science, Information Technology, or a related field
  • Experience in a banking
  • Experience in a financial services
  • Experience in a telecom
  • Experience in a public sector

Nice to have: Dimensional modeling, Data Vault, 3NF, Microsoft Purview, Collibra, Informatica Axon, AI/ML data requirements

Skills

Data architectureData modelingData warehousingData lakesLakehouse architectureReal-time processingAdvanced SQLDatabricksSnowflakeMicrosoft FabricAzure SynapseAmazon RedshiftGoogle BigQueryOCIAzure Data FactoryInformaticaOracle Data IntegratorSSISTalenddbtAPIsCDCKafkaData governanceData qualityLineageMetadataMaster data managementSecurity controlsPower BITableauOracle AnalyticsDevOpsDataOpsGitCI/CDTerraformPythonPySparkDatabricksSnowflakeMicrosoft FabricAzure SynapseAmazon RedshiftGoogle BigQueryOCIAzure Data FactoryInformaticaOracle Data IntegratorSSISTalenddbtAPIsCDCKafkaMicrosoft PurviewCollibraInformatica AxonPower BITableauOracle AnalyticsGitCI/CDTerraformPythonPySpark

Full description

Job Description Lead the design of end-to-end data architectures for assigned complex customer engagements, covering data warehouses, data lakes, lakehouses, and cloud-based platforms, and ensuring scalability, availability, performance, and security. Design conceptual, logical, and physical data models and integration architectures for assigned solutions, in line with the Company's data architecture standards. Act as architect on assigned engagements, reviewing build work against the agreed architecture and escalating material design risks to senior architecture leadership. Support pre-sales on assigned data opportunities, preparing solution designs, effort estimates, bills of materials, and proposal and RFP content. Engage customer IT and business stakeholders to gather requirements, present architectures, and advise on data modernization and cloud migration options. Guide data engineers, BI developers, and partner teams through design decisions and technical issues, and support the recovery of at-risk projects. Implement data governance, quality, lineage, metadata, and security controls within assigned solutions, ensuring compliance with the Personal Data Protection Act No. 9 of 2022 and applicable sector regulations. Provide architectural guidance for data engineering, business intelligence, analytics, and AI/ML workstreams on assigned engagements. Evaluate data platforms, technologies, and tools for assigned solutions, and recommend options based on business and technical requirements. Contribute to reference architectures, design patterns, templates, and estimation models for the data practice. Ensure solutions are documented, tested, and handed over to support with runbooks and monitoring. Mentor data engineers and consultants, promoting technical excellence and knowledge sharing across the team. Person Specification 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. 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.

Senior Consultant - Data at Millennium IT ESP | Referso Jobs