Data Engineer I / ADF / Databricks / MS Fabric / Hybrid in Chicago

Job description A global advisory and investment services firm is looking for a Data Engineer to join their growing technology team in downtown Chicago. This role will focus on supporting and improving the company's proprietary private market databases used by internal teams across investment banking, valuations, and advisory services. As part of the Information Technology team, you will help design and maintain data pipelines, database architecture, and data governance processes that support analytics and operational reporting. This role is ideal for someone who enjoys working with complex data systems and wants to play a key role in modernizing data infrastructure within a collaborative and fast-paced environment. Required Skills & Experience 5+ years of experience in data engineering, database administration, or related roles Strong SQL expertise with experience in relational database design and optimization Experience building and maintaining data pipelines and ETL/ELT workflows Proficiency with Python or another scripting language for data automation Experience working with SQL Server or similar relational databases Experience integrating multiple data sources and complex data environments Exposure to modern cloud data platforms such as Azure, Databricks, Snowflake, or similar Experience working with structured and semi-structured data Strong collaboration and communication skills Desired Skills & Experience Experience with Azure Data Factory, Microsoft Fabric, or Databricks Experience supporting data governance or master data management (MDM) initiatives Experience maintaining data documentation, metadata, and data dictionaries Experience modernizing legacy data infrastructure or addressing technical debt Exposure to Salesforce data integrations Experience working with financial or investment data Familiarity with financial data platforms such as FactSet, Bloomberg, CapIQ, or PitchBook What You Will Be Doing Tech Breakdown SQL Server, Python, Azure Data Factory, Microsoft Fabric, Databricks, Salesforce Daily Responsibilities Design, build, and maintain data pipelines and ETL/ELT processes to support analytics and reporting Assist in developing and maintaining database schemas and data structures Support data quality improvement initiatives and data governance practices Maintain and update data dictionaries, documentation, and metadata Collaborate with engineering teams to modernize data infrastructure and reduce technical debt Assist with master data management initiatives to ensure data consistency across systems Support database performance optimization and system reliability Research and evaluate new data engineering tools and best practices The Offer You Will Receive The Following Benefits Competitive salary Comprehensive benefits package Flexible work environment (Chicago) PTO Medical, dental, and vision insurance 401(k) Applicants must be authorized to work in the U.S. on a full-time basis now and in the future.

Posted By:

Olivia Policastro Keywords azure-databricks databricks insurance-consulting-and-technology investment-banking advisory-services information-technology information-and-communication-technology-ict planning-and-design visual-art-design product-development-and-design data-pipeline data-governance customer-support-analytics analytics data-analytics reporting-and-disclosure adaptive-project-management-and-reporting data-modernization data-infrastructure-modernization environment-health-and-safety-hsse ecology-environment data-engineering database-administration database-management sql extract-transform-and-load-etl electronic-title extract-load-transform-elt python scripting data-automation cloud-data data-platform microsoft-azure snowflake azure-data-factory microsoft-fabric master-data data-management master-data-management-mdm mobile-device-management legacy-data technical-debt salesforce financial-data factset pitchbook microsoft-sql-server data-structures data-quality policies-and-practices performance-optimization flexible-working paid-time-off vision-care vision-insurance time-and-attendance