Data Engineer

Data Engineer

POSITION LOCATION: London, ON

POSITION TITLE: Data Engineer

POSITION REPORTS TO: Practice Director, Enterprise Analyses

DEPARTMENT/UNIT NAME: Enterprise Analyses

JOB SUMMARY:

The Data Engineer will build and operationalize data necessary for enterprise data and analytics initiatives.  This role will build, manage and optimize data architecture and pipelines in accordance with industry standard practices and using industry standard tools, and will move these data pipelines effectively into production for data and analytics use cases across the organization.  The incumbent will ensure compliance with data governance and data security requirements while creating, improving and operationalizing these integrated and reusable data pipelines and analytical models that will support and promote self-service analytics. Will occasionally provide support to end users on the use of data visualization solutions. Responsible for maintaining and making recommendations to enhance technology as the needs of our client’s change.

ROLE & RESPONSIBILITIES:

Data and Analytics

• Design, build and maintain data pipelines (i.e. data flow from data sources to integration to consumption for specific use cases).
• Develop data models (conceptual, logical and/or physical) as required.
• Manage metadata using data preparation, integration and AI-enabled tools and techniques.
• Drive automation in data integration. Recommend and lead the implementation techniques and architectures to automate the most-common, repeatable and tedious data preparation and integration tasks partially or completely to minimize manual and error-prone processes.
• In collaboration with functional leaders, identify the company’s inefficiencies, inaccuracies, missed opportunities, other issues and report on the recommended improvements to the executive team.
• Provide technical leadership for Athena (analytics platform) by directing and prioritizing the work of others on the team related to Athena.
• Act as a subject matter expert for the Athena platform.

Business Analysis

• Assist cross-functional groups, other Business/Process analysts, and other stakeholders to gather, define and refine their data requirements for various initiatives.
• Propose appropriate (and innovative) data ingestion, preparation, integration and operationalization techniques in optimally addressing these data requirements.
• Assess ways to further leverage existing systems and recommend methods for streamlining data flow and data integration.
• While identifying and evaluating new projects or requests for enhancements, work with the functional leader to determine the project cost, timeline, goals and feasibility and then support the project through completion.  

Data Compliance and Governance

• Work with corporate leadership to manage and promote compliance with the corporate data strategy
• Collaborate with data stewards or appropriate stakeholders to develop policies to ensure the responsible use of data by data users and consumers.
• Lead the development and maintenance of documentation and the data catalog for Alimentiv data assets.
• Promote the available data and analytics capabilities and expertise to business unit leaders and educate them in leveraging these capabilities in achieving their business goals.
• Ensure data or software solutions continue to meet customer needs by capturing changes in requirements and making corresponding updates to existing software or data analytics.

QUALIFICATIONS:

Applicants should have a minimum of an undergraduate degree in relevant field of study (preferably in Computer Science, Information System)  and 4-6 years of relevant experience + strong analytical training . The successful candidate should be well experienced with Data Management architectures such as Data Warehouse, Data Lake, Data Catalogue and the supporting processes such as Data Integration, Governance, Metadata Management.    Strong experience with Microsoft Azure, and popular database programming languages including SQL. Proficient in PowerBI.  Demonstrated success in working with both IT and business while integrating analytics and data science output into business processes and workflows.  Experience in data management disciplines including data integration, modeling, optimization and data quality. Must have excellent written and verbal communication skills. Proven ability to work independently and as part of a team and meet important deadlines. Understanding of enterprise and company systems. Facilitation skills and business process mapping and analysis experience preferred. Statistical analysis skills are an asset.

WORKING CONDITIONS:

Office/Home-based

*Accommodations for job applicants with disabilities are available upon request



APPLY