Data Analyst 3
Integrated Resources, Mechanicsville, VA, United States
Title: Data Analyst 3
Location: Mechanicsville, VA 23116 (hybrid: 4 days onsite)
Job Duration: 2 months (Extension after June 30)
Position Summary:
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:
Skill
Required
Amount of Experience
Experience
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 5 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
Location: Mechanicsville, VA 23116 (hybrid: 4 days onsite)
Job Duration: 2 months (Extension after June 30)
Position Summary:
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:
Skill
Required
Amount of Experience
Experience
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 5 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