Senior Consolidation and Reporting Analyst

Posted 1 day ago

This is a fully remote position, open to applicants in United States, +1 more country.

📋 Description

• Create and implement advanced Self-Service Power BI reports to facilitate executive decision-making.

• Design scalable data models within Power BI.

• Develop intricate DAX measures for specialized financial calculations.

• Utilize Power Query (M) to cleanse and transform source data.

• Oversee report deployment to the Power BI Service, which includes scheduled refreshes, mobile views, and row-level security management.

• Shift the monthly financial review process from manual spreadsheets to automated Power BI reports.

• Analyze historical data from Microsoft Dynamics to uncover revenue and margin trends.

• Emphasize notable discrepancies between actual figures and budgeted amounts.

• Create and sustain data extraction logic from Microsoft Dynamics.

• Enforce and supervise data security measures, including Row-Level Security.

• Manage the integration of additional data sources into the Dynamics-based reporting framework.


⛳️ Requirements

• Proficient in DAX, Power Query, and Power BI Service.

• Experience with row-level security and workspace management.

• Background in extracting and manipulating data from Microsoft Dynamics environments.

• SQL proficiency for querying and joining large, complex datasets.

• Bachelor’s degree in Data Analytics, Business Administration, Finance, or a related quantitative field.

• Over 5 years of professional experience in a focused BI or Data Analysis role.

• Understanding of financial principles, including P&L, margins, and CapEx/Opex.

• Strong attention to data visualization best practices and dashboard design.

• Ability to navigate ambiguous data requests and devise innovative technical solutions.

• Comfortable presenting data insights to senior management, tailoring the message to suit the audience.

• Candidates who accept employment will undergo a background investigation and drug screening.

• For relevant positions, candidates who accept employment will also be subject to a Motor Vehicle/Driving Record screening.


🏝️ Benefits

• Weekly pay.

• Weekly PTO accrual.

• Paid holidays.

• A variety of medical plans.

• Dental coverage.

• Vision coverage.

• Flexible spending accounts.

• Direct deposit.

• Basic life insurance.

• Long-term disability (LTD) coverage.

• 401k discretionary match.

• Identity theft protection.

People also viewed

Center for Health Care Strategies1 day ago

Research and Reporting Analyst

US flagFlorida OnlyFull-timeBusiness Intelligence Analyst$59.5k – $95.1k/year
ApplyView job
Code and Theory2 days ago

Associate Director – Operations Strategy, Business Intelligence

IN flagIndia OnlyFull-timeBusiness Intelligence Analyst
ApplyView job
Countrywide Construction2 days ago

Reporting Analyst

US flagUnited States OnlyFull-timeBusiness Intelligence Analyst
ApplyView job
Epicor2 days ago

Senior Business Intelligence Principal

AU flagAustralia OnlyFull-timeBusiness Intelligence Analyst
ApplyView job
Procore4 days ago

Senior Global Compensation System Analyst, Reporting & Insights

US flagTexas OnlyFull-timeBusiness Intelligence Analyst$90.4k – $124.3k/year
ApplyView job
Sutton National Group4 days ago

Statistical Reporting Analyst – P&C Insurance

US flagUnited States OnlyFull-timeBusiness Intelligence Analyst$75k – $90k/year
ApplyView job

Never miss a great job!

Get handpicked remote jobs straight to your inbox weekly.

Trusted by 7,400+ designers