BI Report Developer (Assistant Vice President)

Position Information

Hiring Manager:
Director
Department:
Planning & Operations

Department Overview

The Planning & Operations ("P&O") Group drives planning, analytics, data management and technology projects while providing operational support for the Investor Partners Group ("IPG"), which has primary responsibility for all of Golub Capital's business development and client relationship management activities. The team possesses both a deep understanding of IPG's needs as well as a strong set of unique technical expertise. The Data Management subgroup is responsible for making data readily available in order to empower and simplify the IPG's ability to make data-driven decisions. The team collaborates closely with other IPG Teams and Technology Solutions ("TS") to support the department in developing and executing plans in line with Firm objectives.

Position Responsibilities

This individual will perform sophisticated data analysis and develop automated reports for business stakeholders and leadership.

Responsibilities include, but are not limited to:

• Designing and implementing a standardized intake process for new reports including gathering requirements, prioritization, SLA management and maintaining a centralized tracking system
• Creating, maintaining and testing IPG published reports
• Creating and maintaining Power BI reports and dashboards that are accurate and aligned with business needs
• Establishing and managing a structured process for maintaining and updating existing reports, including implementing regression testing to ensure report integrity after updates or data model changes
• Serving as the subject matter expert for Power BI and analysis services cube technologies across IPG
• Providing training, documentation and support to business users to promote self-service
• Collaborating with Data Engineering and Governance Teams to ensure data quality, consistency and compliance
• Applying best practices in data modeling and query optimization, including use of star schemas, query folding and minimizing high-cardinality columns to enhance report performance and scalability

Candidate Requirements

Qualifications & Experience:

• Bachelor's degree required, preferably in applied mathematics / statistics, engineering, business analytics or a related field
• 7+ years of relevant work experience with database systems, reporting and data analysis
• Strong knowledge of relational databases, specifically as it relates to common Customer Relationship Management (CRM) systems and data warehouse solutions
• Strong proficiency in T-SQL, Data Analysis Expressions (DAX), Power Query (M), building reports and visualizations with Power BI
• Strong proficiency in Power BI Paginated reporting and / or Microsoft SQL Server Reporting Services (SSRS)
• Adept at handling Power BI Service workspaces and associated security privileges and deployment procedures
• Solid understanding of data ingestion and refresh policies in Power BI. Working knowledge of Power BI Service Gateway configuration.
• Experience with Microsoft SQL Server (including Microsoft SQL Server Analysis Services (SSAS), Microsoft Dynamics CRM, Git / GitHub version control software, common software development and deployment practices
• Experience with open-source data analytics languages, such as R and Python, is a plus
• Excellent analytical, problem solving and logical reasoning skills
• Ability to convey complex concepts in a straightforward manner to business and Technology Team stakeholders
• Diligent attention to detail
• Able to work in a fast-paced environment, manage time and priorities under pressure and meet deadlines
• Enthusiastic about working in office and creating a Gold Standard hybrid work culture

Critical Competencies for Success

Our Gold Standards Model defines key behaviors and competencies across 4 dimensions: Leadership, Achieving Results, Personal Effectiveness and Thinking Critically. These behaviors and competencies drive our ability to win together.

• Leadership: Role models in this area consistently focus on the right goals and priorities and continually develop themselves and others. Always team players, they influence and engage with others to contribute to a supportive and inclusive culture where all feel welcome.
• Achieving Results: Role models in this area are high achievers who develop careful plans and deliver consistently and effectively. They hold themselves and others accountable for delivering high quality results, and they remove barriers to ensure others can contribute and grow.
• Personal Effectiveness: Role models in this area build strong relationships, treat others with respect and communicate effectively. They are driven to exceed expectations and are adaptable to changing circumstances.
• Thinking Critically: Role models in this area understand our business, rely on analytical reasoning and seek diverse perspectives to solve problems. They are forward thinking, anticipating issues and addressing them in advance.

The department-specific competencies define the knowledge, skills and abilities that are needed to successfully perform the functional or technical work of this role.

• Industry Knowledge: Demonstrates an understanding of the Firm's position in the industry, specifically with regard to direct lending and asset management, as well as the competitive landscape. Monitors industry trends and changes and recognizes their relevancy and implications to the Firm.
• Firm and Product Knowledge: Demonstrates an understanding of the Firm's investment strategies, client base, products and investor needs, including the Firm's structure and competitive advantage in the marketplace.
• Innovation: Embodies an agile and creative mindset to help develop new solutions, continuously improve and optimize existing processes and impose structure in ambiguous circumstances through people, process and technology.
• Project / Program Management: Manages projects and / or programs through planning, identifying resources, executing, monitoring and communicating project activities and assessing impacts of the project decisions.
• Analytics: Surfaces, sources, analyzes and interprets data to identify trends and inform strategy and business decisions.
• Data and Content Stewardship: Follows appropriate policies and procedures to enter and manage data and content, including evaluating issues with data and content and taking appropriate steps to address them. Communicates with others regarding data and content stewardship to ensure accuracy and integrity and encourages others to uphold data and content stewardship practices.
• Relationship Management: Creates ways to engage others, cultivate trust and build long-term win-win partnerships with investors, business partners and internal teams.

Compensation and Benefits
For New York Only: It is expected that the base salary range for this position will be $140,000 to $175,000. Actual salaries may vary based on factors such as skills, experiences and qualifications for the role. The total compensation package for this position may also include other elements and discretionary awards in addition to a full range of medical, financial and / or other benefits (including 401(k) eligibility and various paid time off benefits such as vacation, sick time and parental leave) dependent on the position offered. Details of participation in these benefit plans will be provided if an employee receives an offer of employment. If hired, the employee will be in an 'at-will position' and the Firm reserves the right to modify base salary (as well as any other discretionary payment or compensation program) at any time including for reasons related to individual performance, Firm or individual department / team performance and market factors.

Golub Capital is an Equal Opportunity Employer.

Due to the highly regulated nature of Golub Capital's business and because of the sensitivity of the information that all personnel have access to, Golub Capital performs extensive and thorough pre-hire screens to ensure that its personnel act with expected levels of integrity, professionalism and personal responsibility.