Business Intelligence Analyst

Data Analytics Remote - Canada


Description

Business Intelligence Analyst

Ziff Davis is looking for a natural problem solver with a strong interest in fulfilling the business' expanding appetite for data, and helping define our data analytics roadmap. This role will be involved in all parts of the Business Intelligence process, from data acquisition to final presentation. The analyst will develop reports and self-service tools for internal customers via Domo from data housed in log files, Vertica, MySQL, SQL Server, and Redshift databases, S3 Buckets, Redshift, and 3rd party API integrations, and MS SQL Server databases to serve both internal and external customers.

 Responsibilities 

  • Act as the subject matter expert for accessing and analyzing diverse, unstructured data across the Ziff Davis product platforms using combinations of analytic software, especially Domo and Pendo.
  • Utilize business intelligence expertise, business knowledge and technical skills to successfully deliver solutions that help solve business challenges.
  • Work cross-functionally with Data Engineering, Product, Marketing and Sales leadership to define the business requirements for data collection, analysis and infrastructure needs.
  • Provide direction, expertise, and end-user training oriented toward self-service reporting portals.
  • Assess the impact of production system changes to the existing analytics and implement changes to data warehouse ETL and reporting code to ensure consistent and accurate reporting.
  • Analyze, design, and test BI front-end deployment and back-end ETL processes according to user requirements.
  • Document technical standards, build and maintain a comprehensive data dictionary.

Requirements:

  • 5+ years of experience in a Business Intelligence/Reporting Analyst role.
  • 3+ years of knowledge and experience using database systems, SQL, and ETL tools, especially Segment and Pentaho.
  • 3+ years of experience deploying data visualizations into BI solutions, especially Domo.
  • Experience in analysis and reporting with large, complex data structures.
  • Ability to manage data from multiple data sources including varying database platforms,  log files, Google Analytics, S3 Buckets, Salesforce, and API endpoints.
  • Experience working with structured and unstructured data from various sources and formats.
  • Passion and interest in Business Intelligence, Dashboards, Reports, Data-modeling, Data Warehouses, ETL Processes and Data-Integration.
  • Strong interpersonal and oral communication skills with ability to communicate ideas and solutions to non-technical users
  • Ability to maintain confidentiality with sensitive customer and internal information.
  • Highly self-motivated and directed with strong organizational skills and attention to detail.
  • Experience working in a team-oriented, collaborative, and remote environment.

Preferred Skills:

  • Experience with R, Python, or other data analysis languages
  • Exposure to Kanban and JIRA
  • Prior or current experience working within a SAAS environment
  • Professional experience using managed cloud services (AWS)
#Moz
#LI-Remote