Business Intelligence Analyst 1
Medical Center Development—the fundraising arm of Stanford Medicine—seeks an experienced business analyst to join our team. This role reports to the Director of Grateful Patient Program Analytics and builds, supports, and enhances the data systems and processes that underlie the medical fundraising efforts of MCD.
Under limited supervision, work to maintain, secure, develop, and quality-assure MCD’s internal SQL Server database, oversee the data flows between that database and other Stanford systems, and develop business intelligence solutions to report on that data.
- Maintain and oversee the overall structure, operability, HIPAA compliance, data integrity, and security of MCD's PostPAM database which constitutes the database of record which allows our current Grateful Patient Program (GPP) to function.
- Oversee the import, export, and reconciliation of data between PostPAM and the systems of record for Stanford Health Care and Stanford University, as well as with external data sources.
- Perform assigned activities involving decision support systems, query and reporting, online analytical processing, data profiling, statistical analysis, forecasting, and data mining. Develop insightful business intelligence reports, dashboards, scorecards, and ad hoc analyses. Clean and transform data as required to deliver actionable information.
- Collaborate with MCD users, vendors, OOD partners, and management to ensure the creation and delivery of business intelligence solutions. Facilitate working sessions with central and distributed end users and management to identify and document current information flows, data models, reporting systems, user populations, and coordinate with current and future initiatives impacting reporting.
- Act as primary data systems liaison to the ADAPT/CARD transition teams, database programmers/consultants engaged by MCD for PostPAM development, as well other data governance bodies.
- Use reports and analyses to identify potentially problematic data, make corrections, and eliminate root cause for a range of complex data problems, recommend possible solutions, and communicate their organizational impact.
- Perform fit-gap analysis comparing existing reporting solutions with BI strategy and assess compliance with best practices and established standards.
- Participate in user acceptance testing of new BI analysis and reporting systems, upgrades, enhancements and change requests; plan, conduct and document results of testing.
- Act as a high-level leader, trainer, and mentor on the MCD database to variety of end user constituencies.
- Other duties as they intersect with MCD reporting and analysis priorities.
Education and Experience
Bachelor’s degree and three years of relevant experience or combination of education and relevant experience. Experience in a quantitative discipline such as economics, finance, statistics or engineering.
Minimum Knowledge, Skills and Abilities Required
- Knowledge of computer system capabilities, business processes and workflow.
- Ability to understand and apply software development lifecycle and project management techniques.
- Demonstrated design and architectural familiarity with SQL Server-based databases, strong experience with Microsoft Access, and strong familiarity with data visualization solutions strongly desired.
- Experience working with common fundraising metrics and data sets and with the industry practices of large academic medical center/health care system philanthropy strongly preferred.
- Excellent communication skills, both written and verbal, including the ability to bridge functional and technical resources by communicating effectively with individuals of varying systems expertise and business needs.
- Demonstrated ability to review business processes and translate into BI reporting and analysis solutions.
- Experience in data analysis and root cause analysis and developing problem solving and analytical thinking capabilities.
- Demonstrated ability with enterprise application and database driven applications.
- Experience with relational and dimensional logical data modeling.
- In-depth knowledge of and ability using MS Office; analytical and business intelligence programs such as OBIEE, business objects, Informatica, Tableau, Matlab, SAS, R, SPSS etc..
- Extensive background and experience with report and analysis design and application of User Interface and User Experience best practices.
- Strong writing and analytical skills.
- Constantly perform desk-based computer tasks.
- Frequently sitting.
- Occasionally stand/walk.
- Rarely writing by hand; lift/carry/push/pull objects that weigh up to 10 pounds.
* Consistent with its obligations under the law, the University will provide reasonable accommodation to any employee with a disability who requires accommodation to perform the essential functions of the job.
- Interpersonal Skills: Demonstrates the ability to work well with Stanford colleagues and clients and with external organizations.
- Promote Culture of Safety: Demonstrates commitment to personal responsibility and value for safety; communicates safety concerns; uses and promotes safe behaviors based on training and lessons learned.
- Subject to and expected to comply with all applicable University policies and procedures, including but not limited to the personnel policies and other policies found in the University’s Administrative Guide, http://adminguide.stanford.edu/.
Stanford is an equal opportunity employer and all qualified applicants will receive consideration without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other characteristic protected by law.
Consistent with its obligations under the law, the University will provide reasonable accommodation to any employee with a disability who requires accommodation to perform the essential functions of the job.