About the role
Our client, a real estate investment firm located in Chicago's western suburbs is looking for Data Engineer to replace a recently promoted individuals. This role will be responsible for analyzing and optimizing the organization's data engineering practices and work closely with various stakeholders to ensure that technology solutions align with business objectives and outcomes. This a hybrid position and will require 3 days per week in their west suburban office.
CORE RESPONSIBILITIES:
• Assist in the software development lifecycle (SDLC), leading the design and development of databases, data pipelines, platform data integrations, and identified related system components.
• Participate in short- and long-term planning to improve data applications and work closely with project stakeholders to ensure all systems are aligned with business outcomes.
• Proactively analyze existing data applications to identify weaknesses, develop opportunities for improvements, and assist in the evaluation for enhancements and new data integrations.
• Research and recommend third-party data solutions. Maintain knowledge of unique data applications by participating in user groups and networking with users.
• Work with scrum teams and project stakeholders to gather requirements, assess performance metrics, and address any issues that arise.
• Assist in creating and implementing all phases of application testing from unit test to system test to acceptance testing. Develop comprehensive end-to-end test cases at the application and multi-application levels.
• Participate in system upgrades and enhancements for software systems, as needed. Work with vendors to manage upgrades, enhancements, patches, and fixes on a timely basis. Provide general oversight to vendors of hosted systems.
• Maintain thorough documentation of development and application changes, performance metrics, and technical procedures.
• Assist in supporting and identifying resolution of incidents which involve data applications, ensuring minimal disruption to operations.
• Demonstrate the highest standards of personal and professional integrity, adhere to company’s policies and procedures, and comply with applicable laws, government rules and regulations.
QUALIFICATIONS:
• Bachelors degree in computer science, information technology, data science, or related field.
• 2+ years of experience as a data engineer, or in a similar role, preferably within an IT environment with focus on investment management and data foundation operations.
• Experience in financial services, private equity, alternative investments, and/or real estate preferred
• Strong experience with data configuration and data engineering, including practice standards, code reviews, source control management, build process, and testing.
• Experience working through the software development life cycle and agile frameworks, across all development phases including design, development, testing, implementation, deployment, and maintenance.
• Deep understanding of SQL, Azure SQL, Azure Data Factory, Azure Key Volt, Azure Data Functions, SQL Managed Instance, Azure App Service, Azure Blob Storage, GitHub, SSIS.
• Deep understanding of cloud data engineering, pipelines, standards, concepts and data orchestration.
• Deep understanding of database administration and database modeling and design.
• Strong understanding of cloud data warehousing or data lakes.
• Basic understanding of data governance, stewardship, and semantic layer.
• Flexible and responsive to changing priorities and solutions-oriented mindset.
• Must be driven and focused on business outcomes and delivery of business value.
• Outstanding written and verbal communication skills with demonstrated ability to communicate effectively with all levels of an organization.
• Ability to work both with a team and independently with minimal supervision.
• Ability to engage effectively and professionally in both a one-on-one and group settings with third parties such as clients, peers, and vendors.
• Experience with Snowflake and other data warehouse platforms is a plus.
• Experience with Active Batch and other job orchestrator is a plus.
• Experience with agentic data practices and engineering is a plus.