Econolite logo

Senior Consolidation and Reporting Analyst

Salary
CA$100K–CA$120K
Hiring from
Canada, United States
Work type
Hybrid
Posted

625,707 remote jobs, straight from company career pages

100% free · New jobs every minute

Show job description

Econolite® is an innovator of Intelligent Transportation System (ITS) solutions, products, and services. Our technology is helping save lives and making the Smart City a reality. If you want to be at the forefront of this intelligent technology revolution, we want to talk to you about being part of our team. Econolite is committed to employing the best talent that will make significant contributions to building a safer, connected world.

Econolite’s ITS solutions ease traffic congestion, provide safer mobility, and improve quality of life. As the one-stop-shop leader for traffic management systems, sensor products, and services, Econolite is committed to the advancement of connected and autonomous vehicles, smart cities, and cybersecurity.


Senior Finance Systems Analyst


LOCATION: Markham, Ontario, Canada / USA Remote

Role Overview The Senior Finance Systems Analyst is a data storyteller responsible for turning raw data into the insights that drive our business strategy. In this role, you will own the end-to-end data pipeline, from extracting large datasets out of Microsoft Dynamics to building the Power BI dashboards used by senior leadership. Your primary focus will be providing the analytical backbone for monthly financial reviews and long-term forecasting.


Core Responsibilities

Data Engineering & Visualization

  • End-to-End Dashboard Development: Design and deploy sophisticated Self-Service Power BI reports that transform complex data into intuitive, high-impact visuals for executive decision-making.
  • Advanced Data Modeling: Architect scalable data models within Power BI, ensuring optimal performance when processing data from disparate sources.
  • DAX & Power Query Mastery: Write complex DAX measures for custom financial calculations and utilize Power Query (M) to clean and transform source data into usable formats.
  • Mobile & Cloud Optimization: Manage the deployment of reports to the Power BI Service, including configuring scheduled refreshes, mobile views, and row-level security.

Financial Insight & Forecasting

  • Monthly Financial Review (MFR) Automation: Transition the current MFR process from manual spreadsheets to automated Power BI reports, reducing the monthly reporting cycle time.
  • Trend & Variance Analysis: Use historical data from Microsoft Dynamics to identify patterns in revenue and margin, highlighting significant variances between actuals and budgets.

Data Governance

  • ERP Data Extraction Architecture: Develop and maintain the logic required to extract high-integrity data from Microsoft Dynamics, ensuring the reporting layer stays synced with the system of record.
  • Security & Compliance: Implement and monitor data security protocols, such as Row-Level Security (RLS), to ensure users only see the financial data relevant to their specific role or region.
  • Integration Management: Oversee the merging of data from secondary sources (e.g., external market data or legacy spreadsheets) into the primary Dynamics-based reporting environment.


Required Qualifications

Technical Skills

  • Power BI Expert: Mastery of DAX, Power Query, and Power BI Service. Experience with row-level security and workspace management.
  • Systems: Experience extracting and manipulating data from Microsoft Dynamics environments.
  • Data Fluency: SQL skills for querying and joining large, complex datasets.

Experience & Education

  • Bachelor’s degree in Data Analytics, Business Administration, Finance, or a related quantitative field.
  • 5+ years of professional experience in a dedicated BI or Data Analysis role.
  • Knowledge of financial principles (P&L, margins, and Capex/Opeх).

Soft Skills

  • Visual Communication: A keen eye for data visualization best practices and dashboard design.
  • Problem Solving: Ability to navigate ambiguous data requests and find creative technical solutions.
  • Stakeholder Management: Comfortable presenting data findings to senior management and tailoring the message to the audience.


PRE-EMPLOYMENT

All candidates who accept employment will be subject to a background investigation and drug screening. For applicable roles, candidates who accept employment will also be subject to a Motor Vehicle/Driving Record screening.


COMPENSATION

The base pay range for this full-time exempt position is $100,000.00 - $120,000.00 per year plus benefits. Pay ranges are determined by various factors, including role, experience, and location. The pay range displayed reflects the minimum and maximum target for new hire base pay rates for this position. Within the range, actual individual compensation is determined by various factors, including location, job-related skills, experience, and relevant education or training.


BENEFITS

This role is eligible for benefits: weekly pay, weekly PTO accrual, paid holidays. Various medical plans, dental, vision, flexible spending accounts, direct deposit. Basic life, LTD, 401k discretionary match. Other voluntary benefits include: identity theft protection.


DISCLAIMER

The above statements are intended to indicate the general nature and level of work performed by employees within this classification. They are not designed to contain or be interpreted as an exhaustive list of all duties, responsibilities, skills, and qualifications required of employees assigned to this job.

We conform to all the laws, statutes, and regulations concerning equal employment opportunities and affirmative action. We strongly encourage women, minorities, individuals with disabilities and veterans to apply to all of our job openings. We are an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, gender identity, marital status, lactation, ancestry/national origin, citizenship, age, disability, arrest and court records, military & veteran's status, Genetic Information & Testing, Family & Medical Leave, or any other classification protected by state or federal law.

We prohibit Retaliation against individuals who bring forth any complaint, orally or in writing, to the employer or the government, or against any individuals who assist or participate in the investigation of any complaint or otherwise oppose discrimination.

An Equal Opportunity Employer - Non-Smoking Facility


Similar jobs

Apply for this job100% free