Role Description
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.
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/Opex).
-
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.
Requirements
-
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.