Data Analytics Specialist

We are looking for an **Data Analytics Specialist** for a **11-month contract position, with possible extensions** in **Edmonton, Alberta.** **Must be legally entitled to work in Canada.**

**Position is available as hybrid, remote or on-site location. 7.25 hours a day, 36.25 hours a week.**

**Role Description**

**Responsibilities**
- 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
- Design and create dashboards and custom reporting with various data sources and inputs
- 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

**Required Skills and Experience**
- The proposed resource must meet or exceed one of the following combinations of education: 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 or 1-yr certificate-CS, IT, ENG, MIS or related discipline & 9-yrs progressive related experience
- Experience with Python and SQL in the context of building data pipelines
- Experience working with Big Data technologies
- Experience in Data Analytics
- 3 years of experience in building ETL and building high performance, scalable and robust ETL pipelines in distributed clusters
- 3 years of experience in creating Microsoft-SQL database solutions
- 5 years’ experience in data analytics or data science.
- 5 years’ experience with projects that involved data science, data engineering and / or AI
- 3 years’ experience integrating DevOps practices to the development workflow using CI/CD
- 5 years’ experience using analytical and problem-solving skills to plan and design creative
- 4 years’ experience with dimensional modeling techniques
- 3 years’ experience with Python development
- 4 years’ experience with relational database modeling techniques
- 4 years’ experience working in a data warehouse/business intelligence or relevant data
- 5 years of direct, hands-on experience with design and implementation of data security, data, privacy, policies, data de-identification/anonymization, data audits/reviews, synthetic data
- 5 years’ experience in Agile project methodology
- 4 years’ experience in building analytical and quantitative analysis models
- 5years experience in understanding complex businesses questions and framing the right analytical question to solve a business problem
- 5 years’ experience using Hadoop, Microsoft SQL and unstructured data. Must have background with unstructured data, in the form of social media, video feeds or audio
- 4 years’ experience with projects spanning multiple technical environments
- 4 years’ experience working across both business and technology

**InSync Systems Inc.** is a privately-owned boutique Canadian Resourcing and Consulting Services Company that works cl