Analyst, Data Architecture

StackAdapt is the leading technology company that empowers marketers to reach, engage, and convert audiences with precision. With 465 billion automated optimizations per second, the AI-powered StackAdapt Marketing Platform seamlessly connects brand and performance marketing to drive measurable results across the entire customer journey. The most forward-thinking marketers choose StackAdapt to orchestrate high-impact campaigns across programmatic advertising and marketing channels. We're looking for an Analyst to join our Data Architecture team. This role sits within our Analytics and Reporting Insights team under the greater Revenue organization. In this role, you will manage data requests, improve data pipelines, and deliver solutions that enhance both internal efficiency and client outcomes. This role blends technical hands-on work with business collaboration. You’ll partner with analytics, product, engineering and business stakeholders to design pipelines, optimize data models, and set up the foundation for scalable insights. StackAdapt is a Remote First company, we are open to candidates located anywhere in Canada for this position. What You'll Be Doing Manage standard data and reporting requests from internal teams with accuracy and speed. Build and optimize data pipelines and transformations using SQL, Python and orchestration tools like Kestra. Collaborate with analytics and business teams to understand data requirements and translate them into scalable solutions. Ensure data quality, governance, and consistency across reporting and analytics environments. Contribute to the team’s AI initiatives by preparing structured datasets for modeling and experimentation. Support visualization and reporting efforts in Tableau/ThoughtSpot, enabling self-serve access to business teams. Proactively identify opportunities to improve data efficiency, reliability, and usability. Establish and document data architecture standards and best practices for reusability and consistency. Support peer learning through documentation, code reviews, and sharing of best practices within the data team. What You'll Bring to the Table 2-3+ years experience in Business Intelligence Engineering, Data Engineering, Data Analysis or Data Science roles in a fast moving, high impact software or technology environment. Previous experience building data pipelines and analyzing large datasets to solve problems. Advanced SQL skills including complex joins and window functions with experience in large-scale data warehousing (Snowflake, Redshift, or BigQuery). Proficiency in Python for data processing and automation. Hands-on experience with workflow orchestration (Airflow or equivalent). Understanding of data modeling best practices and query optimization. Strong problem-solving skills with attention to detail and data accuracy. Comfortable collaborating across functions to identify data analytics problems and execute solutions with technical rigor and data-driven insights. Familiarity with modern ML and AI data workflows, from feature engineering to preparing structured and unstructured data for downstream models, including emerging use cases involving LLMs or vector databases. Exposure to BI tools like Tableau (or similar) is a strong asset. Strong understanding of data in digital marketing and programmatic environments, including campaign, audience, and attribution data models is a strong asset. StackAdapter's Enjoy Highly competitive salary Retirement/ 401K/ Pension Savings globally Competitive Paid time off packages including birthday's off Access to a comprehensive mental health care platform Health benefits from day one of employment Work from home reimbursements Optional global WeWork membership for those who want a change from their home office and hubs in London and Toronto Robust training and onboarding program Coverage and support of personal development initiatives (conferences, courses, books etc) Access to StackAdapt programmatic courses and certifications to support continuous learning An awesome parental leave program A friendly, welcoming, and supportive culture Our social and team events StackAdapt is a diverse and inclusive team of collaborative, hardworking individuals trying to make a dent in the universe. No matter who you are, where you are from, who you love, follow in faith, disability (or superpower) status, ethnicity, or the gender you identify with (if you’re comfortable, let us know your pronouns), you are welcome at StackAdapt. If you have any requests or requirements to support you throughout any part of the interview process, please let our Talent team know. About StackAdapt Ad Age Best Places to Work 2024 G2 Top Software and Top Marketing and Advertising Product for 2024 Campaign’s Best Places to Work 2023 for the UK 2024 Best Workplaces for Women and in Canada by Great Place to Work® #1 DSP on G2 and leader in a number of categories including Cross-Channel Advertising Seniority Level Mid-Senior level Employment Type Full-time Job Function Information Technology Industries Technology, Information and Internet #J-18808-Ljbffr