Back to jobs

Business Intelligence & Data Solutions Analyst - Cape Cod MA

Pay
Pay not listed
Work setting
Hybrid — work setting source
As a member of the Business Intelligence team, the Business Intelligence & Data Solutions Analyst transforms enterprise data and business requirements into trusted analytics, reporting, and workflow solutions. The role supports all business lines through development in Creatio, Power BI, and Cognos Analytics/IBM Business Analytics; contributes to data governance and data architecture; and delivers secure, scalable insights that improve customer experience, operational efficiency, risk management, and overall business performance. This is a hybrid position and requires onsite work multiple times each week in Hyannis, Massachusetts. ESSENTIAL RESPONSIBILITIES
Read the full posting
Employment
Not stated

What you’ll work on

Full posting
  • Translate business needs into data, reporting, dashboard, and workflow requirements

  • Develop and support Creatio solutions, dashboards, integrations, and access roles

  • Design and maintain Power BI models, DAX measures, and interactive dashboards

  • Develop Cognos Analytics reports, packages, and scheduled distributions

  • Extract and reconcile data from core processing, CRM, and financial systems using SQL

From the employer’s posting
Partner with business stakeholders to translate strategic, operational, regulatory, and customer-experience needs into clear data, reporting, dashboard, and workflow requirements.
Develop, configure, test, deploy, and support Creatio solutions, including business processes, objects, pages, dashboards, integrations, and role-based access
Design and maintain Power BI semantic models, data transformations, DAX measures, interactive dashboards, scheduled refreshes, security rules, and reusable reporting assets.
Develop and support Cognos Analytics/IBM Business Analytics reports, dashboards, packages, queries, and scheduled distributions
Extract, profile, cleanse, reconcile, and analyze data from the Bank’s core processing system, CRM, financial platforms, and other enterprise sources using SQL

What you’ll bring

All qualifications

Core experience

  • Ability to lift and carry up to 25 pounds on an occasional basis.
Qualification wording
Ability to lift and carry up to 25 pounds on an occasional basis.
Education & alternatives
Education and Experience: · Bachelor’s degree in Data Analytics, Information Systems, Computer Science, Finance, Business Administration, Economics, or a related field; equivalent education and relevant experience may be considered. · Two or more years of experience in business intelligence, data analytics, application development, reporting, or data management; banking or financial-services experience is preferred.
Apply at Cape & Coast Bank

Posting record

Report an error

Actively hiringFirst seen by us 3 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 18, 20263 days ago
Recorded sightings
5
Last seen by us
Nov 22, 2026
Employer says posted
Sep 30, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 3

Early. Similar jobs usually come down between day 5 and day 43.

From 16,009 similar postings that came down. Coming down is not always a hire.

Cape & Coast Bank is hiring

1 open job

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SQL
  • Cognos
  • Excel
  • Power BI
  • Power Query
