Position Summary

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

Investment Solutions is a critical segment 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. You 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. You will work with 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. You 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 modeling, data architecture layers and design, metadata systems and tools, data quality tools and techniques.
• Experience using major data modeling 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

Benefits/Compensation

The compensation range for this role is specific to Washington, D.C., and takes into account a wide range of factors including but not limited to the skill sets required/preferred; prior experience and training; licenses and/or certifications.

The anticipated base salary range for this role is $170,000 to $190,000.

In addition to the base salary, the hired professional will enjoy a comprehensive benefits package spanning retirement benefits, health insurance, life insurance and disability, paid time off, paid holidays, family planning benefits, and various wellness programs. Additionally, the hired professional may also be eligible to participate in an annual discretionary incentive program, the award of which will be dependent on various factors, including, without limitation, individual and organizational performance.

Due to the high volume of candidates, please be advised that only candidates selected to interview will be contacted by our client.