Business Analyst (Hybrid 3x per Week) chez OptConnect Management, LLC

Description

OptConnect, based in the heart of Silicon Slopes—Kaysville, Utah, is a leading provider of managed wireless connectivity for mission-critical IoT applications. Our innovative hardware, smart remote monitoring, and carrier integration power over 1 million active lines across thousands of customers. With the strategic acquisitions of PWS, M2MDataGlobal, and Capestone, we’ve expanded our global footprint and technical expertise.

Recognized on the Inc. 5000 list and honored as one of Utah Business Magazine’s Best Companies to Work For for multiple consecutive years, OptConnect is proud of our high-performance culture that blends innovation, collaboration, and a shared commitment to excellence. 

As we penetrate new markets and expand our product suite, we are constantly looking for smart, driven people to help us succeed. If you’d like to join our mission to connect the world, we look forward to hearing from you.

Position Overview

We are seeking a highly skilled and analytical Business Analyst to join our Data Analytics and Business Finance team. This company-wide role is focused on transforming data into actionable insights that support decision-making across multiple departments, including Finance, Operations, Sales, Marketing, and Customer Success. The ideal candidate has a passion for solving complex problems, deep experience working with BI tools and spreadsheets, and thrives in a dynamic, cross-functional environment.

You will be responsible for a wide range of projects/tasks, including:

• Partnering with stakeholders to define key business questions and deliver meaningful analysis.
• Developing dashboards, KPIs, and business models to track performance and identify opportunities.
• Supporting financial modeling, forecasting, and executive reporting.
• Managing data pipelines and ETL processes in collaboration with the DevOps and IT teams.

What You’ll Do: 

• Collaborate with cross-functional teams to gather and interpret business requirements for data analysis and reporting.
• Design and maintain interactive dashboards, reports, and visualizations using tools like Power BI or Tableau.
• Extract, clean, and transform data from various systems and sources to support consistent business intelligence.
• Perform in-depth data analysis to identify trends, variances, and business opportunities.
• Support executive decision-making by preparing concise summaries and visual presentations.
• Build predictive models and conduct scenario analyses to assess business outcomes.
• Contribute to data governance, quality assurance, and documentation best practices.
• Assist with financial planning and business forecasting efforts.
• Stay informed of industry trends and best practices in business intelligence and data analytics.

Requirements

• Bachelor’s degree in business analytics, statistics, computer science, finance, or a related field; or equivalent relevant experience.
• 4+ years of experience as a Business Analyst, BI Analyst, or Data Analyst, preferably in a SaaS, IoT, or technology-driven organization.
• Strong proficiency with Power BI, Tableau, or similar BI visualization tools.
• Advanced Excel skills, including pivot tables, macros, complex formulas, and data validation.
• Strong SQL skills for querying and manipulating relational data.
• Experience with ETL processes and tools.
• Knowledge of statistical modeling, data mining, and predictive analytics.
• Comfortable working with large data sets and managing data integrity.
• Familiarity with programming languages such as Python or R is a plus.
• Knowledge of AWS or other cloud platforms is a plus.
•  Experience working with NetSuite or another ERP system and HubSpot (or comparable CRM platform) for data integration, reporting, or process optimization. 

Desired Qualifications

• Strong business acumen and ability to translate data into strategic insights.
• Excellent communication and presentation skills, with experience conveying complex findings to non-technical stakeholders.
• Experience supporting Finance, Sales, or Operations teams with modeling and KPI tracking.
• Proactive and self-driven with a desire to innovate and improve processes.