Sorry, this listing is no longer accepting applications. Don’t worry, we have more awesome opportunities and internships for you.

Senior Web Analytics Engineer/ Report Developer

MITSIX

Senior Web Analytics Engineer/ Report Developer

Oakland, CA
Full Time
Paid
  • Responsibilities

     

     

    currently seeking a Web Analytics and Report Developer to be a part of a high-performance Agile Metrics, Analytics and Reporting Team (MART).

    The ideal candidate is a great team player, with a minimum of 5 years of database development, and will show interest and have been exposed to a multitude of technologies. She/he must have excellent analytical skills with experience in working with web analytics tools, writing SQL queries, setting up user engagement tracking with Google Tag Manager (GTM), and proficient in creating reports with Tableau.

    This role requires flexibility to switch from troubleshooting data discrepancies one day, to work in Google Analytics the next and, create and present a great interactive visual in Tableau the following day; and, still come out smiling.

    The MART team loves what they do and is looking for someone who equally shares the joy and passion of working with data.

    Principal Responsibilities:

    • Strong understanding of metrics, dimensions, and reports in web analytics tools like Google Analytics and Firebase
    • Implement web analytics tracking using Google Tag Manager (including custom js tags)
    • Extremely strong database skills (MySQL, SQL Server)
    • Database development, querying, reporting and data migration
    • Develop complex SQL queries, stored procedures, and SSIS packages
    • Write, optimize, and tune complex SQL scripts
    • Proven ability writing and developing reports in Tableau
    • Must have a thorough knowledge of, and experience building ETL jobs utilizing SSIS packages for data import, export, normalization, and manipulation
    • Meet with business experts to analyze and document requirements from a database perspective
    • Building customized interactive reports and dashboards, report scheduling in Tableau Server
    • Establish and maintain working relationships with technical and architectural team members across the technology organization

    Minimum Requirements:

    • 5+ years of experience in relational database development or administration in a commercial enterprise setting
    • B.S. in Computer Science, Mathematics, or Engineering or equivalent work experience
    • 2+ year experience in web analytics implementation and reporting
    • Must demonstrate a clear understanding of the logical and physical database design and data normalization concepts
    • Must have extensive hands-on experience with MS SQL Server 2016 SSIS, MS SQL Server 2016, SSRS
    • Excellent, proven troubleshooting and problem resolution skills
    • Tableau: 3 years (Required)
    • Tableau Server: 2 years