Jr Excel Reporting Analyst from ALTA IT Services
Fairfax, VA 22031
About the Job
Jr. Reporting Analyst – Excel
6 months contract w/good chance of extension or perm rollover
Location: Fairfax, VA - Primarily remote, but must be able to report to office as needed
W2 only / not available for C2C
ALTA is seeking an Excel Reporting Analyst to support a top healthcare client in the VA area!
PURPOSE:
Shape and execute reporting strategy for data collected. Help drive critical business decisions by analyzing metrics and designing reports. Communicate results to stakeholders and provide suggestions based on findings.
REQUIRED SKIILLS:
3-5+ years of experience in Data Reporting
Must have strong experience with Excel – pivot tables, Vlookups, filters, etc.
1-2+ years of T-SQL and other ETL experience
Familiarity with Access and other data analytics tools such as Power BI/MS 365
Experience with Data Connect ETL would be highly desired but not required
Power BI – nice to have but not required
Proficient with working with various data formats
Advanced communication and customer service skills
Energetic Team player and Self-Starter
Health insurance experience preferred (not required) Education Level: Bachelor's Degree
Education Details: Business Administration or related field
In lieu of a Bachelor's degree, an additional 4 years of relevant work experience is required in addition to the required work experience.
ESSENTIAL FUNCTIONS:
25% Collaborates with stakeholders to understand data needs to create reports that meets the needs of the business. Identifies functional requirements through process analysis, review of documents and procedures, and interviews and meetings with stakeholders. Occasionally works alongside Developers and the System Architects to use the requirements to design the system concept of operations from both business and technical perspectives.
25% Analyzes data and develops observations and findings based on analysis. Creates and test reports utilizing feedback and revisions into reporting products. Conducts quality control, communicates findings, and obtains sign-off from stakeholders to implement reports into production.
25% Prepares adhoc analysis, researches moderately complex issues, and develops reports in support of reporting requirements, analyzes and interprets data, and makes recommendations to improve reporting processes.
15% Works in collaboration with another Requirements/Business Analyst to conduct discussions in interviews and workgroups to capture and to develop requirements. Analyzes the requirements and manages the requirement changes. Supports business operations development and develops standard operating procedures.
10% Works alongside Developers and the Architect to use the requirements to design the system concept of operations from both business and technical perspectives.
6 months contract w/good chance of extension or perm rollover
Location: Fairfax, VA - Primarily remote, but must be able to report to office as needed
W2 only / not available for C2C
ALTA is seeking an Excel Reporting Analyst to support a top healthcare client in the VA area!
PURPOSE:
Shape and execute reporting strategy for data collected. Help drive critical business decisions by analyzing metrics and designing reports. Communicate results to stakeholders and provide suggestions based on findings.
REQUIRED SKIILLS:
3-5+ years of experience in Data Reporting
Must have strong experience with Excel – pivot tables, Vlookups, filters, etc.
1-2+ years of T-SQL and other ETL experience
Familiarity with Access and other data analytics tools such as Power BI/MS 365
Experience with Data Connect ETL would be highly desired but not required
Power BI – nice to have but not required
Proficient with working with various data formats
Advanced communication and customer service skills
Energetic Team player and Self-Starter
Health insurance experience preferred (not required)
Education Details: Business Administration or related field
In lieu of a Bachelor's degree, an additional 4 years of relevant work experience is required in addition to the required work experience.
ESSENTIAL FUNCTIONS:
25% Collaborates with stakeholders to understand data needs to create reports that meets the needs of the business. Identifies functional requirements through process analysis, review of documents and procedures, and interviews and meetings with stakeholders. Occasionally works alongside Developers and the System Architects to use the requirements to design the system concept of operations from both business and technical perspectives.
25% Analyzes data and develops observations and findings based on analysis. Creates and test reports utilizing feedback and revisions into reporting products. Conducts quality control, communicates findings, and obtains sign-off from stakeholders to implement reports into production.
25% Prepares adhoc analysis, researches moderately complex issues, and develops reports in support of reporting requirements, analyzes and interprets data, and makes recommendations to improve reporting processes.
15% Works in collaboration with another Requirements/Business Analyst to conduct discussions in interviews and workgroups to capture and to develop requirements. Analyzes the requirements and manages the requirement changes. Supports business operations development and develops standard operating procedures.
10% Works alongside Developers and the Architect to use the requirements to design the system concept of operations from both business and technical perspectives.
#M2
