Data Engineer, Business Intelligence & Analytics

Full Time
Toronto, ON, Canada
2 months ago
Movable Ink scales content personalization for marketers through data-activated content generation and AI decisioning. The world’s most innovative brands rely on Movable Ink to maximize revenue, simplify workflow and boost marketing agility. Headquartered in New York City with close to 600 employees, Movable Ink serves its global client base with operations throughout North America, Central America, Europe, Australia, and Japan.

As a Data Engineer, you will help drive the direction of our Data Warehouse, work hands-on with teammates across the organization to get access to relevant data, and empower teams to make data driven decisions about the direction of our business.  Movable Ink collects campaign data resulting from Billions of requests served each day.  Come and help us manage and make sense of the massive amount of data we’re ingesting!

 

Responsibilities:
  • Partner with other Data Engineers and other stakeholders to model ingested data into consumable objects tied to business/stakeholder need
  • Implement and test data pipelines
  • Document data lineage for transformation of data as it flows from source to target
  • Create comprehensive data products with well-defined SLAs
  • Partner with Analysts to build dashboards and reports in a BI tool
  • Partner with Software Engineers to build in-platform reports
  • Work with team to help administer various aspects of our data platform
  • Occasionally participate in “Show and Tell” events to demonstrate recent work
Qualifications:
  • 3+ years experience as a Data Engineer for a SaaS or SaaS-like company with a focus on Cloud-based Data Warehouse platforms (e.g. AWS Redshift, Google BigQuery, Snowflake).  We use AWS Redshift.
  • Experience with data modeling in a data warehouse environment (Kimball, Inmon, DataVault).  We use Kimball and DataVault 2.0
  • Experience with creating code-based data pipelines (we use Python and SQL) and orchestrating them with tools such Apache Airflow, Luigi, Dagster.  We use Airflow.
  • Experience building data pipelines from structured, unstructured, and semi-structured data.
  • Experience working with version control tools (e.g. git).  We use Git/Github.
  • Experience working within the Continuous Integration / Continuous Delivery (CI/CD) paradigm.  We use Gitlab CI/CD.
  • Experience working with Linux/BSD shell commands.  Our Linux-based servers run Ubuntu Linux, and our employee computers are Macbook Pros.
  • Experience with at least one Enterprise BI Tool (e.g. Tableau Server, QlikSense, etc.).  We use Tableau/Tableau Server on Linux.
  • Experience building data pipelines from APIs published by third party SaaS platforms. Some of the third-party SaaS platforms we need to extract data from are: Salesforce.com, Zendesk, Netsuite, Shortcut.
  • Strong documentation skills and in particular has experience documenting source-to-target mappings (STMs).
  • Experience working in an Agile environment

Studies have shown that women, communities of color, and historically underrepresented people are less likely to apply to jobs unless they meet every single qualification. We are committed to building a diverse and inclusive culture where all Inkers can thrive. If you’re excited about the role but don’t meet all of the abovementioned qualifications, we encourage you to apply. Our differences bring a breadth of knowledge and perspectives that makes us collectively stronger.

We welcome and employ people regardless of race, color, gender identity or expression, religion, genetic information, parental or pregnancy status, national origin, sexual orientation, age, citizenship, marital status, ethnicity, family or marital status, physical and mental ability, political affiliation, disability, Veteran status, or other protected characteristics. We are proud to be an equal opportunity employer.