Business Intelligence Analyst

Overview The Business Intelligence Analyst will be responsible for reporting and data analytics and partner with the COO and executive leadership team to support strategic decision-making and operational efficiency in managing federally funded research projects. This role encompasses overseeing analytics tools like Tableau and PeopleSoft, among others, to enable robust reporting, performance analysis, and monitoring of grants and contracts. Focusing on incorporating modern data management tools and practices, this person will work closely with the research administration team, project managers, and division administrators to ensure that data-driven insights inform the planning, execution, and evaluation of sponsored research projects, optimizing their performance and compliance. About the Role Duties and Responsibilities: • Data Management and Analytics: Lead the collection, analysis, and interpretation of data, employing Tableau, PeopleSoft, and additional tools for dynamic reporting and dashboards. Develop Tableau dashboards and data sources for comprehensive reporting and targeted departmental needs. • Strategic Reporting and Technical Solutions: Create and maintain essential reports and dashboards for internal stakeholders to support strategic decisions. Research, design, and implement technical solutions, including integrating EVM methodologies to assess project performance, forecast future trends, and facilitate corrective actions. • Earned Value Management (EVM) Implementation: Implement EVM practices to provide a quantitative approach to assessing project performance, including cost and schedule variance analysis. This involves setting baseline metrics, tracking performance, and analyzing variances to guide strategic decision-making. • Grant and Contract Monitoring: Oversee systems for monitoring grants and contracts, ensuring compliance with federal regulations and organizational policies. Manage Tableau servers and software, incorporating EVM data into reporting structures where applicable. • Collaboration, Training, and Mentoring: Engage with stakeholders to weave analytics and EVM practices into the fabric of project management. Train and mentor new Tableau users and project managers in applying data analytics and EVM principles. Partner with staff at all levels throughout the organization to design and implement reporting tools for projects of various sizes. • Process Improvement and Compliance: Drive process improvements using data-driven strategies and EVM insights. Ensure adherence to institutional IT standards, policies, and codes of conduct, incorporating EVM standards where relevant. • Supervisory and Other Duties: Provides overall human resources management to direct reports, including interviewing and hiring new team members; determining training needs and arranging for training as appropriate by planning and assigning work, setting priorities, establishing deadlines, providing follow-up, supervising day-to-day awards activities, developing performance standards; reviewing performance (probationary and annual); recommending performance awards; recommending and taking necessary disciplinary action; giving advice, counsel, and instruction to team members; and approving leave. • Oversees preparation and dissemination of guidance material to all key SAO personnel to inform, clarify, and explain significant regulatory requirements, policies, procedures, and associated changes. • Responsible for coordinating with appropriate SAO and SI departments on enhancements to and operation of the systems and processes within their domain. • Maintain communications with all Division Administrators, Program Managers, and Department Managers within SAO regarding their satisfaction with research administrative services and data related services. • Provide expertise to the SAO Executive Leadership team in developing policies and procedures governing our sponsored research enterprise. • Provide training to administrative and scientific colleagues in multiple formats, from one-on-one training to classroom settings. • Evaluate processes, recommend changes, and implement enhancements that will benefit the team in support of SAO’s strategies and key initiatives. • Set schedules for accomplishing duties discussed above and ensure all stakeholders are aware of the schedule of activities, following up as needed to ensure decision makers' availability and providing ample time for internal reviews and input. • Performs other duties as assigned. Qualifications • Advanced knowledge of SQL, Tableau, and a demonstrated capability to effectively engage with stakeholders. • Familiarity with SQL development, Tableau development, data analysis, and specifically, experience with implementing and managing EVM systems. • Advanced knowledge of Kimball Data Modeling, SSIS, or other ETL tools, and/or Master Data Management is desirable. • Prior exposure to a higher education or academic research environment is beneficial. • Strong analytical and problem-solving skills, effective stakeholder engagement across all levels of the organization, proficiency in data visualization and the development of dynamic reports and dashboards, and a solid understanding of EVM principles and their application in project management are crucial. • Advanced knowledge of the application of EVM techniques and management disciplines for such tools as Deltek Cobra, Empower, and PeopleSoft or equivalent tools; and have experience with Microsoft Office Tools including Microsoft Project and Acumen FUSE or equivalent business applications. • Working knowledge of contracts, grants transactions, applicable financial systems, and related policy, accounting, and regulatory compliance requirements, including Federal Acquisition Regulation [FAR], NASA FAR Supplement [NFS], NASA Handbooks and Guidebooks, applicable Parts of the Code of Federal Regulations [CFR], applicable Office of Management and Budget [OMB] Guidance, and all other applicable regulations and policies. • Ability to work independently and collaboratively in a diverse environment, service-oriented mindset, willingness to learn new technologies and strong communication skills. • Highly self-motivated and directed, with a commitment to professional development. • Ability to work with efficiency and tact. Required Skills Advanced knowledge of SQL, Tableau, and a demonstrated capability to effectively engage with stakeholders. Familiarity with SQL development, Tableau development, data analysis, and specifically, experience with implementing and managing EVM systems. Advanced knowledge of Kimball Data Modeling, SSIS, or other ETL tools, and/or Master Data Management is desirable. Prior exposure to a higher education or academic research environment is beneficial. Preferred Skills Strong analytical and problem-solving skills, effective stakeholder engagement across all levels of the organization, proficiency in data visualization and the development of dynamic reports and dashboards, and a solid understanding of EVM principles and their application in project management are crucial.