Open Opportunities

Marketing Data Engineer/Analyst

We are a fast-growing company providing a suite of sales tax SaaS solutions for thousands of businesses worldwide. Our Sales & Marketing team is seeking a skilled and experienced data engineer to build and integrate scalable data pipelines and structures, enabling advanced analytics to accelerate growth and efficiency. You’ll take an active role in empowering marketers and leadership with information-rich data sources, using cutting-edge tools to consolidate data from across the organization and within our data warehouse.



Responsibilities:

  • Translate requirements from various internal business teams to deliver optimal data structures used to drive insightful, actionable reports and dashboards.
  • Plan and develop complex ETL processes extracting data from source systems and loading cleaned, transformed, and conformed data into our enterprise data warehouse
  • Ensure data integrity by validating against existing reports and source data
  • Work cross functionally with our Data Services and Data Science teams to architect and implement optimized data pipelines
  • Create dimensional models that meet both immediate analytical and reporting needs and also conform to long-term data strategy
  • Scope projects and provide estimates of work to be performed and timelines
  • Develop ETL specifications, source to target mappings, and other documentation required for ETL development and maintenance


Required:

  • Bachelor of Science degree in Computer Science or similar field
    5+ years’ experience in a data or software engineering role focused on data-heavy applications
  • Strong experience with ETL tools, preferably Talend, Wherescape and SSIS
    Track record of optimizing SQL scripts for performance in a data warehouse environment
  • Proficiency in dimensional modeling that enables analysts to seamlessly generate insights from data structures
  • Strong communication skills, specifically the ability to translate non-technical stakeholder requirements into data architecture that meets and/or exceeds current needs and long-term analytics goals
  • Experience working cross-functionally to identify ideal source data, share tools, plan data strategy, and collaborate on ETL pipelines that can serve the needs of multiple teams
  • Experience in optimizing scripts and dimensional modeling on big data platforms (Snowflake preferred, or Hadoop or Spark)
  • Experience with a functional/object-oriented scripting language like Python, Java, Scala, etc. for automating jobs
  • Ability to self-direct to seek information and solve problems
  • Rigorous attention to detail


Preferred:

  • Passion for integrating data and the technology behind it (especially for Big Data technologies)
  • Familiarity with CRM systems, specifically Salesforce
  • Knowledge of best practices for extracting data from systems such as Adobe Analytics and Eloqua
  • Experience with AWS cloud services such as EC2
  • Experience working in visual analysis tools such as Tableau