Data Engineer

ICONIQ Growth partners with exceptional entrepreneurs and leaders who drive global impact and change. We are inspired by visionaries defining the future of their industries by building company cultures that endure. Our unique investment platform harnesses the power of ICONIQ Capital’s vibrant ecosystem of founders, pioneers, and business leaders with the goal of delivering tangible value and amplifying our portfolio companies’ success from early growth stage to IPO and beyond. ICONIQ Growth’s portfolio of innovators include Adyen, AirBnB, Alibaba, Alteryx, Automattic, BambooHR, Braze, Chime, Collibra, Coupa, Datadog, Docusign, Gitlab, Marqeta, Miro, Procore, Red Ventures, Relativity, ServiceTitan, Snowflake, Sprinklr, Truckstop, Uber, Wolt, and Zoom, among others. For more information and a complete list of portfolio companies, please visit ICONIQGrowth.com.

OPEN POSITION: Data Engineer

Seeking a full stack Data Engineer to work on Data Warehouse and Business Intelligence solutions for ICONIQ Growth.  You will report to the Head of Data to deliver solutions in data warehousing and analytics to business users in ICONIQ Growth. 

We are looking for a dynamic individual to help build a scalable data & analytics infrastructure. The Data Engineer will join the Data and Business Intelligence team, but will also work closely with Growth investment team. This individual will be directly involved in the development of new products, tools, and applications.

This is an excellent opportunity to work at a unique and growing firm while providing major impact across multiple parts of the business. You will directly contribute to how we test, adopt, and improve our technology and data solutions.

PRINCIPAL RESPONSIBILITIES:

• Work with ICONIQ Growth users to gather requirements, evaluate to identify opportunities/risks, interdependencies and design/develop long-term/scalable solutions.
• Enhance existing data platform and create new data solutions for firm's most important business priorities.
• Implement pro-active exception handling & notification systems to ensure consistently high quality data and resolve inconsistencies.
• Create high quality documentation of your work based on firm standards and protocols, summarizing your findings and recommendations effectively, to individuals at various levels in the organization
• Develop and maintain technical specification documentation for data flows and reports/dashboards.
• Provide detailed analysis, design, tuning, testing, implementation and documentation of the data architecture, schema and consumption process
• Design and develop data ingest and transform processes to automate business process
• Design and model data structures to support daily, operational and ad hoc reporting
• Own and support production data warehouse and API’s
• Work with data infrastructure to triage infrastructure issues and drive to resolution
• Provide Self Service BI/Analytics solutions to enable folks to consume and understand data faster – therefore leading to faster-time-to-market, more user-adoption & engagement across the firm.
• Establish key KPIs and measurements of success and report on status, outcomes, delivery timelines and improvements on a continual basis.
• Create data visualizations and business intelligence dashboards using software such as Tableau
• Create Scalable Automation Solutions using RPA tools to drive efficiency & eliminate manual processing.
• Effectively manage your time and lead platform development efforts for the line of business
• Ability to work with some level of ambiguity and drive roadmap or execution of vision

QUALIFICATIONS:

• BS/BA in Technical Field, Computer Science, Mathematics, Statistics or equivalent experience.
• 6 years experience in building and enhancing data warehouses.
• 6 years experience in custom ETL design, implementation and maintenance.
• 6 years experience with schema design, star schema and dimensional data modeling.
• 6 years experience in writing SQL statements.
• Report authoring experience. Working knowledge of reporting tools like Tableau, Looker, SSRS, Qlik etc.
• Experience in analyzing data to identify deliverables, gaps, and inconsistencies.
• Experience in identifying and communicating data-driven insights.
• Experience with Python, JavaScript/TypeScript or other modern programming language
• Experience with web programming and HTTP based APIs (REST or GraphQL)
• Experience with modern Frontend frameworks, preferably Angular or React
• Ability to translate business questions to technical specifications.
• Strong communication skills
• Experience analyzing large, complex, data sets.
• Experience with Software Development Life Cycle is preferred.
• Experience in private equity, finance, or trading environments a plus.
• Must be a highly motivated, self-driven, solution and detail-oriented individual with the desire to work in a fast-paced, entrepreneurial environment.
• Experience with Talend, Tableau, Snowflake, Salesforce a plus
• Experience with RPA tools like UiPath a plus.

LOCATION:

• San Francisco or New York

Effective 9/30/2021, all job offers shall be contingent upon the job applicant submitting proof that they are fully vaccinated by their start date or have obtained an approved medical or religious exemption as an accommodation.  Per CDC Guidance,  people are considered fully vaccinated for COVID-19 ≥2 weeks after they have received the second dose in a 2-dose series (Pfizer-BioNTech or Moderna), or ≥2 weeks after they have received a single-dose vaccine (Johnson & Johnson [J&J]/Janssen).  At present, only fully vaccinated employees are allowed in the Firm’s offices.