Primary Duties and Responsibilities

The Manager of Business Intelligence Services is responsible for supporting the design, development, and management of the Foundation’s data and reporting infrastructure. This role will assist in administering the data warehouse and business intelligence functions. The Manager will collaborate with systems administration, data governance, business process management, analytics, and reporting colleagues to deliver reliable data and insights that support the organization’s mission-critical activities and decision-making processes.

• Support Strategic Data Initiatives: Assist in the execution of the Foundation’s data, technology, analytics, and reporting plans by providing technical expertise and support.
• Service-Oriented Data Management: Help maintain a service-oriented environment focused on delivering accurate, timely, and engaging data insights.
• Data Structure and System Knowledge: Develop a deep understanding of source system data structures, application business rules, and the data challenges and opportunities within the Foundation.
• Data Standardization: Work with users and administrators to standardize data channels, content, and refresh standards, ensuring consistency across the organization.
• Data Warehouse Management: Assist in the creation and maintenance of data structures within the Foundation’s data warehouse, utilizing data mappings, native languages, ETL tools, and data extracts from systems and other approved data sources.
• Metadata and Data Dictionary Maintenance: Help develop and maintain metadata, maps, and data dictionaries for the data warehouse to ensure data integrity
• Data Integration and Transformation: Support continuous data integration and transformation efforts, ensuring that data is efficiently processed and ready for analysis.
• Logical and Physical Data Modeling: Contribute to logical and physical data modeling efforts in support of analytics, dashboard development, and other reporting needs.
• Security and Access Management: Assist in ensuring appropriate security, access, and change control standards are in place and adhered to for the data warehouse.
• Reporting and Dashboard Development: Author and maintain reports and dashboards that meet the business intelligence requirements of the Foundation, with a focus on using Salesforce and Marketing Cloud.
• Technology Trends and Training: Stay current with technology trends, regularly attend training, and maintain peer networks. Participate in the evaluation and selection of vendor systems and engagements as needed.
• Support for Enterprise Initiatives: Assist with enterprise risk management, business continuity planning, information security, and internal control initiatives.
• Marketing Cloud: Provide the Marketing team with platform support and guidance on system optimization, enhancing product functionality to achieve strategic goals. Maintain an overview of all campaigns and journeys.

• Bachelor’s degree in Information Systems, Data Science, or a related field, or equivalent professional experience.
• 3-5 years of experience in data warehouse development, data governance, modeling, analytics, and business intelligence practices.
• Experience with Salesforce and Marketing Cloud, particularly in managing data, reporting and analytics within these platforms.
• Proficiency with Microsoft SQL and Power BI is required.
• Must have 1 year of experience with Foundation or non-profit
• Analytical and Organizational Skills: Must have strong organizational and analytical skills, with great attention to detail, to effectively respond to technical assistance requests while maintaining the integrity of the data infrastructure.
• Ability to Work Independently: Must be able to work independently and make effective decisions in a complex business environment with shifting priorities.