Data Engineer at OneLocal

OneLocal is a leading provider of AI-powered digital marketing solutions for small and medium-sized businesses. We are committed to helping SMBs grow by providing easy-to-use, affordable, and effective marketing tools. From websites and SEO to reviews, advertising, social media, and more, our cloud-based platform offers a suite of interconnected tools that streamline operations and facilitate seamless customer communication. Leveraging structured and unstructured data, we power our own AI capabilities to automate client interactions, generate engaging content, and streamline information workflows.

We are looking for talented and passionate individuals to embed the latest AI technology into our platform. We pride ourselves in our open and dynamic culture, our diversity, and being committed to a workplace where we all feel that we can be ourselves.

We are looking for a Data Engineer to join our growing team. 

What You’ll Be Doing

• Automate manual processes through SQL, python, etc.
• Define solutions for using, extracting, and manipulating data as driven by the business need for knowledge and decision-making.
• Analyze documentation and propose data extraction solutions
• Write code that uses APIs to download and upload data
• Understand the nuances of the analysis required
• Explain the complexities involved with data extraction to analysts
• Stay up to date on the latest industry news and analysis techniques
• Assist in tagging and data infrastructure design
• Lead the analysis of digital data using Google Analytics to track website and mobile app performance
• Create engaging and interactive data visualizations that make numbers meaningful
• Use analytics tools like Google Analytics to create interactive and compelling dashboards and reports that provide clients actionable insights
• Conduct journey analysis to map out customer experiences and identify opportunities for improvement
• Implement and manage tags using platforms like GTM 
• Implement A/B tests to identify opportunities for improvement

What You Bring

• 2-4 years of experience in digital marketing analytics
• 2-4 years of experience using SQL, python, or working with APIs
• 2-4 years of experience designing ETL solutions
• A Bachelor’s or Master’s degree in a relevant field (Statistics, Mathematics, Computer Science, or Business—anything that made you fall in love with numbers)
• Experience with data visualization programs like Tableau (you can turn a spreadsheet into a masterpiece)
• Hands-on experience with Google Analytics (you know your bounce rate from your conversion rate)
• Familiarity with tag management platforms (GTM, you’re the tag whisperer)
• Experience working with Google’s data storage tools (Google BigQuery)
• Data savvy individual with good knowledge and hands-on experience in SQL queries. We need a person who understands database components like schemas, tables, stored procedures, triggers, DDM and DDL commands, and data management.
• Salesforce Knowledge

General Requirements

• English proficiency is a must. Being a remote team we favor asynchronous written communication; it's important you can communicate your ideas clearly as you will be interacting with other English-speaking coworkers.
• Ability to learn and adapt quickly; there will be many uncertainties and questions that will come up and part of your job will be to do the research, present options, and execute.

Why You’ll Love Working Here:

• The opportunity to have a major impact at a growing company that is helping small and medium sized businesses grow their digital presence
• Remote first: We have committed to a remote-first/distributed team work environment with access to a co-working space in Toronto
• Paid vacation + paid personal days
• Virtual social events: coffee chats with your colleagues and weekly happy hours!

At OneLocal, we are committed to building and fostering an environment where our employees feel included, valued, and heard. Our belief is that a strong commitment to diversity and inclusion enables us to truly create the best company culture possible. We strongly encourage applications from candidates of all backgrounds, experience, and perspectives regardless of race, gender, sexual orientation, marital status, age, citizenship, disability, and national origin.