Basic information

Job Name:

Snowflake Architect

Location:

Washington, DC

Line of Business:

Global Technology & Solutions

Job Function:

Investor Services

Date:

Wednesday, January 10, 2024

Position Summary

We are looking for a data architect/snowflake expert to help implement and coordinate the data and reporting roadmap for Carlyle's Investment Solutions (fund of funds) segment.

Investment Solutions is a critical segment for Carlyle and is poised for significant growth in the future. This position will support that growth by providing architectural and technical leadership to envision and design modernized data platforms and practices within the segment. They will also work hands on with other data practitioners, developers, and stakeholders to deliver on those designs as well as the implementation and integration of various business systems throughout the segment. The architect will work with their peers throughout the enterprise to write, monitor, and enforce standards and policies for data management and technical delivery.

The primary focus in the near term will be to enhance and streamline our new Snowflake data warehouse and surrounding ecosystem including SnapLogic for data engineering, and Sigma and PowerBI for reporting. Responsibilities also include maintenance of our legacy MSSQL warehouse as we work to migrate all its functions into Snowflake and ultimately sunset that platform. The architect will also play a role in selecting and implementing other data related tools including data catalog, MDM, lineage, and quality to round out a complete data platform. The ideal candidate will be able to view and contribute to each of these efforts as both an architect and hands-on implementer.

This role will also work closely with the domain architect to plan and oversee work done by teams of contractors and implementation partners on other systems used by Investment Solutions including Appian for Workflow and BPM efforts. Candidates should be comfortable working using agile management methodologies involving multiple stakeholders.

Responsibilities

• Implement and advise on best practices for Snowflake data modeling and performance.
• Implement and advise on best practices for data engineering and reporting.
• Oversee delivery team leads across investment solutions systems to coordinate and ensure high quality delivery.
• Work with stakeholders and other developers on design, implementation, and documentation of complex data systems and solutions to meet business needs.
• Work with product owners, domain architects, and program managers to prioritize technical work items based on impact to maintain healthy up to date platforms.
• Work with dev teams and stakeholders to ensure proper testing of deliverables occurs prior to final delivery.
• Work with security and infrastructure teams to ensure alignment to standards and best practices.
• Provide technical guidance on data management best practices for Governance, MDM, Quality, Lineage, Catalog, etc.
• Supervise contractors and third-party implementation partners as needed.

Our Tech Stack

• Snowflake
• Snaplogic
• Microsoft SQL Server Products
• Power BI
• Sigma Computing
• Appian
• Business Systems: (Anaplan, Chronograph, Investran, DealCloud, Salesforce)

Qualifications

Education & Certificates

• Bachelor's degree, required
• Concentration in computer science or related technical discipline, preferred
• Cloud and/or Data related certifications are a plus.

Professional Experience

• 7+ years of relevant experience with data related technologies, required
• 3+ years of experience with Snowflake, required
• Experience with entity relationship modelling, data architecture layers and design, metadata systems and tools, data quality tools and techniques.
• Experience using major data modelling tools.
• Experience designing and creating reports in a modern data reporting/dashboarding platform.
• Experience and understanding of major data architecture philosophies.
• Experience in working with SaaS software solutions and cloud compute environment.
• Experience with cloud architectures focused on analytics, data management and usage patterns.
• Experience with at least one programming or scripting language.
• Experience working with Agile software delivery frameworks.
• Experience leading software delivery teams and coordinating amongst multiple delivery teams.

Competencies & Attributes

• Good working knowledge of Traditional ETL, ELT, Data Warehousing and Data Marts
• Understanding of the operational dependencies of applications, networks, systems, security, and policies
• Software Development Lifecycle (SDLC) knowledge
• Working knowledge of Agile Methodology
• Excellent leadership, communication, collaboration, and interpersonal skills

Company Information

The Carlyle Group (NASDAQ: CG) is a global investment firm with $382 billion of assets under management and more than half of the AUM managed by women, across 600 investment vehicles as of September 30, 2023. Founded in 1987 in Washington, DC, Carlyle has grown into one of the world's largest and most successful investment firms, with more than 2,200 professionals operating in 28 offices in North America, South America, Europe, the Middle East, Asia and Australia. Carlyle places an emphasis on development, retention and inclusion as supported by our internal processes and seven Employee Resource Groups (ERGs). Carlyle's purpose is to invest wisely and create value on behalf of its investors, which range from public and private pension funds to wealthy individuals and families to sovereign wealth funds, unions and corporations. Carlyle invests across three segments - Global Private Equity, Global Credit and Investment Solutions - and has expertise in various industries, including: aerospace, defense & government services, consumer & retail, energy, financial services, healthcare, industrial, real estate, technology & business services, telecommunications & media and transportation.

At Carlyle, we know that diverse teams perform better, so we seek to create a community where we continually exchange insights, embrace different perspectives and leverage diversity as a competitive advantage. That is why we are committed to growing and cultivating teams that include people with a variety of perspectives, people who provide unique lenses through which to view potential deals, support and run our business.