Analytics Engineer

Our success is reliant on building teams that include people from different backgrounds and experiences who can elevate assumptions and ideas with fresh perspectives. We're dedicated to hiring the whole human, not just a resume. To that end, we look for a diverse pool of applicants-including those from historically marginalized groups. We would like to invite you to apply even if you don't think you meet all of the requirements listed below. We don't want a few lines in a job description to get between us and the opportunity to meet you.
The RoleAs an Analytics Engineer at Outreach.io, you will drive the success of Outreach’s Analytics and Operational programs through the production, documentation, and curation of certified data sources and models. You practice scalable coding practices, write efficient SQL, and document your work so that future stakeholders will already have their questions answered. You are the “T” in ELT (Extract-Load-Transform), and turn the data pipelines from our Data Engineering teams into useful models for our Analytics and self service Data Champions to adopt and answer their own business questions. 
Overall, you make Data at Outreach a more trusted, governed, and powerful asset for all employees.
About the TeamThe Analytics Engineering team is dedicated to the empowerment of all people through the use of scalable and trusted data sets. We drive alignment on core business metrics and enable other teams to experiment with novel operational metrics to track the business. The AE team is a subset of the Business Intelligence & Analytics team, and partners across the org to drive education and enablement for all employees.

Your Daily Adventures Will Include

• Model and document new datasets (both structured and semi-structured) to exploit the value therein across all our business units
• Partner with subject matter experts to document, align and automate business metrics that define success
• Work with Analysts to optimize their use of data, either through query reviews, modeling exercises, or dashboard audits
• Own the design, monitoring, and deployment of certified data sources on our reporting platforms and warehouses
• Insist on the highest standards for data reproducibility, audibility and compliance
• Serve as a subject matter expert for data strategy thought leadership and implementation across the business
• Enable non-BI&A team stakeholders to adopt data as part of their business and usual
• Implement data strategy in dbt models
• Be the subject matter expert and main point of contact for Tableau on premise to Cloud migration project

Our Vision of You

• Ability to communicate complex concepts in a clear and concise manner to audiences from fellow analysts to senior executive level. Experience working with business stakeholders for requirements gathering and documentation, and follow code documentation best practices.
• An effective storyteller with an emphasis on visual best practices and discoverability. Participates in the sharing of knowledge with Analytic and non-analytical teams alike.
• Familiar with Snowflake, dbt (core), airflow, Tableau and Strong SQL (Snowflake preferred) knowledge: 
• - Consistently combines data across systems and data warehouses
• - Has a solid understanding of relational databases
• - Follows best SQL practices with clear CTEs and avoids unnecessary joins and columns
• With guidance, model and document new datasets (both structured and semi-structured) that are applicable to a business partner.
• History of Query and Data Pipeline optimization.
• Knowledge of multi-dimensional data modeling.
• Ideal candidates also have experience with Python and knowledge of migration from server environment to a cloud based environment. 

Why You’ll Love It Here
● Highly competitive salary● Amazing working space with a running track on its roof● Flexible time off, 5 weeks of vacation, and 5 annual sick days● 4% employer supplemental pension monthly contribution● Private medical care for employee and spouse with Program Health Plus ● Life insurance at 2x annual salary● 5.000 CZK monthly allowance for meal vouchers, flexipasses and other personal expenses● 16 weeks of annual top up maternity leave pay or 12 weeks of fully paid paternity leave● Opportunity to be part of company success via the RSU program● Company-organized and personal paid volunteer days to support the community that supports us● Relocation package - support offered for foreign future employees and their families relocating to Prague● Diversity and inclusion programs that promote employee resource groups like OWN (Outreach Women's Network), AAPI, Rainbow (LGBTQIA+), Gender+, LatinX, Black Excellence, Disability Community, and Veterans● Employee referral bonuses to encourage the addition of great new people to the team● Fun company and team outings because we play just as hard as we work