Synergy Loft Opportunity:
Data Analytics Specialist - GOA
$90-$105/HR
Requisition Closing Date: SEPTEMBER 12, 2024 5:00PM
Remote/Hybrid - Edmonton, Alberta
Is this opportunity for you or someone you know?
Role Description:
Scope:
Reporting to the Manager, Data Product Delivery, the ideal candidate will be responsible for orchestrating and implementing robust ETL pipelines for different data product builds. The role requires incorporating CI/CD best practices while demonstrating strong commitment to data security and compliance.
Duties:
• Lead or be part of a team responsible for the generalizable extraction of knowledge from data by applying various techniques and theories including machine learning, computer programming, statistics, data engineering, pattern recognition and learning, visualization, uncertainty modeling, data warehousing, and high-performance computing.
• Design, orchestrate and develop high-performance and robust ETL pipelines leveraging cloud native tools.
• Integrate DevOps practices to the development workflow using CI/CD best practices.
• Build and optimize data warehouses, data lakes, ensuring efficient storage and retrieval system for analytical needs.
• Provide expertise in data modelling (star or snowflake schema) to enhance data flow and query performance, supporting Data Product Delivery.
• Hands – on experience with building and managing data products, from initial concept through to deployment while ensuring alignment with business objectives and user requirements.
• Understanding of Data Product Market place and its key Data Governance components including Data Quality, Meta data, Data lineage, accessibility and standardization.
• Demonstrate strong commitment to Data Security and Compliance to protect sensitive information and enforce data governance in enterprise platforms (access control, security policies across platforms etc.).
• Work across a myriad of technology stacks in Azure, Cloudera, Snowflake, PowerBI etc.
• Experience with Python and SQL in the context of building data pipelines
• Experience working with Big Data technologies
• Experience in Data Analytics
• Design and create dashboards and custom reporting with various data sources and inputs.
• Apply skills to provide insights, support decision-making and facilitate strategic business planning across the department.
• Provide executives and decision makers a deeper understanding of their operations, transactions, services and information required for them to identify new opportunities that can only be uncovered through analytics.
• Provide depth and insight to data produced by the various teams and transform them into meaningful analytics for decision making.
• Ensure delivery processes are robust, of high quality and repeatable.
• Provide strategic agility and the ability to make sense of large amounts of disparate data to tell a cohesive story focused on key strategic decision-making for executives.
• Integrate both quantitative and qualitative data to create business insights.
• Analyze data and prepare information results.
• Gather and document client requirements.
• Design and construct information products.
• Capture business and technical metadata for information products.
• Establish and operate control processes including schedule management, status reporting, issues, risk, and change management at the program level.
• Escalate issues and risks, as appropriate.
• Work within a multi-vendor/staff environment.
Mandatory Qualifications: (Must have 100% of qualifications to apply)
Proposed resource must meet or exceed one of the following:
• University graduation-Computing Science (CS), Information Technology (IT), Engineering (ENG), Management Information Systems (MIS) or related discipline & 6-yrs progressive related experience;
• 2-yr diploma-CS, IT, ENG, MIS or related discipline & 8-yrs progressive related experience;
• 1-yr certificate-CS, IT, ENG, MIS or related discipline & 9-yrs progressive related experience;
• 10-yrs progressive related experience
MINIMUM 8 YEARS OF THE FOLLOWING:
- Experience building high performance, scalable and robust ETL pipelines in distributed clusters
- Experience in creating Microsoft-SQL database solutions.
- Experience with projects that involved data science , data engineering and / or AI.
- Experience integrating DevOps practices to the development workflow using CI/CD best practices
- Experience using analytical and problem solving skills to plan and design creative solutions.
- Experience with dimensional modeling techniques.
- Experience with Python development
- Experience with relational database modeling techniques.
- Direct, hands-on experience with design and implementation of data security, data privacy, policies, data de-identification/anonymization, data audits/reviews, synthetic data
- Experience in Agile project methodology.
- Experience in building analytical and quantitative analysis models.
- Experience in understanding complex businesses questions and framing the right analytical question to solve a business problem.
- Experience using Hadoop, Microsoft SQL and unstructured data. Must have background with unstructured data, in the form of social media, video feeds or audio.
- Experience with projects spanning multiple technical environments.
- Experience working across both business and technology.
NOTES ON LOCATION:
Working Hours:
• Standard Hours of work are 08:15 – 16:30 Alberta time, Monday through Friday excluding holidays observed by the Province
• Work must be done from within Canada, due to network and data security issues.
- Onsite meetings include but are not limited to strategic, architectural, and technical discussions, meeting with team members, senior managers, directors, executive directors and business clients. Frequency of meeting could be up to 3-4 times per month in Edmonton, Alberta
- All travel costs at contractors own expense
Estimated Start Date: OCT 2024
Estimated End Date: AUG 2025
Maximum Duration of Extensions: 1 x 12 months
Rate Range: $90 - $105/HR
Based on Experience and Competitiveness