Where the posting names them
· Develop and support Cognos Analytics/IBM Business Analytics reports, dashboards, packages, queries, and scheduled distributions for recurring and ad hoc business needs. · Extract, profile, cleanse, reconcile, and analyze data from the Bank’s core processing system, CRM, financial platforms, and other enterprise sources using SQL and approved analytical tools. · Create and maintain logical data models, shared definitions, source-to-target mappings, data lineage, and architecture documentation that support scalable integration and analytics.
· Experience with Cognos Analytics/IBM Business Analytics or a comparable enterprise reporting platform, including report authoring and scheduled delivery. · Working knowledge of SQL, relational databases, data integration concepts, dimensional modeling, and data architecture principles. · Understanding of data governance practices, including metadata, data lineage, data quality, stewardship, classification, access controls, and documentation.
Description As a member of the Business Intelligence team, the Business Intelligence & Data Solutions Analyst transforms enterprise data and business requirements into trusted analytics, reporting, and workflow solutions. The role supports all business lines through development in Creatio, Power BI, and Cognos Analytics/IBM Business Analytics; contributes to data governance and data architecture; and delivers secure, scalable insights that improve customer experience, operational efficiency, risk management, and overall business performance. This is a hybrid position and requires onsite work multiple times each week in Hyannis, Massachusetts.
· Design and maintain Power BI semantic models, data transformations, DAX measures, interactive dashboards, scheduled refreshes, security rules, and reusable reporting assets. · Develop and support Cognos Analytics/IBM Business Analytics reports, dashboards, packages, queries, and scheduled distributions for recurring and ad hoc business needs. · Extract, profile, cleanse, reconcile, and analyze data from the Bank’s core processing system, CRM, financial platforms, and other enterprise sources using SQL and approved analytical tools.
· Proficiency with Power BI, including Power Query, data modeling, DAX, dashboard development, publishing, refresh management, and row-level security. · Experience with Cognos Analytics/IBM Business Analytics or a comparable enterprise reporting platform, including report authoring and scheduled delivery. · Working knowledge of SQL, relational databases, data integration concepts, dimensional modeling, and data architecture principles.
· Understanding of data governance practices, including metadata, data lineage, data quality, stewardship, classification, access controls, and documentation. · Advanced Excel skills and proficiency with Microsoft 365 applications, including Word, PowerPoint, Teams, and SharePoint. · Ability to gather requirements, manage work through a development lifecycle, perform testing and validation, troubleshoot issues, and clearly document solutions.
· Field and triage end-user inquiries, troubleshoot access, data, workflow, and usability issues, document resolutions, escalate defects when needed, and identify recurring themes that inform training and roadmap priorities. · Design and maintain Power BI semantic models, data transformations, DAX measures, interactive dashboards, scheduled refreshes, security rules, and reusable reporting assets. · Develop and support Cognos Analytics/IBM Business Analytics reports, dashboards, packages, queries, and scheduled distributions for recurring and ad hoc business needs.
· Hands-on experience developing or configuring solutions in Creatio or a comparable low-code CRM or business-process platform. · Proficiency with Power BI, including Power Query, data modeling, DAX, dashboard development, publishing, refresh management, and row-level security. · Experience with Cognos Analytics/IBM Business Analytics or a comparable enterprise reporting platform, including report authoring and scheduled delivery.

Your next step

Complete your application on recruiting.paylocity.com. The employer’s form will show what is required.

Applying through Paylocity

  • “Upload your resume and we’ll automatically fill out your application”: the form fills itself from your file, so check it before sending.

Already applied? Track this application

Job description

View original posting ↗

Description

As a member of the Business Intelligence team, the Business Intelligence & Data Solutions Analyst transforms enterprise data and business requirements into trusted analytics, reporting, and workflow solutions. The role supports all business lines through development in Creatio, Power BI, and Cognos Analytics/IBM Business Analytics; contributes to data governance and data architecture; and delivers secure, scalable insights that improve customer experience, operational efficiency, risk management, and overall business performance.


This is a hybrid position and requires onsite work multiple times each week in Hyannis, Massachusetts.  


ESSENTIAL RESPONSIBILITIES

· Partner with business stakeholders to translate strategic, operational, regulatory, and customer-experience needs into clear data,  reporting, dashboard, and workflow requirements.

· Develop, configure, test, deploy, and support Creatio solutions, including business processes, objects, pages, dashboards, integrations, and role-based access, in accordance with established change-management standards.

· Develop and deliver role-based Creatio onboarding and new-hire training, maintain supporting guides and job aids, and reinforce adoption of approved CRM processes and data-entry standards.

· Partner with the Creatio product owner and business stakeholders to assess enhancement requests, document priorities and dependencies, and support completion and ongoing maintenance of the CRM roadmap.

· Coordinate the administration and controlled promotion of Creatio configurations across development, test, and production environments, including release readiness, regression testing, deployment validation, and environment documentation.

· Serve as backup Creatio administrator by supporting user provisioning, roles and permissions, system settings, reference data, scheduled processes, monitoring, and routine platform maintenance in accordance with security and change-control requirements.

· Field and triage end-user inquiries, troubleshoot access, data, workflow, and usability issues, document resolutions, escalate defects when needed, and identify recurring themes that inform training and roadmap priorities.

· Design and maintain Power BI semantic models, data transformations, DAX measures, interactive dashboards, scheduled refreshes, security rules, and reusable reporting assets.

· Develop and support Cognos Analytics/IBM Business Analytics reports, dashboards, packages, queries, and scheduled distributions for recurring and ad hoc business needs.

· Extract, profile, cleanse, reconcile, and analyze data from the Bank’s core processing system, CRM, financial platforms, and other enterprise sources using SQL and approved analytical tools.

· Create and maintain logical data models, shared definitions, source-to-target mappings, data lineage, and architecture documentation that support scalable integration and analytics.

