Job Specifications
Job title: Enterprise Security Data Solution Designer / Architect
Location: 450 1st Street SW Calgary, AB CAN T2P 5H1
Contract length: 01/05/2026 to 12/31/2026
Minimum Qualifications
• Must have experience working with PowerBI
• Five to 10 years in ETL (extract, load, transform) tools, techniques, data warehousing, and metadata & quality management
• Strong understanding of what Key Performance Indicators and how they drive key outcomes
• Experience with modern data engineering tools in addition to strong relational database skills
• A bachelor’s or master’s degree in computer science, computer engineering, software engineering or a related technical field
• Strong analytical and problem-solving skills and well-versed with fundamental programming concepts and/or data structures and algorithms.
• Strong computing foundation and fundamentals, including experience with design patterns
• Ability to build excellent relationships with peers, leaders, technical teams, business users and executives
• A positive “can do” attitude; works through challenging situations with integrity and dignity
Preferred Qualifications
• Experience using ServiceNow for performance reporting
• PowerBI, Fabric, AWS
• Experience with automation and real time compliance
The opportunity
We are seeking an Enterprise Security (ES) Data Solution Designer who has knowledge and experience in understanding the complexities of the Client 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 decisions.
What You’ll Do
As 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 organization.
ES Data Pipeline
• Act as the subject matter expert on data model and data architecture.
• Manage data extraction, transformation, and loading (ETL) processes to ensure data accuracy and timeliness.
• Maintain and enhance existing ingestions into AWS Datalake and Microsoft Fabric.
• Design, build, and document data flows, including defining and setting up data requirements and standards aligned with compliance needs.
• Collaborate with business stakeholders to identify data needs and deliver effective data ingestion solutions.
• Proactively optimize processes by fine-tuning system configurations, balancing workloads, and implementing fault-tolerant mechanisms.
Data Quality & Security
• Implement validation rules, cleansing procedures, and monitoring systems to detect and rectify anomalies within datasets.
• Ensure security and privacy measures are applied at both the report and data layers.
• Maintain data integrity and consistency across all reporting layers.
• Establish data governance frameworks that define standards and policies for data usage, ensuring consistency and reliability.
• Track the health of data pipelines, assessing metrics such as latency, error rates, and throughput.
Data Visualizations
• Design and develop dashboards and reports for actionable compliance and performance insights.
• Monitor presentation layer and data feeds to ensure continuous operation and resolve issues promptly.
• Continuous monitoring of data workflows to maintain system performance and identify potential issues before they escalate.
Real Time Compliance Monitoring
• Work with compliance team to build out the roadmap and key components critical for maturing our real time compliance and monitoring.
• Facilitate the implementation of real-time data gathering systems to realize real time compliance.
• Leverage existing systems and automated compliance systems to monitor, manage and enforce regulatory and corporate policies automatically.
• A
About the Company
We are leaders in specialist recruitment and workforce solutions, offering advisory services such as learning and skill development, career transitions and employer brand positioning.
As the Leadership Partner to our customers, we invest in lifelong partnerships that empower people and businesses to succeed. We help you achieve your career goals and deliver your business needs by combining meaningful innovation with our global scale and insights.
Last year we helped over 280,000 people find their next career. Join the mill...
Know more