Business Intelligence Lead

Job Description

Passion. Purpose. Impact. CJP is at the heart of Greater Boston's Jewish community, but our reach is felt around the world. Ranked by BBJ as Massachusetts’ largest non-profit organization – CJP is a philanthropic investor and mobilizer of people, resources, and skills that make a bigger difference locally and globally.

The Business Intelligence (BI) Lead is responsible for transforming complex business needs into actionable insights through data analysis, reporting, and dashboard development. This includes aligning on BI strategy, designing, developing, and maintaining systems that collect and analyze business data, creating dashboards, reports, and visualizations to extract actionable insights from complex datasets, enabling informed decision-making within an organization by translating raw data into meaningful information through the use of specialized BI tools and programming languages in collaboration with data engineers, analysts, and other organizational stakeholders to understand requirements and deliver impactful data solutions. To be successful in this role, strong alignment with our Core Values of Respect, Collaboration, Integrity, Caring, and Innovation are required.

CJP is not able to offer visa sponsorship for this position. Candidates must be authorized to work in the United States without visa sponsorship.

Essential Functions:

• Strategy and Vision: Leading the execution of the BI strategy, aligning it with organizational goals, and identifying future capability needs

• Collaborative Leadership: Driving a group of professionals to achieve program goals and fostering a culture of continuous improvement

• Data Storytelling: The ability to create compelling narratives from data, presenting complex insights in an understandable and engaging way to diverse audiences, fostering data-driven decision-making

• Stakeholder Relationship Management: Skilled at building rapport, managing expectations, fostering collaboration, and resolving conflicts with stakeholders across various departments and organizational levels

• Program Design: Ability to use a deep understanding of strategy and goals to design, prioritize, and estimate plans to complete workstreams to, in alignment with agile principles, deliver program goals

• Data Modeling and ETL: Designing data models, developing and managing data pipelines to extract, transform, and load (ETL) data from various sources into data warehouses for analysis

• Dashboard and Report Development: Creating interactive dashboards and reports using BI tools (e.g., Tableau, Power BI) to visualize key performance indicators (KPIs) and trends for different business units

• Data Analysis and Insights: Conducting deep-dive analysis of complex datasets to identify patterns, trends, and correlations that provide valuable business insights

• Data Governance: Ensuring data quality, accuracy, and consistency by implementing data validation processes and maintaining data governance standards

• Technical Skills: Proficiency in SQL, data warehousing concepts and tools, data visualization solutions, programming languages

• Security: Deep appreciation and understanding of data security and classification

• Support: Address stakeholder and system support, maintenance, and training needs

• Other duties as assigned with or without accommodation.

Working Conditions:

• Hybrid Work Schedule: CJP staff follow a hybrid work model. On-site work is required on Tuesdays and Wednesdays, while remote work is an option on Mondays, Thursdays, and Fridays with occasional in-person meetings on those days.

• Physical Requirements: This role involves remaining in a stationary position, often sitting or standing for prolonged periods, primarily working at a computer. Staff need to be able to carry a laptop and bag to and from the office.

• Inclusivity: We are committed to creating an inclusive environment for individuals of all abilities and backgrounds.

Requirements

Education:

• Bachelor in relevant field preferred

Skills and Experience:

• 5+ years of experience working with complex data, with a proven ability to independently analyze, interpret, and deliver insights that drive business decisions

• 2+ years of demonstrated experience leading, designing, and delivering a business intelligence program

• Strong analytical and problem-solving skills

• Understanding of business processes and key performance indicators

• Experience with data warehousing and BI tools

• Excellent communication and presentation skills to convey complex data insights to non-technical stakeholders

• Programming skills in SQL and potentially other languages

• Understanding of key technology solutions and ongoing commitment to awareness and research of emerging technology, systems, features, software, and best practices

• Maturity, flexibility, and the ability to focus on detail while handling multiple tasks and working with diverse personalities

• Ability to manage confidential information sensitively and appropriately

• Ability to be flexible and adaptable to changes and shifting priorities

• Ability to work additional time beyond normal work hours during periods of peak demand and time critical projects