Vice President Data Architect - Technology & Data Global Investment Firm J Harlan Group is currently conducting a search for a Vice President Data Architect - Technology & Dataat a prominent Global Investment Firm in NYC. My client's Technology & Data leadership team is seeking a highly skilled and experienced Data Architect to join their team. The role is based in our NY office. The ideal candidate will have a strong background in modern data architecture, with proficiency in Snowflake, Coalesce, Fivetran, and related technologies. This individual will play a key role in designing, implementing, and optimizing data solutions that support their organization's strategic objectives. The role is based in our NY office. The Technology & Data department is responsible for the delivery of enterprise technology, data and infrastructure services for the Global Investment firm.The team is a trusted advisor and partner to the business and is constantly innovating and leveraging best practices in support of the firm's continued growth. Responsibilities: Specific responsibilities will include but not be limited to the following:
- Design, develop, and maintain robust, scalable, and efficient data pipelines to extract, transform, and load (ELT/ETL) data from various sources into our data warehouse or data lake.
- Collaborate with data analysts, data scientists, and business stakeholders to understand data requirements and design data models that facilitate efficient data storage, retrieval, and analysis. Implement and optimize dimensional models such as star schema and snowflake schema.
- Integrate data from diverse sources including relational databases, APIs, flat files, and streaming data sources. Ensure data consistency, integrity, and quality throughout the integration process.
- Develop and implement data transformation processes to clean, enrich, and aggregate raw data into formats suitable for downstream analytics and reporting. Utilize modern data stack like Snowflake, Fivetran, Coalesce.io to do data transformation.
- Implement data quality checks, validations, and monitoring mechanisms to ensure data accuracy, completeness, and consistency. Develop and maintain data quality rules, standards, and metrics to measure and improve data quality over time.
- Collaborate with cross-functional teams to understand data requirements and develop scalable data architecture solutions, leveraging methodologies such as Medallion architecture, star schema etc to ensure flexibility, scalability, and maintainability.
- Establish and help maintain metadata repositories and data dictionaries to document data structures, transformations, and lineage across the organization, supporting effective data governance and data lineage tracing.
- Document data pipelines, data models, and data transformation processes. Collaborate with cross-functional teams including data analysts, data scientists, software engineers, and business stakeholders to understand data requirements and deliver solutions that meet business needs.
- Provide technical guidance to cross-functional teams on data architecture best practices and data management techniques.
- Stay current with emerging technologies, tools, and trends in data architecture, data management, and recommend innovative solutions to enhance organizational capabilities and effectiveness.
The ideal candidate would have a background:
Minimum of 7 years of experience in data architecture/engineering, with a proven track record of designing and implementing modern data solutions. Strong proficiency in Snowflake. Experience in ELT/ETL technologies like DBT, Coalesce, Fivetran, Python, and/or other relevant technologies. Demonstrate knowledge of best practices in authoring data pipelines with the modern data stack, including utilizing Snowflake Tasks, Streams, and Dynamic Tables to facilitate efficient data extraction, loading and transformation. In-depth knowledge of data modeling and architecture techniques like fact-dimensional modeling, data vault modeling, data mesh architecture etc. Experience working in the financial services industry required, with knowledge of asset management sector strongly preferred. Understanding of cloud computing platforms, with experience in platforms such as Azure considered advantageous. Excellent communication skills with the ability to effectively collaborate with stakeholders at all levels of the organization. Strong analytical and problem-solving skills with a keen attention to detail. Strong interpersonal skills and ability to forge relationships resulting in successful partnerships Enthusiasm for learning & results oriented Strong written and verbal communication Ability to work independently as well as on a team Required Education:
Strong academic record and a BA/BS or Master's degreein Computer Science, Information Systems or related field. About the Client: The firm is a leading global investment firm that seeks to provide creative capital solutions and generate attractive risk-adjusted returns for their clients. They manage various strategies across the capital structure that include syndicated leveraged loans and high yield bonds to privately negotiated senior secured debt and mezzanine investments, asset-based leasing and private equity. The scale and breadth of their platform offers the flexibility to invest in companies large and small, through standard or customized solutions. At our core, they share a common thread of intellectual rigor and discipline that enables them to create value for their clients, who have entrusted them with approximately $108 billion of assets under management as of December 2023. The firm has approximately 204 investment professionals and over 650 total employees and has fifteen offices globally. The firm believes in the importance of giving back to its communities and promoting diversity and inclusiveness at the firm. They are dedicated to fostering enduring community relationships, and they support their team's community involvement through volunteer work, board service, and other contributions. In addition, environmental, social, and governance (ESG) considerations are central to the firm's culture and investment processes. The firm is committed to promoting awareness and training both internally and externally. They seek candidates who are high-energy self-starters who want to join an investment management firm on the leading edge of financial markets. The management team needs individuals of the highest professional caliber who are leaders, problem solvers, analytic, detail-oriented, and entrepreneurial. Everyone at the firm works side-by-side with the firm's senior partners in a highly collaborative and charged investment environment. Successful candidates are:
- Analytic and relentless in pursuit of the right answer
- Strong communicators who excel at rapid synthesis
- Able to demonstrate sound business judgment
- Able to digest complexity while maintaining an understanding of the big picture of business needs
- Team players who are energized by a collaborative enterprise
The firm's employees maintain the highest professional and ethical standards. SALARY RANGE: - Expected base salary for this position is between $175,000 and $250,000 for candidates with a strong background in modern data architecture, with proficiency in Snowflake, Coalesce, Fivetran and related technologies.. However, base pay if hired will be determined commensurate with experience and is only a part of the total compensation package which includes eligibility for a discretionary bonus and a robust benefits package Hybrid Work Schedule
- 4/1 split (Monday-Thursday work from office, Friday work from home.)