· Apply data governance standards by documenting business terms, data owners and stewards, classifications, quality rules, authoritative sources, retention expectations, and access requirements.

· Monitor data quality, report accuracy, performance, refresh activity, and solution adoption; investigate issues, perform root-cause analysis, and coordinate remediation.

· Design governed self-service analytics that balance accessibility with security, privacy, regulatory, and audit requirements.

· Analyze trends, customer and product behavior, financial performance, operational efficiency, and sales and service opportunities; clearly communicate insights and recommended actions.

· Develop forecasting, performance measurement, and management-reporting solutions that support informed strategic and tactical decisions.

· Prepare technical specifications, test plans, release notes, data dictionaries, user guides, and support documentation; coordinate user acceptance testing and production validation.

· Provide training and ongoing support to business users, promote data literacy, and identify opportunities to automate manual processes and modernize legacy reporting.

· Collaborate with Technology, Information Security, Risk, Compliance, Finance, Operations, and business-line partners to deliver reliable solutions aligned with enterprise priorities.

Additional duties may be assigned as required.

 

Our history of success and commitment to exceptional customer service starts with our employees and we are seeking candidates who share our vision of excellence and distinction. 

In addition to working with our engaged and exceptional team members, the successful candidate will be provided with competitive salary and outstanding benefits that include health dental and vision insurance, generous 401(k) match and tuition reimbursement. 

Member FDIC. Member DIF. Equal Opportunity Employer.

Requirements

  

COMPETENCIES

· Business Partnership – Builds strong relationships, elicits requirements, and translates business needs into practical technology and analytics solutions.

· Solution Development – Applies structured development, testing, documentation, deployment, and support practices across CRM and business intelligence platforms.

· Data Analysis & Storytelling – Uses sound analytical methods and clear visual communication to turn complex data into actionable insights.

· Data Governance & Architecture – Understands data ownership, definitions, quality, lineage, security, modeling, integration, and the importance of trusted enterprise data.

· Quality & Risk Management – Demonstrates attention to detail and applies appropriate controls to protect confidential information and support auditability.

· Communication – Explains technical and financial information in business-friendly language and communicates effectively with colleagues, leaders, and other stakeholders.

· Continuous Improvement – Identifies opportunities to simplify processes, automate work, improve performance, and expand the value of data and technology investments.

· Organization – Manages competing priorities and projects while delivering accurate, timely, and well-documented results.

QUALIFICATIONS

Education and Experience:

· Bachelor’s degree in Data Analytics, Information Systems, Computer Science, Finance, Business Administration, Economics, or a related field; equivalent education and relevant experience may be considered.

· Two or more years of experience in business intelligence, data analytics, application development, reporting, or data management; banking or financial-services experience is preferred.

· Hands-on experience developing or configuring solutions in Creatio or a comparable low-code CRM or business-process platform.

· Proficiency with Power BI, including Power Query, data modeling, DAX, dashboard development, publishing, refresh management, and row-level security.

· Experience with Cognos Analytics/IBM Business Analytics or a comparable enterprise reporting platform, including report authoring and scheduled delivery.

· Working knowledge of SQL, relational databases, data integration concepts, dimensional modeling, and data architecture principles.

· Understanding of data governance practices, including metadata, data lineage, data quality, stewardship, classification, access controls, and documentation.

· Advanced Excel skills and proficiency with Microsoft 365 applications, including Word, PowerPoint, Teams, and SharePoint.

· Ability to gather requirements, manage work through a development lifecycle, perform testing and validation, troubleshoot issues, and clearly document solutions.

· Knowledge of banking products, core processing systems, procedures, internal controls, privacy expectations, and applicable regulations is preferred.

Physical Requirements

Ability to lift and carry up to 25 pounds on an occasional basis.

Demand for Analyst roles

New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 993, the most 1,510, and the latest week had 1,367.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Headquarters

As a member of the Business Intelligence team, the Business Intelligence & Data Solutions Analyst transforms enterprise data and business requirements into trusted analytics, reporting, and workflow solutions. The role supports all business lines through development in Creatio, Power BI, and Cognos Analytics/IBM Business Analytics; contributes to data governance and data architecture; and delivers secure, scalable insights that improve customer experience, operational efficiency, risk management, and overall business performance. This is a hybrid position and requires onsite work multiple times each week in Hyannis, Massachusetts. ESSENTIAL RESPONSIBILITIES
Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.