Enterprise Security (ES) Data Solution Designer
- Pay Rate: $73.53/hour, depending on experience
- Contract Length: 1 Year
- Location: Calgary, Alberta
Raise is currently hiring a 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.
Description
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 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.
- Assist and where appropriate, build out automation as required.
- Utilize real-time dashboards to provide instant insights into compliance status, risks, and operational metrics.
- Driving Best Practice & Continuous Improvement
- Develop expertise in the space and maintain strong understand of all our key performance metrics, risks and desired outcomes.
- Seek guidance from vendor partners and industry experts to ensure best practice.
- Introduce innovative solutions and services to help achieve service goals and objectives.
Qualifications
- 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
- Must have experience working with PowerBI
- 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
- Education and Skills
- A bachelor’s or master’s degree in computer science, computer engineering, software engineering or a related technical field
Looking for meaningful work? We can help!
Raise is an established hiring firm with over 65 years of experience. We believe strongly in making the world a better place through work, which is why we’re a certified B Corporation and donate 10% of our profits to charity.
We strive to build teams that reflect the diversity of the communities we work in. We encourage all qualified applicants to apply, including people from traditionally underrepresented groups such as women, visible minorities, Indigenous peoples, people identifying as LGBTQ2SI, veterans, and people with visible/nonvisible disabilities.
We have a dedicated webpage for accommodations where you can learn more about what we offer and request accommodation: https://raise.jobs/accommodations/
In order to submit candidates for roles, our clients will sometimes require personal information to confirm the identity of applicants and their legal status to work. Raise will never ask you for personal or banking information unless you have been selected for a job. If you are ever unsure about the legitimacy of this or any other Raise job posting (or have any other questions), please contact us at +1 800-567-9675 or hello@raiserecruiting.com.
#WES
#LI-SC1