Senior Data Manager and Engineer

CONTEXT

Imagine a critical public service, one that touches the lives of countless individuals, operating with systems built over decades. Our client, a vital public institution, is an essential governmental body responsible for highly sensitive and impactful operations. They are embarking on an ambitious 'eDossier modernization program,' a digital transformation initiative designed to overhaul their core data management capabilities. This isn't merely a technical upgrade; it's a mission to enhance efficiency, accuracy, and accessibility of information, which directly impacts their ability to serve their constituents effectively and humanely. The sheer volume and sensitivity of the data, combined with the need for robust, scalable, and secure solutions, present a fascinating challenge. You will step into a role that is crucial for building the future backbone of their digital operations, moving from legacy systems to a state-of-the-art cloud environment. Your work will directly empower decision-makers with timely, accurate insights, making a tangible difference in the lives of vulnerable populations.

ACTIVITIES

• Lead and execute hands-on data management and data engineering activities, from conceptualization to implementation, focusing on building scalable and resilient solutions.
• Design, develop, and maintain robust data integration pipelines, ensuring seamless flow of data from diverse sources into the modernized cloud platform.
• Drive the migration of existing data assets and systems to the Azure Cloud environment, leveraging Azure's suite of data services (e.g., Azure Data Factory, Azure Synapse Analytics, Azure Databricks).
• Implement and enforce stringent data quality frameworks and processes, developing monitoring tools and resolution strategies to ensure data integrity and reliability.
• Architect and optimize data storage solutions, defining data models and schemas that support both operational needs and analytical requirements.
• Collaborate closely with business analysts and decision-makers to understand data needs, translating complex requirements into technical solutions.
• Develop interactive and insightful dashboards and reports using Power BI, enabling stakeholders to visualize key performance indicators and make data-driven decisions.
• Provide expert guidance and mentorship to junior data professionals within the team, fostering a culture of technical excellence and continuous learning.
• Ensure compliance with data governance policies, security standards, and regulatory requirements pertaining to sensitive public sector data.

EXPECTED ACHIEVEMENTS

• Successfully complete the migration of critical eDossier data to the Azure Cloud, establishing a highly performant and secure modern data platform.
• Implement robust, automated data pipelines that significantly improve data integration efficiency and reduce manual intervention.
• Elevate data quality standards across the organization, leading to more reliable reporting and more confident decision-making.
• Deliver compelling and user-friendly Power BI dashboards that provide actionable insights, empowering stakeholders to optimize public services.
• Contribute to the strategic evolution of the data architecture, ensuring it is scalable, adaptable, and aligned with future organizational needs.
• Become a key technical leader and subject matter expert in data engineering and management within the organization, driving innovation and best practices.

ENVIRONMENT

Azure Cloud Platform (Azure Data Factory, Azure Synapse Analytics, Azure SQL Database, Azure Data Lake Storage, Azure Databricks), Power BI, SQL, Python, Data Modeling Tools, Data Governance Frameworks, Agile/Scrum Methodologies.