Job Title: Data Engineer
Location- Calgary, AB
Visa- PR and Citizens
The Data Engineer for the Technology + Innovation Lab – a new group within Enbridge tasked with positively disrupting its core businesses with innovative and impactful products using advanced technologies – will help ingest, transform and store clean and enriched data in ready for business intelligence consumption. Fully capable specialist able to solve complex, data-centric problems and drive solutions to completion independently. An ideal candidate should be able to design, model and maintain data warehouses and data marts, as well as maintain and configure data engineering and ETL tools (e.g., ODI, DataServices, SSIS).Brings deep functional expertise to develop polished modular code in a distinctive way to ensure large-scale business impact of the digital products being built and drive competitive advantage for Enbridge as a whole
• Interacts with business teams and capable of understanding how data needs to be structured for consumption.
• Works independently on complex data engineering problems to support data science strategy of products
• Use broad and deep technical knowledge in the data engineering space to solve complex data problems for product teams, with a core focus on leveraging technical expertise
• Improves the data availability by acting as a liaison between Lab teams and source systems
• Collects, blends, and transforms data using ETL tools, database management system tools, and code development
• Implements data models and structures data in ready-for business consumption formats
• Performs aggregations on data across various warehousing models (e.g. OLAP cubes, star schemas…) for BI purposes