08 Apr
Web Analytics/Reporting Consultant
California, Oakland , 94601 Oakland USA

The ideal candidate is a great team player, will have a minimum of 5 years of database development and will show interest and have been exposed to a multitude of technologies. She/He would 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. We need someone who wouldn't have a problem switching 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. We love what we do here and need someone who equally shares the joy and passion of working with data. If you are that person, we are looking for you!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, etc) • Database development, querying, reporting and data migration o 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 Your Qualifications: Minimum Requirements: • Must have 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 Preferred Skills/Previous Experience: • Must have a team-based attitude and be skilled at building constructive and effective relationships • Experience with agile software development life cycleEEO EmployerApex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or

Related jobs

Report job