
Senior Consolidation and Reporting Analyst
Posted 1 day ago

Posted 1 day ago
This is a fully remote position, open to applicants in United States, +1 more country.
• 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.
• 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.
• 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.
Center for Health Care Strategies
Code and Theory
Countrywide Construction
Epicor
Get handpicked remote jobs straight to your inbox weekly.