Junior Commercial Analyst

BI sits at the heart of the commercial organization, aligning systems, departments, and processes while delivering best-in-class analytics and insights. This team is focused on increasing growth and efficiency via data driven decisioning, systems alignment and innovation, increased commercial productivity and end to end process and connectivity. These goals will be achieved through actionable dashboards, visualizations, reports and insights, predictive analytics for forecasting, advanced utilization of systems, increased automation, process innovation and education, all underpinned by a unified strategy across the commercial organization and beyond.

This role will be integral to the expansion of the analytical function and will be responsible for helping to implement commercial data, analytics and reporting strategy across MiQ. This role requires an individual with good experience with data visualization tools, excel, data management, data flows and SQL coding. A problem solver with a growth mindset is required and a working knowledge of Enterprise level CRM, ERP, Data visualization and AI tools is preferred.

WHO YOU ARE:

We love different personalities at MiQ and strive to build teams constructed with diverse backgrounds and inclusive points of view. That said, we firmly believe that our values make us stronger and we look for people who share our values below.

• Passion – We love and live what we do.
• Determination – We always find a way to ‘figure it out’.
• Unity – We hold each other accountable. We win and lose as a team.
• Agility – We anticipate the unexpected, embrace and adapt to change.
• Courage – We dare to think unconventionally.

WHAT YOU’LL BE DOING:

You will be the bridge between the data engineers and the rest of the business, facilitating the reporting needs, communicating those needs back to the data team and downing the delivery of the reporting requested. Working on a range of revenue focused projects including automation and streamlining of forecasting process, pipeline analysis, revenue intelligence, goal setting and tracking, insights and reporting.

Key areas of focus:

• Commercial Dashboarding, Reporting and insights
• Pipeline and Sales Cycle Reporting and Analysis
• Data driven forecasting of revenue and gross profit (through statistical models)
• Data quality, accuracy & systems alignment
• Support Commercial BI Manager & broader Rev Ops team on key projects
• Ad Hoc commercial data / analytics / insights requests

In the role you will be accountable for, but not limited to, the following:  

• Delivery
  • Create repeatable revenue and profit analysis, insight and recommendations.
  • Creation of Dashboards, visualizations and custom reports
  • Enrich commercial intelligence via the addition of data sets/metrics e.g. commercial deals, retention and churn, quotas, activity tracking
  • Automate the quarterly & monthly forecasting process.
  • Own, maintain and report on Seller Quotas, Pipeline forecast reports, win rates, retention, Regional Forecasting, Commercial deals.
  • Create technical documentation
  • Deliver ad hoc reporting / insight / analysis for Commercial Departments / Leadership
  • Accomplishing tasks on time and to a high quality, managing different deadlines and priorities.
    
    
• Project Management
  • Drive on time completion of key projects and manage stakeholders and management.
  • Identify business requirements and work with stakeholders throughout the project.
  • Drive adoption of new dashboards, processes, or systems.
  • Staying focused and contributing to projects. Organizing stakeholders and multiple milestones
    
    
• Internal Collaboration
  • Navigate established relationships with key stakeholders to ensure alignment and updating on key projects.
  • Work closely with Revenue Operations, Commercial teams (Sales, Client Success, Trading), Product, Marketing and Finance.
  • Work with Global BI and FP&A teams to ensure data quality of projects / workstreams
  • Working with internal stakeholders, building relationships and working across differences to find solutions
    
    
• Communication
  • Communicate proactively with stakeholders throughout the project to gather inputs, keep them updated, and coordinate.
  • Deliver training to key users across multiple departments
  • Regularly seek feedback from stakeholders to drive continuous improvement.
  • Communicate and present insights and analytics that are actionable and scalable
  • Strong ability to document any/all established work
  • Great communicator to external partners/clients or internal stakeholders and an understanding of different audiences and requirements.
    
    
• Innovation
  • Use world-class visualisation tools to deliver analytics that aid forecasting and predictive modelling.
  • Always look to automate existing processes and workflows.
  • Explore new strategies for transforming manual processes into digital solutions (e.g. A.I. utilization)
  • Embracing change and actively promoting new ideas

REQUIREMENTS FOR ROLE:

• Passionate about data, analytics and technology
• Ability to translate non-technical needs into technical specifications
• Good communicator
• Can demonstrate having used data to drive action
• MS Excel skills, (including pivot tables, look ups, and other formulas etc.)
• Data visualisation experience in a BI visualisation tool (Experience in developing Dashboards, Excel models, PowerPoint, Slack and other real-time notifications)
• Proficiency in SQL
• Experience with enterprise level CRM and/or ERP platforms (e.g. Salesforce)
• Knowledge of data governance, including data quality, security, and compliance.
• Familiarity with cloud platforms (e.g., AWS, Google Cloud, Azure) and cloud-based data storage (e.g., S3, Google Cloud Storage)
• Ability to build and maintain reliable data pipelines to integrate data from multiple sources.
• Experience working in Sales or Revenue Operations preferred

NICE TO HAVES:

• Experience with programming languages such as Python or R
• Experience working with AI platforms
• Experience with data modelling and data architecture design
• An understanding of machine learning algorithms for regression, classification, clustering, and time series forecasting

WHO WE ARE:

We’re MiQ, a programmatic media partner for marketers and agencies. We connect data from multiple sources to do interesting, exciting, business-problem-solving things for our clients. We’re experts in data science, analytics and programmatic trading, and we’re always ready to react and solve challenges quickly, to make sure our clients are always spending their media investments on the right things in the right places.

Our business keeps growing and our company keeps getting better because we keep hiring smart new people who are not afraid to challenge the “norm”. Infact, we encourage it!

If after reading all of this, you are as excited as we are, we’d love to hear from you.