Foundation Business Intelligence Developer

 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.

Hoag Memorial Hospital Presbyterian is a nonprofit regional health care delivery network in Orange County, California, consisting of three acute-care hospitals with sixteen urgent care centers, eleven health centers and a network of more than1,800 physicians, 100 allied health members, 8,000 employees, and 2,000 volunteers. More than 30,000 inpatients and 550,000 outpatients choose Hoag each year.

For over 70 years, Hoag has delivered a level of personalized care that is unsurpassed among Orange County’s health care providers. Since 1952, Hoag has served the local communities and continues its mission to provide the highest quality health care services through the core strategies of quality and service, people, physician partnerships, strategic growth, financial stewardship, community benefit and philanthropy.

Hoag offers a comprehensive blend of health care services including six institutes providing specialized care in the areas of cancer, heart and vascular, neurosciences, women's health, orthopedics, and digestive health through our institutes.

Hoag was the highest ranked hospital in Orange County in the 2024-2025 U.S. News &World Report, the only Orange County hospital ranked in the top 10 for California. The organization was ranked the #5 hospital in the Los Angeles Metro Area and the #10 hospital in California.

To learn more about Hoag’s awards and accreditations, visit: https://www.hoag.org/about-hoag/awards-accreditations/.

Hoag is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind. Hoag is committed to the principle of equal employment opportunity for all employees and providing employees with a work environment free of discrimination and harassment. Hoag hires a diverse group of people in a manner that allows them to reach their full potential in the pursuit of organizational objectives.