CRM Jobs - Business Analyst II, 25601

at Apex Systems
Location Menlo Park, CA
Date Posted August 17, 2019
Category Default
Job Type Contractor



We are seeking an individual to build business intelligence (BI) dashboards for the SP&O function leveraging data. This person will deliver workable and efficient dashboards, automated reports, scattergrams, bar charts, pie charts, etc in Unidash and/or Tableau to enable goals and business performance tracking for the Media Partnerships organization.

This person will be interfacing with SP&O, data engineering, data science, possible key end users, and will need to be able to understand back end database structure, unidash and tableau interface, and requirements developed as part of the project. This person must display the ability to develop complex visualizations with filters, graphs, etc. They should have previous coding/scripting language experience


•           Design, develop and maintain BI and reporting solutions (e.g. reports, dashboards and self-service solutions) to provide better insights into data and enable goals tracking

•           Work with stakeholders to understand, interpret and analyze business needs and turn these requirements into value-add BI/reporting solutions

•           Unit test reports to verify that it meets the business requirements and the data is accurate

•           Identify, analyze and troubleshoot data issues, exceptions and discrepancies

•           Aggregate data from multiple data sources in an efficient manner

•           Support efforts to ensure data quality, integrity and security

•           Provide support on data and data platform related issues

•           Monitor performance and completions of automated processes and jobs

Work experience, skills and education

•           Bachelor's degree in computer information systems, computer science, finance, analytics or business. Equivalent work experience with SQL/BI/report development may be substituted for education.

•           Experience in database design, data analysis and reporting

•           Experience in writing complex SQL queries and stored procedures

•           Knowledge of data governance, data management, data modeling, data cleansing, data extraction and transformation, data analysis, data migration, data integration and data mapping

•           Experience building reports with report builder tools

•           Experience with a scripting/templating language (ex. Python, JavaScript, JINJA)

•           Demonstrated experience building dashboards with Business Intelligence tools (e.g. Unidash, Tableau)

•           Work independently, prioritize tasks in a multi-task fast paced environment.

•           Passion for solving complex business problems by designing high quality, elegant but simple solutions


•           BA/BS in Engineering, Statistics/Math, Business or related field

•           5+ years of work experience in Analytics, or 3+ years experience with MBA/Master's degree

•           2+ years of experience in SQL

•           Experience with a scripting/templating language (ex. Python, JavaScript, JINJA)

•           Demonstrated experience problem solving and providing business insights and recommendations from data

•           Demonstrated experience in presenting technical content across different stakeholder audiences

•           Excel, Unidash and Tableau experience

•           Experience or familiarity with CRM platforms (ex. Salesforce, Oracle CRM, SAP CRM)

EEO Employer

Apex 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 844-463-6178