Data Engineer

Career Search Partners is an elite investment firm seeking a Data Engineer to join their growing team. The role is pivotal in developing the company's data strategy and involves building a world-class data engine to support investment decision-making and reporting initiatives.

Responsibilities:

• Expand our data warehouse, managing existing processes and feeds, and incorporating new data sources
• Build processes in SQL & Python related to data flows into and out of a SQL server data warehouse (data sources include third-party vendors, APIs, admins, etc)
• Manage internal mapping tables for critical data such as underlier roll-ups, custom tagging, ticker mapping across vendors, etc
• Ensure data quality by continuing data check development and correcting errors highlighted in daily data check reports
• Continue core development of business processes and reporting requirements across the organization, including ETL
• Maintain and expand the ETL and data management repo
• Handle ad-hoc data requests across the Firm to support internal needs. Respond by providing excel, PDFs, slides or dashboards
• Handle month and quarter-end reporting for marketing, finance, and data science teams
• Maintain and enhance web-based dashboards that serve the organization
• Consultatively engage with stakeholders across the organization to identify business requirements and drive automated workflows to advance outcomes

Requirements:

• 3+ years of SQL experience, with the DDL for new tables, indices, views, stored procedures
• Python experience with the ability to build data flow processes with SQL server or other relational databases
• Development in a Git environment adhering to best practices around code quality
• Experience working with market data or exposure to investing and portfolio management. Exposure to security master and data warehouse concepts a plus
• Ability to work in an agile-type development environment, with strong communication skills for cross-functional requirements gathering and stakeholder management. This individual will need to work across multiple teams simultaneously
• Proactive with a mind toward efficiency in the process and systems that we build and a keen interest in the effectiveness of the solutions we create
• Exceptional attention to detail with the ability to produce error-free work and quickly find issues within a dataset
• Passion for and understanding of equity capital markets