IT Business Analyst (on-site)

CFS; Boston (MA); Hybrid; USD 80,000 - 90,000; Full time

Job summary

CFS is seeking an IT Business Analyst to support a major enterprise data initiative, bridging business stakeholders and external consultants. You will help implement a modern data warehouse, cleanse and organize data, and develop dashboards and AI-enabled workflows to drive reporting and automation.

The role involves collaborating with leadership, gathering data requirements, and supporting Power BI and related Microsoft tech across SaaS platforms.

Qualifications

• 3-5 years as business/ data analyst or systems analyst
• Strong understanding of database structures and data quality
• Experience with BI/reporting projects and data-related initiatives
• Ability to translate business needs into technical data requirements
• Experience supporting enterprise SaaS applications

Responsibilities

• Assist with data warehouse implementation and data quality activities
• Gather and document data requirements from business units
• Create reports and dashboards to drive decision making
• Support Power BI reporting initiatives and automation workflows
• Collaborate with leadership on data strategy and opportunities

Skills

Requirement gathering

Stakeholder communication

Data quality

Analytical thinking

Tools

Power BI

Power Automate

SharePoint

Microsoft Fabric

Snowflake

AI tools (ChatGPT/Claude)

Job description

Job Title: IT Business Analyst - Data & Technology Transformation

The Opportunity

This is a newly prioritized technology hire that will work directly with the Vice President of Technology to support a major enterprise data initiative. The organization is in the process of evaluating and standing up a modern data warehouse environment and is seeking someone who can bridge the gap between business stakeholders and external consultants throughout the implementation process.

The ideal candidate will possess a strong understanding of database structures, data quality, and business systems while also serving as a key resource to business teams as data is collected, cleansed, organized, and ultimately leveraged for reporting, analytics, automation, and AI initiatives.

This is an excellent opportunity for someone who enjoys wearing multiple hats, working closely with leadership, and contributing to projects that will significantly impact the firm's technology roadmap.

What You'll Do

• Assist with enterprise data warehouse implementation and support consultant-led initiatives
• Perform data cleansing, validation, and data quality analysis
• Work directly with business units to gather, organize, and document data requirements
• Help define data structures, classifications, and standards across systems
• Support SaaS applications including DealCloud, Juniper Square, Sage Intacct, Ramp, SharePoint, and related business platforms
• Create reports, dashboards, and analytics that drive decision-making
• Assist with Power BI reporting initiatives
• Utilize Power Automate and AI technologies to improve workflows and business processes
• Collaborate on future AI, dashboarding, and automation projects across the organization
• Provide application support, user administration, and access management where needed
• Partner with technology leadership to identify process improvements and technology opportunities

What You'll Bring

• 3-5 years of business analyst, systems analyst, data analyst, or technology-focused experience
• Strong understanding of database structures, tables, data types, and data integrity concepts
• Experience working with reporting, business intelligence, or data-related projects
• Ability to gather requirements and communicate effectively with technical and non-technical stakeholders
• Experience supporting SaaS applications and enterprise business systems
• Familiarity with Power BI, Power Automate, SharePoint, and Microsoft technologies
• Exposure to AI tools such as ChatGPT, Claude, or similar platforms
• Strong problem-solving skills and a self-starter mentality

Preferred Experience

• Snowflake
• Microsoft Fabric
• Data warehouse projects
• Business intelligence and dashboard development
• Commercial real estate, private equity, asset management, or financial services environments

Work Environment

• Primarily onsite environment
• One remote day per week available
• Additional flexibility available on a case-by-case basis
• Collaborative culture with significant in-person interaction across business units

Compensation

• Target salary range: $80,000 - $90,000