Job description


Job Overview:

The Data Engineer role at Integrous is an integral member of our analytics team responsible for working with our clients to extract, integrate and transform their data to make it accessible and ready to be developed into visualizations using business intelligence tools. This role manages our cutting edge data stack, including FiveTran, Snowflake and Tableau to prepare fully integrated data sets that our visualization team can use to develop dashboards for internal and external clients. As a B2B demand generation agency, we have extensive marketing and sales performance data from many different platforms that must be joined together and normalized in order to develop always on, fresh data for our clients. This role also serves as a consultant to our clients to help enable their analytics team to leverage the data that our system provides to incorporate in their internal reporting. The Data Engineer works closely with our closed-loop system product team to design systems to get the data our clients need to fuel their business, and it works with the BI visual design team to build interactive dashboards for the internal and external execution teams.

The right candidate will be able to use our ETL tool and data warehouse (FiveTran and Snowflake) to aggregate all relevant data, and will possess advanced SQL skills to integrate data from multiple sources including Salesforce, Marketo, Pardot, Google Adwords, Bing, Facebook, LinkedIn and other media sources. Familiarity with the Salesforce data model is a major plus for this role, as are experience with media and web analytics platforms (especially Google products). Superior problem solving skills, impeccable attention to detail, and a passion for data are required traits for success in this role.

Responsibilities/ What You Will Do:

  • Managing the data tech stack, including the ETL and data warehouse
  • Setup and maintenance of data extraction and data collection processes
  • Joining, blending and cleansing data using SQL (and related languages)
  • Troubleshooting data. Finding points of failure in the data collection or sales process and working with the revenue operations team to implement solutions
  • Analyzing client data to identify opportunities for improvement within the sales and marketing programs
  • Developing innovative solutions to enable self-serve data cleansing, categorization and maintenance for our internal team and clients
  • Consulting with clients to enable them to use our data sets and data models to support their internal BI teams
. Requirements:

What You’ll Bring to the Team:

  • Minimum of 2 years of data integration and data engineering experience
  • Advanced SQL experience (R and Python are a plus)
  • Familiarity with the Salesforce and marketing automation platform data models
  • Deep experience working with relational databases
  • BI platform experience, with working knowledge of Tableau Desktop and Tableau Online is a big plus
  • Excellent analytics, critical thinking and problem solving skills
  • Excellent interpersonal and communication skills
  • Excellent project management experience
  • Keen interest in using data to drive business and marketing decisions for clients
  • Acute attention to detail and rigor around your work
  • Wants to be part of building an agency from the ground up with people who challenge you
  • Enjoys working directly with clients, consulting them on opportunities to embrace a data driven culture

Why we are Different:

We are the agency for people who love digital marketing and analytics but haven’t found a company that aligns with their values or don’t have the systems needed to deliver meaningful results. We are privately owned and are committed to being a different type of agency.

  • We have an inclusive, transparent and collaborative culture that includes everyone in defining and planning our future
  • We invest in our people to build the best marketers and data professionals in the business
  • We intentionally control our growth and only take new clients that align with our core values
  • We only sell projects and services that we know we are great at, and are happy to sacrifice short-terms gains to focus on building long-term trusted partnerships
  • We curate our client roster and resign clients if they don’t treat us as partners or if we aren’t able to do great work together
  • We have an unparalleled commitment to measurement and analytics and our team has all of the data they need at their fingertips to maximize performance
  • We have marketing automation and Salesforce admins on staff and work with our clients marketing and sales teams to ensure the leads we generate are worked effectively and we get the feedback we need to measure our success

What we offer:

  • Generous Profit Sharing
  • 401k Matching Program
  • Ample Time Off (17 days of PTO + 13 paid holidays)
  • Full Health, Dental and Vision coverage for Employee
  • Hybrid Work Environment
  • Education and Training Budget
  • Open communication and focus on creating an inclusive culture and environment.
  • Full COVID-19 vaccination required

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.