• ETL Developer / System Analyst

    Job Locations US-MA-Cambridge
    Category
    Marketing
  • Overview

    Fuel your intellectual curiosity and professional growth. Forrester is an idea company, where smart, motivated, curious people bring a diversity of opinions and the courage of their convictions to collaborate on ideas that change the course of business. Most of all, bring a point of view; here, every voice has value. At Forrester, you’ll work with innovative clients at emerging and established brands; these are the business and technology leaders we inspire and who inspire us. The Forrester experience is built on a singular, powerful purpose: to challenge thinking and lead change.

     

    About This Role:

    Forrester is looking for an ETL Developer/System Analyst to fill a critical role focusing on integrating the marketing technology stack, unlocking data silos for analytics, and automating critical data flows in our marketing automation process. This role will leverage technical expertise in database applications, API data integration, and extract, transform, and load (ETL) processes. You will work closely with business analysts, system architects, data analysts, and business stakeholders to scope, document, build, and maintain data flows that drive our marketing operations and analytics. 

    Responsibilities

    • Scope, build, monitor, and troubleshoot ETL processes.
    • Refine and automate report data flows for efficiency, speed, and stability.
    • Extract and load data using JDBC and OCI database connections as well as RESTful and Bulk API operations.
    • Execute different data analytics (joins, audits, correlation, etc.) to ensure the completeness, quality, and consistency of data used across systems.
    • Evaluate new marketing technologies to determine integration capabilities and ease of implementation into Forrester's system architecture. 
    • Play a key role in discovery, scoping, planning, and prioritization discussions that identify manual processes that automation can replace.
    • Adapt ETL processes to accommodate changes in source systems and new business user requirements.

    Qualifications

    • A B.S./M.S. in computer-related studies or comparable work experience.
    • Two-plus years’ experience writing high- and low-level technical specifications.
    • Two-plus years’ experience working with relational databases such as Oracle, MySQL, or SQL Server.
    • Two-plus years’ experience working with ETL tools such as DataStage, Lavastorm, Microsoft SSIS ETL, MuleSoft, Oracle Data Integrator, Talend, etc.
    • Two-plus years’ experience in leveraging RESTful API applications that involve integrating with web services in ETL processes.
    • Familiarity with standards such as WSDL, SOAP, XML, REST, JSON, SFTP, and HTTP required.
    • Integration knowledge of Salesforce, Google, Eloqua, ON24, Aventri, and Qualtrics is a plus.
    • Good understanding of data mining, modeling, and data warehousing concepts and techniques.
    • Good time management, multitasking, and written and verbal communication skills are required.

     

    Explore #ForresterLife on:

    YouTube

    Twitter

    Facebook

    Instagram

    LinkedIn

    Glassdoor

     

    FLSA Status:

    Exempt

     

    Forrester Research, Inc. is an Equal Opportunity/Affirmative Action Employer that is committed to equal employment opportunity for all qualified individuals without regard to race, color, religion, national origin, ancestry, sex, age, disability, sexual orientation, gender identity and expression, marital status, genetic information, military service, veteran status, or any other status protected by applicable law. Minorities, Women, Individuals with Disabilities, and Veterans are especially encouraged to apply.

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed

    Need help finding the right job?

    We can recommend jobs specifically for you! Click here to get started.