Data Analytics Specialist

Job title: Data Analytics Specialist

Company: InSync

Job description: 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
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 complianceResponsibilities

• 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
• 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

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

Please note that while all applications are appreciated, only candidates selected for interview will be contacted.InSync Systems Inc. is a privately-owned boutique Canadian Resourcing and Consulting Services Company that works closely with a range of corporate clients across multiple industries to bring them solutions that effectively address their business needs.

Expected salary:

Location: Edmonton, AB

Job date: Sat, 07 Sep 2024 07:48:52 GMT

Apply for the job now!