Data Analyst, Mechanicsville, VA, US

Intellibee; Mechanicsville (VA); On-site; USD 120,000 - 150,000; Full time

Benefits offered by this job

Long-Term Stability

Comprehensive Health Coverage

Future Planning 401(k)

Green Card Support

Job summary

IntelliBee is seeking a Financial Analytics role focused on Azure cloud spend and on‑prem workloads. The candidate will build Power BI dashboards, analyze IT costs, and collaborate with cloud, I&O, and finance teams to optimize spend and forecast capacity.

Strong data analytics, Azure costing knowledge, and experience with Apptio/SharePoint are essential for driving FinOps initiatives and accurate reporting.

Qualifications

• BSc/BA degree in finance, data analytics, or related field; strong analytical skills.
• Advanced Power BI skills (Power Query, DAX) and Excel proficiency required.
• Experience with data modeling and consolidating data from multiple sources.
• Familiarity with Azure cost management, Apptio, and cloud billing structures.
• Ability to translate complex data into actionable insights for teams.

Responsibilities

• Analyze IT financial data across Azure and VITA environments, including consumption and chargeback models.
• Develop and maintain Power BI dashboards to visualize cost trends and workload impacts.
• Perform variance analysis on monthly/annual IT spend and identify savings opportunities.
• Maintain datasets from Apptio, Azure Portal, and SharePoint to ensure accuracy.
• Document processes and procedures for financial reporting and analysis.
• Collaborate with cloud, I&O, and finance stakeholders to align cost models with realities.
• Model server cost scenarios to support Azure migration planning and capacity forecasting.
• Contribute to FinOps strategy by highlighting cost drivers and utilization patterns.

Skills

Power BI

Advanced Excel

Data modeling

Azure cost management

Apptio

Cloud billing

Cost modeling

Financial analysis

Server migration

Education

Bachelor’s degree in Finance, Data Analytics, Information Systems, or related field

Tools

Azure Portal

Apptio

SharePoint

Job description

This role is pivotal in analyzing, modeling, and forecasting financial data related to Azure cloud services and on-premises data center workloads. The ideal candidate combines financial acumen with strong data analytics skills to support strategic decision-making and cost optimization initiatives.

Key Responsibilities:

• Analyze and interpret IT financial data across Azure and VITA environments, including consumption, billing, and chargeback models.
• Develop and maintain Power BI dashboards and reports to visualize cost trends, server migration impacts, and workload optimization opportunities.
• Perform variance analysis on monthly and annual IT spend, identifying anomalies and opportunities for savings.
• Manually maintain and enhance datasets from Apptio, Azure Portal, and SharePoint sources to ensure accuracy and completeness.
• Document processes and procedures for financial reporting and analysis
• Collaborate with the technical cloud team, I&O team and finance stakeholders to align cost models with operational realities.
• Support Azure migration planning by modeling server cost scenarios and forecasting reserve capacity needs.
• Contribute to FinOps strategy development by providing insights on cost drivers and utilization patterns.

Required Skills & Qualifications:

• Bachelor’s degree in Finance, Data Analytics, Information Systems, or related field.
• Advanced level of proficiency in Power BI, including Power Query and DAX, Excel (advanced), and data visualization best practices.
• Some data modeling and data manipulation skills to maintain data sets from multiple, heterogenous sources
• High familiarity with Azure cost management, Apptio, and cloud billing structures.
• Understanding of server migration strategies and workload cost modeling.
• Ability to translate technical data into insights for technical teams and managers

Preferred Qualifications:

• FinOps certification or training.
• Experience with Azure Reserved Instances and Just-In-Time (JIT) capacity planning.
• Knowledge of enterprise architecture and strategic IT planning frameworks.

Skill Matrix:

• Bachelor’s degree in Finance, Data Analytics, Information Systems, or related field. Required 4 Years
• Advanced level of proficiency in Power BI, including Power Query and DAX, Excel (advanced), and data visualization best practices. Required 6 Years
• Some data modeling and data manipulation skills to maintain data sets from multiple, heterogenous sources Required 5 Years
• High familiarity with Azure cost management, Apptio, and cloud billing structures. Required 5 Years
• Understanding of server migration strategies and workload cost modeling. Required 5 Years
• Ability to translate technical data into insights for technical teams and managers Required 5 Years
• Ability to work independently and apply critical thinking to analyze complex financial data and develop actionable recommendations. Required 4 Years
• Proficiency in Power BI, including independently updating data, performing queries, and managing and analyzing datasets with little to no assistance. Required 6 Years
• Ability to translate complex data into clear, accurate, and actionable information for leadership and decision-making. Required 4 Years

Benefits at IntelliBee

• Long-Term Stability: Join us on a multi-year opportunities with room to grow.
• Comprehensive Health Coverage: Access quality healthcare benefits to keep you and your family well.
• Future Planning: Enroll in our 401(k) program and invest in your financial security.
• GC Assistance: We support immediate Green Card processing, if required.