Data Architect

Enterprise Security (ES) Data Solution Designer

• Contract Length: 1 Year
• Location: Calgary, Alberta

Raise is currently hiring an
Enterprise Security (ES) Data Solution Designer
on behalf of our client. They're expanding their team to meet growing needs, making this a unique opportunity to work with an industry leader. Our Client, is one of North America's leading energy infrastructure companies with operations in natural gas, oil and power industries throughout Canada, the United States, and Mexico

Note: The primary pay rate is based on T4 classification; however, we will also consider applications from candidates interested in an INC classification, where applicable

**.

Descriptio**

n The Enterprise Security (ES) Data Solution Designer in this role will require knowledge and experience in understanding the complexities of the ES organization who will create and oversee the ES data pipelines that automate the extraction, transformation, and loading (ETL) of data from various sources into centralized repositories. A focus will be on automation and real-time systems to automate data capture, eliminating manual entry and the risk of human error to help realize real time compliance reporting. The individual must have proven skills, competencies, and capacity to use information to provide insights and guide the stakeholders in proper interpretation to drive sound decision

**s.

What You'll**

DoAs part of the ES Awareness, Strategy & Performance team and in collaboration with management across the ES department, the ES Data Solution Designer manages the flow of data from source systems into cloud platforms (AWS and Microsoft Fabric), ensuring it's accurate, secure, and arrives on time. You'll act as the expert on how data is structured and moved, working with business teams to understand what data they need and building the pipelines to deliver it. You'd also monitor data quality and security, catching problems early through validation rules and tracking system health metrics like speed and error rates. Additionally, you'll create dashboards and reports that give leadership real-time visibility into compliance and performance, while building automated systems to continuously monitor regulatory requirements. Finally, you'll drive continuous improvement by staying current with industry best practices and introducing new solutions to optimize how data flows through the organizati

**on.

ES Data Pipe**

• lineAct as the subject matter expert on data model and data architect
• ure.Manage data extraction, transformation, and loading (ETL) processes to ensure data accuracy and timelin
• ess.Maintain and enhance existing ingestions into AWS Datalake and Microsoft Fab
• ric.Design, build, and document data flows, including defining and setting up data requirements and standards aligned with compliance ne
• eds.Collaborate with business stakeholders to identify data needs and deliver effective data ingestion soluti
• ons.Proactively optimize processes by fine-tuning system configurations, balancing workloads, and implementing fault-tolerant mechani

sms.Data Quality & Secu

• rityImplement validation rules, cleansing procedures, and monitoring systems to detect and rectify anomalies within datas
• ets.Ensure security and privacy measures are applied at both the report and data lay
• ers.Maintain data integrity and consistency across all reporting lay
• ers.Establish data governance frameworks that define standards and policies for data usage, ensuring consistency and reliabil
• ity.Track the health of data pipelines, assessing metrics such as latency, error rates, and through

put.Data Visualizat

• ionsDesign and develop dashboards and reports for actionable compliance and performance insig
• hts.Monitor presentation layer and data feeds to ensure continuous operation and resolve issues promp
• tly.Continuous monitoring of data workflows to maintain system performance and identify potential issues before they escal

ate.Real Time Compliance Monito

• ringWork with compliance team to build out the roadmap and key components critical for maturing our real time compliance and monitor
• ing.Facilitate the implementation of real-time data gathering systems to realize real time complia
• nce.Leverage existing systems and automated compliance systems to monitor, manage and enforce regulatory and corporate policies automatica
• lly.Assist and where appropriate, build out automation as requi
• red.Utilize real-time dashboards to provide instant insights into compliance status, risks, and operational metr
• ics.Driving Best Practice & Continuous Improve
• mentDevelop expertise in the space and maintain strong understand of all our key performance metrics, risks and desired outco
• mes.Seek guidance from vendor partners and industry experts to ensure best pract
• ice.Introduce innovative solutions and services to help achieve service goals and objecti

**ves.

Qualifica**

• tionsFive to 10 years in ETL (extract, load, transform) tools, techniques, data warehousing, and metadata & quality manag
• ementStrong understanding of what Key Performance Indicators and how they drive key out
• comesExperience with modern data engineering tools in addition to strong relational database s
• killsMust have experience working with Po
• werBIStrong analytical and problem-solving skills and well-versed with fundamental programming concepts and/or data structures and algori
• thms.Strong computing foundation and fundamentals, including experience with design pat
• ternsAbility to build excellent relationships with peers, leaders, technical teams, business users and execu
• tivesA positive "can do" attitude; works through challenging situations with integrity and di

gnityPreferred Qualifica

• tionsExperience using ServiceNow for performance repo
• rtingPowerBI, Fabric
• , AWSExperience with automation and real time compl

ianceEducation and Sk

• ills A bachelor's or master's degree in computer science, computer engineering, software engineering or a related technical

field