Sr. Data Analyst - Marketing - Jobs in ON

Job Description

Job Title : Data Analyst Location : Remote, CanadaFull Time OpportunitieWe are seeking a Data Analyst with experience in translating business requirements into technical data specifications, manipulating large datasets and supporting Data engineering teams with various data initiatives. They will be a hands-on contributor in the design and implementation of our cloud data platform that powers advanced analytics workloads.The Data Analyst will work with business stakeholders from Analytics, Marketing, Media teams to understand the business meaning of data, provide analysis and requirements so that data design is fully understood, and the development initiatives are in line with intended design and standards.Key Role and Responsibilities:

• Responsible for end-to-end data analysis to understand and define how data is collected, transformed, and published to users to support their business objectives.
• Elicit, analyze, interpret business and data requirements to develop complete data product solutions, includes review data models (entity relationship diagrams, dimensional data models), ETL and business rules, data life cycle management, governance, lineage, metadata and reporting elements.
• Manipulate large data sets using SQL to understand patterns in the data. Perform data profiling using various tools to understand the shape of the data to help inform data quality checks and/or curation rules that need to be developed.
• Support the engineering and operations team in interpreting the data and remediating issues when required.
• Engage with data owners, stewards to implement, maintain, enhance data governance, quality, security and privacy requirements, and related policies and standards.
• Prepare technical specifications for data ingestion and transformation rules. Partner with data architects to build data models for efficient consumption of data.
• Support the development of standards and best practices within the Data Analysis team, this includes documentation templates and agile development best practices.
• Actively participate in all agile ceremonies including daily stand-ups, backlog grooming, sprint planning and retros.

Required Qualifications and Skills:

• University or college degree in Computer Science, Mathematics, Engineering, Statistics, or related field of study.
• 5+ years of relevant experience gathering and documenting requirements as well as technical specifications for data solutions.
• Advanced SQL scripting skills. Python knowledge is plus.
• Solid understanding of AWS platform and tools associated with analytics and data (S3, Redshift, Glue)
• Strong understanding of SDLC and agile methodologies such as Scrum and KanBan.
• Resourceful and relentless: independently capable of seeking information, corralling resources, and delivering results in challenging situations
• Collaboration and Teamwork: works with others to deliver results, meaningfully contributing to the team and prioritizing group needs over individual needs
• Problem Solving: uses an organized and logical approach to find solutions to complex problems. Looks beyond the obvious to understand the root cause of problems