Data Architect (Assistant Vice President)

Position Information
Hiring Manager:
Associate Director
Department:
Technology Solutions
Title:
Assistant Vice President
Function:
Data Architect
Department Overview
The Technology Solutions ("TS") Department is responsible for designing and delivering state of the art technology solutions that are designed to create efficiency, mitigate risk and grow revenue for the Firm. Technology Solutions is also responsible for defining, managing and executing a robust Cyber Security program following the NIST Cyber Security Framework. Technology Solutions focuses on technical excellence through innovative application designs, robust data integration and analytics, high availability infrastructure and gold level service for our key stakeholders with information security embedded throughout. Critical functions within Technology Solutions include Project Management, Vendor Management, Business Analysis, Enterprise Data Governance and Stewardship, Application Development and 3rd Party Integration, Strategic and Secure Infrastructure and Operations. The Technology Solutions Department collaborates closely with Firm leadership and business unit heads to develop plans in line with business objectives.
Position Responsibilities
The Assistant Vice President will design and implement best-in-class data management solutions for metadata, master data and data quality management to enable data analytics capabilities across the Firm.
The successful candidate must be able to gain a deep understanding of relevant Firm business data and processes, enterprise data models and the data integration processes to help design and deliver strategic data solutions to manage firm's data asset, uncover enterprise insights and drive business results.
Responsibilities include:

• Serving as subject matter expert on Microsoft SQL Server and Azure Data Platform
• Designing, developing, testing and implementing solutions for the data management functions including metadata, master data and data quality management, with SQL, C#, Power BI, Azure Data Factory, Logic Apps, Event Hub and other vendor platforms
• Leading Data Architecture review sessions for the data acquisition and integration requests, providing recommendations to the team
• Independently executing complex data analysis across multiple platforms using SQL, Excel and Power BI
• Optimizing data infrastructure and implementing best practices
• Developing detailed requirements documentation including technical architecture design, use cases, business process diagrams with data flows, success criteria and user guides
• Ensuring that all delivered solutions meet the highest quality standards and satisfy business requirements through rigorous validation and testing
• Triaging support issues and provide support for the data management solutions
• Performing code reviews to ensure adherence to standards, responsible for overall quality and accurate implementation of developed solutions utilizing Azure DevOps repository and pipelines
• Lead SLA compliance; own performance tuning and optimization efforts of the data management solutions
• Confidently participate in meetings and manage frequent communications with key stakeholders and senior management

Candidate Requirements
Qualifications & Experience:

• Bachelor's Degree required preferably in Computer Science, Business, or related field
• 7+ years of experience in a similar role in the Financial Services industry
• 5+ years of experience in a Data Architect role including enterprise Data Architecture models, data governance principles, system integration and cloud data platforms
• Hands-on experience implementing metadata management and data quality solutions to manage data assets in complex organizations is required
• Experience delivering master data management solutions to organizations is required
• Expertise in architecting, designing and implementing data solutions with SQL Server and Azure data platform:
  • 4+ years of hands-on experience with Azure data component and services, including Azure SQL Database / Managed Instance, Azure Event Hub, Data Factory, Data Lake, Azure Logic App, Synapse, Azure Data Function and other related tools
  • 2+ years of experience in data warehouse implementation with SQL Server
  • 2+ years of experience building automated ETL/ELT or data integration processes with multiple source systems.
  • Experience with version control system and CI / CD pipeline in Azure DevOps
• Exceptional data analysis skills and strong attention to detail are required including leveraging SQL and Power BI to complete the analysis.
• Full lifecycle experience implementing data & analytics solutions with a working knowledge of agile development, SCRUM and DevOps
• Experience with Snowflake, Microsoft Purview or SQL Server Master Data Services is preferred
• Exceptional interpersonal, verbal, written and presentation skills
• Motivated by a fast-paced, growing, and complex environment, team-oriented and able to multitask
• Experience executing small to medium-sized projects and a general understanding of Project Management principles are desired
• Results-oriented with a high level of personal accountability
• Abide by our work-in-office policies then in effect

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.
• 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.
• 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.

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

• Technical Support: Triages, troubleshoots and resolves technical support issues. Escalates issues as needed.
• Software Development Principals: Utilizes software development, secure programming principles and a knowledge of programming languages to develop, configure and / or integrate new software and applications.
• Business Needs Assessment: Identifies business needs across departments within the Firm to understand the challenges, goals and problems that the business needs to solve and identifies appropriate technical solutions.
• Data Management and Information Security: Manipulates, restructures and / or queries data for various purposes, including reconciling issues in the database, designing database structures and / or generating reports. Adheres to governance principles and maintains data integrity and security.
• Risk Management: Identifies, forecasts and articulates ways to pursue and manage informed risks in ambiguous, complex or uncertain situations based on sound value propositions and an analysis of potential rewards and costs.
• Testing: Evaluates the functionality of an application, system or solution to ensure that requirements have been met and defects have been identified. Applies an understanding of end user requirements and usage in the end-to-end system to produce a quality product.
• Industry Knowledge: Demonstrates an understanding of the Firm's position in the industry, including its complex structure and competitive advantage in the marketplace. Monitors industry trends and changes and recognizes their relevancy and implications.
• Technical Communication and Documentation: Documents and communicates technical processes and procedures in area of specialty to stakeholders. Adapts the level of detail and specificity based on the needs of the intended audience.
• Vendor Management: Manages and coordinates with external vendors. Researches and identifies new vendors as needed and monitors performance.
• Relationship Management: Builds and maintains effective partnerships with internal clients and end users by advising on their needs and options, advocating for their business within the Technology Solutions department and managing expectations appropriately.
• Project / Program Management: Manages Technology Solutions project elements considering conflicting priorities, interdependencies, business objectives, communications and available resources.
• Innovative Mindset: Leverages an agile and creative mindset to drive innovative value creation, continuous process improvement and proactive learning through new technology, processes and people.

Compensation and Benefits
Compensation will be commensurate with experience. Golub Capital offers a full range of benefits which includes medical, dental, vision and 401(k).
Golub Capital is an Equal Opportunity Employer.