Data Engineer / Integration Architect

NYC Private Equity

J Harlan Group is currently conducting a search for a Data Engineer – Integration Architect at a prominent NYC Private Equity organization.

An exciting opportunity to join the firm’s Technology team designing and developing the infrastructure for evaluating, ingesting, parsing, and processing structured and big data sets. The Data Engineer – Integration Architect will work closely with investment professionals to design, implement, and scale the organizations overall data architecture.

This position will report directly to the VP, Data Strategy with primary focus on data integration & preparation, data as a service using API Management Services, and self-service data platform to provide a distinctive user experience for the firm’s mobile and global team of professionals, investors, and other stakeholders.

The firm views Technology / Data Strategies as a distinct commercial advantage - enabling a host of opportunities that differentiate them from their competitors.

The firm is a fast growing and dynamic investment organization that is experiencing exceptional growth and is looking for exceptional people to power its next phase of growth. The Data Engineer – Integration Architect will be a significant contributor in enabling their vision and helping the organization to grow and improve their businesses.

Principal Responsibilities:

The Data Engineer – Integration Architect will have the following responsibilities:

Data Integration & Preparation

• Responsible for architecture, design, administration, and development of Data Ingestion Layer as part of Data Strategy, especially using service-based architecture.
• Research and implement cloud-based tools in Data Integration space, like Talend Cloud, Azure Data Factory, Data Bricks, or Alteryx.
• Define and develop standards, configurations, and operational/administration guidelines for data integration layer to provide it as a service to Data Science and AppDev teams.
• Create integration jobs connecting to heterogeneous data sources like SaaS applications, hosted applications, private cloud applications, databases etc. using web-api’s, rest/soap api’s or varying data connectors.
• Develop ETL, ELT and other service-based integration jobs as part of overall Data application delivery.
• Provide Level 3 support for all data applications, especially for integration layer.

  Data as a Service

• Implement a centralized Semantic Layer using API services to provide data as a service to custom or cloud applications, mobile devices, search engines, reporting & analytics applications, and data science initiatives.
• Define and develop processes and controls around the data service layer so that Data Science or AppDev teams can provide or ingest data via the centralized service layer.
• Work with data team members in designing and developing the data classes within the data service layer.
• Build and maintain a repository of web endpoints for the centralized logical data service layer as part of forward-looking integration capabilities.
• Build complex data processing pipelines using control flow and data flow components for real time or batch jobs using Talend, Azure Data Factory or SSIS.

   

  Self-Service Data Platform

• Work with data team members to prepare data or provide real time data to de-centralized Data Lake, an Enterprise Data Hub or Data Warehouse, using latest cloud-based technologies like Snowflake and/or Azure Data Services.
• Collaborate with data team members in design and development of Enterprise Data Hub that can store, compute and query relational data, columnar data, and unstructured blobs.

   

  Data Design & Development

• Contribute towards all development of SQL and NOSQL scripts, tables, Views, stored procedures, extended functions in .Net/python etc. in data layer.
• Interact with data team members in design and development on overall data application delivery, including data ingestion & preparation, data design & development, and data analytics & reporting.
  

The ideal candidate would have a background and a deep passion for working with data and developing software to address data engineering / integration challenges

Required Experience:

• Technologist with a strong background in the architecture, design, and development of the Data Integration Layer using a service-based architecture
• At least 4+ years of experience working in the Finance industry
• Experience and competency with design and development of cloud-based data integration tools, especially Talend Cloud, and/or Azure Data Factory, Data Bricks, or Alteryx.
• Proficient in working with heterogeneous data sources, cloud providers like Salesforce, Workday, Box etc., data aggregators, web sources or relational/analytical data sources providing structured, semi-structured or unstructured data.
• Experience in data development tools like SQL Server, Snowflake, and Azure data services like Azure SQL, Azure Synapse, Azure Data Lake Services, CosmoDB, Redis Cache et al.
• Exposure to design & development using API services on Talend Cloud or Azure to provide data as a service, and BI & Reporting tools like Tableau.
• Working knowledge of any coding tool and their libraries like python, .Net or Java in building complex custom processing or calculation sub jobs
• Expertise in designing and managing logging, Stack trace, messaging, notifications, and all operational standards around integration processes using Talend or SSIS
• Ability to factor usability, performance, security, and maintainability requirements into software solutions.
• Familiarity with agile software engineering processes and ability to contribute to planning and reporting.
• Ability to work in an open collaborative and highly charged environment.
• Experience working in a dynamic, fast-paced, Agile team environment
• Strong interpersonal skills; able to establish and maintain a close working relationship’s
• Confident communicator
• Enthusiasm for learning & results oriented
• Strong desire to contribute and build a business – not just solve novel problems.
• Ability to work with a wide range of clients and technologists to develop and implement technology in support of a dynamically growing Private Equity platform

Required Education:

• Bachelor’s degree in Computer Science, management information systems, or equivalent working experience in information technology.

An individual who loves solving deep and complex technical and business problems and wants to have an outsized impact with the services/ products they deliver. An individual with a passion for data engineering, high level of intellectual curiosity, a commitment to excellence and an unparalleled drive to deliver world-class services.

About the Client:

The firm is a leading global growth equity firm with $35B in Assets Under Management (AUM), providing capital and strategic support for growth companies. The firm combines a collaborative global approach, sector specific expertise, long-term investment horizon, and a deep understanding of growth drivers to partner with great management and build exceptional businesses worldwide.

The talent and dedication of their people is critical to their success. They offer an opportunity for developing one’s professional career while working with individuals trained in a variety of disciplines in a collegial and dynamic environment. They offer a broad range of competitive benefits on a global basis.

They seek candidates who are high-energy self-starters who want to join an investment management firm on the leading edge of the global 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 management in a highly collaborative and charged 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. The firm has earned a reputation for honesty, fair dealing, and transparency in a competitive industry. They believe that these standards are the foundation for superior investment performance and are critical to delivering performance to clients

Posted On: Wednesday, May 5, 2021