Business Intelligence Analyst

Finance Remote - Canada Ottawa, Ontario Montreal, QC


Description

Position at J2 Cloud Services

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

 

Responsibilities

  • Utilize business intelligence expertise, business knowledge and technical skills to successfully deliver Business Intelligence solutions that help solve business challenges.
  • 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.
  • To analyze, design, test, and code BI front end applications and back-end engines according to user requirements.
  • To participate in the end-to-end lifecycle of BI implementations including business analysis, design, development, deployment and continuous improvement.
  • Mine databases and other data sources for critical business insights as needs arise.
  • Document technical standards, build and maintain a comprehensive data dictionary. Work with departments to understand their business intelligence and data needs.

Requirements:

  • 5+ years of experience in a Business Intelligence/Reporting Analyst role.
  • 3+ years of knowledge and experience using database systems and SQL.
  • 3+ years of experience using data warehouses and BI solutions.
  • Experience in analysis and reporting with large complex data structures.
  • Ability to manage data from multiple data sources including MySQL, MS SQL, 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.
  • 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.
  • Strong organizational skills and excellent attention to detail.
  • Experience working in a team-oriented, collaborative 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
  • Prior or current experience working within a telecommunications
#J2CloudServices
#LI-MW1
#LI-Remote