BUSINESS INTELLIGENCE & DATA SOLUTIONS ANALYST - CAPE COD MA

Cape & Coast Bank; Hyannis (MA); Híbrido; USD 90 000 - 130 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Health, dental, and vision insurance

401(k) match

Tuition reimbursement

Resumo da oferta

Cape & Coast Bank is seeking a Business Intelligence & Data Solutions Analyst to transform enterprise data into trusted analytics, reporting, and workflow solutions. The role supports all business lines through Creatio, Power BI, and Cognos Analytics, contributing to data governance and architecture to improve customer experience, operational efficiency, risk management, and performance.

The position is hybrid, requiring onsite work several times per week in Hyannis, Massachusetts, with

Qualificações

• Bachelor’s degree in a related field; equivalent education or experience may be considered.
• 2+ years in business intelligence, data analytics, or reporting; banking/financial services preferred.
• Hands-on experience with Creatio or similar low-code CRM platforms.
• Proficiency with Power BI including data modeling, DAX, and dashboards.

Responsabilidades

• Translate business needs into data, reporting, dashboards, and workflow requirements.
• Develop, configure, test, deploy Creatio solutions and dashboards.
• Provide Creatio onboarding and training; maintain guides and job aids.
• Support CRM roadmap and release readiness across environments.
• Serve as Creatio administrator and handle user provisioning and security.
• Design and maintain Power BI semantic models, data transformations, and security rules.
• Develop Cognos Analytics reports and scheduled distributions.
• Extract and analyze data from core systems using SQL and other tools.
• Create data models, mappings, and architecture documentation.

Conhecimentos

Power BI

Creatio

Cognos Analytics

SQL

Data governance

Excel

Communication

Formação académica

Bachelor’s degree in Data Analytics or related field

Ferramentas

Power BI

Creatio

Cognos Analytics

Descrição da oferta de emprego

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.

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, elevate 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.