Data Analytics Engineer - 36142064

Data Analytics Engineer - 36142064

Duration: 16 months to start

Location: Downtown Toronto Hybrid (3 days a week - Tuesday and Thursday onsite with one flex day)

The Global Business Solutions Group (GSBG), serves the needs of small businesses and self-employed people through our platform ecosystem including Quickbooks and Mailchimp products. Our mission is to power prosperity around the world, which means dramatically rethinking how we enable small businesses and individuals to run their businesses with confidence. The Data Science and Analytics team is searching for a talented Analytics Engineer to support initiatives across the Canadian and LATAM Business. We are an exciting, fast-paced, and innovative team, leveraging industry-leading tools and best practices.

Working across AI, Data Engineering, Marketing, Sales and Product you will support an integrated plan to grow and scale the Canadian and LATAM roadmap.

Responsibilities include:

• Manage dev portal asset including regular security review, adding roles and access
• Work with US/India Data engineering team to resolve data issues (specially with tables created by data engineers)
• Support analysts to set up tables and pipelines, work with the superglue team to resolve pipeline incidents and trouble shoot
• Support analytics with routine list pulls for market targeting and segmentation
• Support Dashboard QA and upkeep to ensure accurate reporting
• Assists in promoting data usability and adoption, supports established workflows (paved paths), and aids in documentation tasks.
• Contributes to data architecture and design efforts, and ensures instrumentation and data quality standards align with data-by-design standards
• Support Data migration and integration
• Contributes to improving data quality and schema design
• Creates optimum database and table designs considering business requirements and schema evolution for data in-flight and at rest
• Explore and Profile Data, Visualize and Aggregate Data and Deliver Automated Processes
• Ensure data integrity, compliance and governance
• Applies advanced visualization and data aggregation techniques to enhance understanding and drive insights based on the BI paved path
• Implements automation to streamline processes, promotes sustainable practices, and drives data literacy that aligns with the governance process

Skills:

• 3-4 years of experience working in data, analytics, engineering, or a related field.
• Experience with building or managing a data pipeline in production. Familiar with data SLOs, validation, and pipeline health best practices.
• Experience in migration from large monolith tables to domain-specific entities derived from microservices.
• Highly proficient in SQL, Tableau, Qlik (Strong Preference).
• Experience with programming languages including R or Python.
• Strong proficiency in data tools such as Databricks, dbt, and cloud technologies such as AWS and GCP.
• QuickETL
• Bachelor's degree in Computer Science, Statistics, Economics, Mathematics, Data Analytics, Finance, Advanced Analytics preferred or equivalent work experience

Conceptual Understanding & Soft Skills:

• Solid understanding of normalization, schema evolution, and transitive dependencies.
• Familiarity with data handling concepts (Loading and Transforming Data).
• Excellent problem-solving skills and end-to-end quantitative thinking.
• Excellent project management skills, with the ability to work effectively with cross-functional teams and manage multiple projects simultaneously.
• Ability to manage through ambiguity in a high-paced growth environment.
• Great communication skills: Demonstrated ability to explain complex technical issues to both technical and non-technical audiences.