Overview
On Site
Hybrid
USD 50.00 per hour
Full Time
Skills
Mergers and Acquisitions
Preventive Maintenance
Project Management
SaaS
Accounting
Information Systems
Microsoft Excel
Microsoft Power BI
Specification Gathering
Data Warehouse
Amazon Redshift
Systems Analysis
Communication
Presentations
Agile
Scrum
Waterfall
Cloud Computing
Data Architecture
Public Sector
Microsoft Access
Toad
Business Intelligence
Business Analysis
Data Analysis
FOCUS
Data Integration
Finance
Data Governance
Process Improvement
Decision-making
Business Analytics
Dashboard
Organizational Skills
Usability Testing
Business Continuity Planning
Data Lake
Asset Management
Cash Management
Debt Management
Financial Management
Budget Management
Order To Cash
Accounts Receivable
Procure-to-pay
Accounts Payable
Program Management
Financial Reporting
Analytics
Investment Management
Vendor Management
Incident Management
Capacity Management
Availability Management
Performance Management
Security Management
Change Management
Disaster Recovery
Testing
Management
Inventory
SQL
Stored Procedures
Collaboration
Data Structure
Data Quality
Data Integrity
Oracle
Migration
Reporting
Snow Flake Schema
Acceptance Testing
Training
Industrial Relations
Law
LOS
Recruiting
Immigration
Job Details
Date Posted: 08/11/2025
Hiring Organization: Rose International
Position Number: 486825
Industry: Government
Job Title: Business and Data Analyst
Job Location: Boston, MA, USA, 02108
Work Model: Hybrid
Work Model Details: 4 days a month onsite
Shift: Monday to Friday 8 AM to 5 PM
Employment Type: Temporary
FT/PT: Full-Time
Estimated Duration (In months): 18
Min Hourly Rate($): 50.00
Max Hourly Rate($): 56.00
Must Have Skills/Attributes: Agile, Business Analysis, Cloud, Data Analysis, Finance, PowerApps, Reporting, SaaS, Snowflake, SQL
Experience Desired: Exp. in business analysis and/or data analytics roles, preferably within a finance or reporting (5+ yrs); Strong proficiency in SQL (Oracle and Snowflake) (5+ yrs); Experience in Cloud Data warehouses like Snowflake and Redshift (5+ yrs)
Required Minimum Education: Bachelor's Degree
Job Description
***Only qualified Business Data Analyst candidates located near Boston,MA will be considered, as the position requires onsite presence***
Required Education:
Bachelor's degree in finance, accounting, Information Systems, Business Analytics, or a related study or equivalent experience
Required Skills, Experience and Knowledge:
Minimum of 5 years of experience in business analysis and/or data analytics roles, preferably within a finance or reporting environment
Strong proficiency in SQL (Oracle and Snowflake)
Proficiency with Excel, Power BI, Power Query, and Power Apps
Ability to translate business needs into technical specifications
Experience in Cloud Data warehouses like Snowflake and Redshift
Well-developed system analysis skills
Excellent verbal and interpersonal communication skills with experience presenting findings to technical and non-technical stakeholders
Experience in Agile, Scrum, Waterfall, or similar iterative development methodologies
Preferred Skills, Experience and Knowledge:
Experience with Software as a Service cloud implementation particularly those in which legacy on premise applications have been migrated to cloud delivery options, financial transformations and/or modernization projects
In addition, understanding data architecture, data quality, and data governance practices a plus
Experience working with financial data, state or public sector systems a plus
Familiarity with tools like Microsoft Access, Toad, or BI platforms a plus
The BEST (Business Enterprise Systems Transformation) Program Business & Data Analyst (Financial Reporting Modernization) will work with a team comprised of BEST Program staff, agency business and technical SMEs and the new solution system integrator (SI) and product vendor to support the modernization of Client's financial reporting processes and systems. The ideal candidate will have a strong background in both business analysis and data analytics, with a specific focus on financial reporting, data integration, and transformation initiatives. This role will work cross-functionally with Finance, IT, Data Governance, and other stakeholders to drive process improvements, enable data-driven decision-making, and ensure the delivery of scalable, accurate financial reporting solutions.
The BEST Program Business & Data Analyst (Financial Reporting Modernization) will work with the BEST Senior Data Architect and Financials Data Leads to identify reporting, dashboard and business analytics needs that will drive the configuration of standard reports and dashboards delivered through the new Financials solution. They will assist in leading requirements sessions with BEST staff, agency staff, and the system integrator and product vendor to review the reporting and analytics capabilities of the new solution and to identify available configuration options. The Business & Data Analyst will develop and maintain a list of selected configurations for each report and dashboard and work with reports/dashboard developers during configuration to assist in translating business requirements to the configured reports. The Business & Data Analyst will also participate in testing configured reports and dashboards and in organizing user testing of these items.
This role is critical to modernizing Client's financial reporting, as legacy reports built on Oracle based Business Continuity Volume (BCV) must be migrated to a new Snowflake-based data lake.
The Business & Data Analyst will support data access for users in the following areas, working to improve data quality and access in the new solution:
Financials:
Acquire to Retire (Capital Asset Management)
Cash Management
Cost Allocation
Debt Management
Grants Financial Management
Operating Budget Management
Order to Cash (Revenue/Accounts Receivable)
Procure to Pay (Accounts Payable)
Program Management
Record to Report (Financial Reporting)
Reporting/Analytics
Sub-fund Management
Vendor Management and Self Service
Operations:
Maintenance and Warranty Management
Incident Management
Capacity Management
Availability Management
Performance Management
Security Management
Nightly Batch Jobs Management
Software Change Management and Testing
Disaster Recovery Testing and Management
Specific Duties:
Create inventory and analyze existing SQL queries, Stored Procedures and reports used by CTR business areas
Collaborate with subject matter experts (SMEs) to understand report purpose, usage frequency, and business logic
Analyze data structures and relationships in Oracle, understand data quality rules, and map data elements to Snowflake's structure
Validate data integrity between Oracle and Snowflake, identify discrepancies, and ensure data accuracy post-migration
Investigate and resolve data-related issues, inconsistencies, and errors that may arise during or after the migration process
Document requirements for report redevelopment in Snowflake
Validate output of Snowflake queries to ensure consistency and accuracy
Support user acceptance testing and participate in training efforts
Benefits:
For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website.
California Pay Equity:
For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.
Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.
If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department.
Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).
Hiring Organization: Rose International
Position Number: 486825
Industry: Government
Job Title: Business and Data Analyst
Job Location: Boston, MA, USA, 02108
Work Model: Hybrid
Work Model Details: 4 days a month onsite
Shift: Monday to Friday 8 AM to 5 PM
Employment Type: Temporary
FT/PT: Full-Time
Estimated Duration (In months): 18
Min Hourly Rate($): 50.00
Max Hourly Rate($): 56.00
Must Have Skills/Attributes: Agile, Business Analysis, Cloud, Data Analysis, Finance, PowerApps, Reporting, SaaS, Snowflake, SQL
Experience Desired: Exp. in business analysis and/or data analytics roles, preferably within a finance or reporting (5+ yrs); Strong proficiency in SQL (Oracle and Snowflake) (5+ yrs); Experience in Cloud Data warehouses like Snowflake and Redshift (5+ yrs)
Required Minimum Education: Bachelor's Degree
Job Description
***Only qualified Business Data Analyst candidates located near Boston,MA will be considered, as the position requires onsite presence***
Required Education:
Bachelor's degree in finance, accounting, Information Systems, Business Analytics, or a related study or equivalent experience
Required Skills, Experience and Knowledge:
Minimum of 5 years of experience in business analysis and/or data analytics roles, preferably within a finance or reporting environment
Strong proficiency in SQL (Oracle and Snowflake)
Proficiency with Excel, Power BI, Power Query, and Power Apps
Ability to translate business needs into technical specifications
Experience in Cloud Data warehouses like Snowflake and Redshift
Well-developed system analysis skills
Excellent verbal and interpersonal communication skills with experience presenting findings to technical and non-technical stakeholders
Experience in Agile, Scrum, Waterfall, or similar iterative development methodologies
Preferred Skills, Experience and Knowledge:
Experience with Software as a Service cloud implementation particularly those in which legacy on premise applications have been migrated to cloud delivery options, financial transformations and/or modernization projects
In addition, understanding data architecture, data quality, and data governance practices a plus
Experience working with financial data, state or public sector systems a plus
Familiarity with tools like Microsoft Access, Toad, or BI platforms a plus
The BEST (Business Enterprise Systems Transformation) Program Business & Data Analyst (Financial Reporting Modernization) will work with a team comprised of BEST Program staff, agency business and technical SMEs and the new solution system integrator (SI) and product vendor to support the modernization of Client's financial reporting processes and systems. The ideal candidate will have a strong background in both business analysis and data analytics, with a specific focus on financial reporting, data integration, and transformation initiatives. This role will work cross-functionally with Finance, IT, Data Governance, and other stakeholders to drive process improvements, enable data-driven decision-making, and ensure the delivery of scalable, accurate financial reporting solutions.
The BEST Program Business & Data Analyst (Financial Reporting Modernization) will work with the BEST Senior Data Architect and Financials Data Leads to identify reporting, dashboard and business analytics needs that will drive the configuration of standard reports and dashboards delivered through the new Financials solution. They will assist in leading requirements sessions with BEST staff, agency staff, and the system integrator and product vendor to review the reporting and analytics capabilities of the new solution and to identify available configuration options. The Business & Data Analyst will develop and maintain a list of selected configurations for each report and dashboard and work with reports/dashboard developers during configuration to assist in translating business requirements to the configured reports. The Business & Data Analyst will also participate in testing configured reports and dashboards and in organizing user testing of these items.
This role is critical to modernizing Client's financial reporting, as legacy reports built on Oracle based Business Continuity Volume (BCV) must be migrated to a new Snowflake-based data lake.
The Business & Data Analyst will support data access for users in the following areas, working to improve data quality and access in the new solution:
Financials:
Acquire to Retire (Capital Asset Management)
Cash Management
Cost Allocation
Debt Management
Grants Financial Management
Operating Budget Management
Order to Cash (Revenue/Accounts Receivable)
Procure to Pay (Accounts Payable)
Program Management
Record to Report (Financial Reporting)
Reporting/Analytics
Sub-fund Management
Vendor Management and Self Service
Operations:
Maintenance and Warranty Management
Incident Management
Capacity Management
Availability Management
Performance Management
Security Management
Nightly Batch Jobs Management
Software Change Management and Testing
Disaster Recovery Testing and Management
Specific Duties:
Create inventory and analyze existing SQL queries, Stored Procedures and reports used by CTR business areas
Collaborate with subject matter experts (SMEs) to understand report purpose, usage frequency, and business logic
Analyze data structures and relationships in Oracle, understand data quality rules, and map data elements to Snowflake's structure
Validate data integrity between Oracle and Snowflake, identify discrepancies, and ensure data accuracy post-migration
Investigate and resolve data-related issues, inconsistencies, and errors that may arise during or after the migration process
Document requirements for report redevelopment in Snowflake
Validate output of Snowflake queries to ensure consistency and accuracy
Support user acceptance testing and participate in training efforts
Benefits:
For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website.
California Pay Equity:
For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.
Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.
If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department.
Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.