Senior ETL & Data Integration Engineer

Perkins&Will; Chicago (IL); On-site; USD 120,000 - 160,000; Full time

Job summary

Perkins&Will is seeking a technically skilled data/financial systems professional in the Chicago area. You will oversee the design, implementation, and maintenance of financial systems, including accounting software, budgeting tools, and reporting systems.

Responsibilities include building and optimizing ETL workflows with SSIS, integrating data from databases, APIs, CSV/Excel/XML/JSON sources, and developing T-SQL queries and Power BI datasets for senior management reporting.

Qualifications

• Degree in CS/Software Engineering or related field.
• Experience with financial systems and data integration.
• Strong SQL skills including SSIS, T-SQL, and data modeling.

Responsibilities

• Oversee design and maintenance of financial systems and reporting.
• Lead ETL workflows using SSIS and integrate data from diverse sources.
• Develop and optimize SQL queries, stored procedures, and Power BI datasets.
• Collaborate with cross-functional teams on budgeting, forecasting, and project accounting.
• Provide data quality controls and audits to ensure integrity.

Education

Bachelor's/Master's in CS/Software Engineering

Tools

MS SQL Server

MS SQL Integration Services

Excel

Power BI

APIs (C# or Python)

XML/JSON data handling

Deltek APIs & frameworks

Job description

Perkins&Will is seeking a technically skilled data/financial systems professional in the Chicago area. You will oversee the design, implementation, and maintenance of financial systems, including accounting software, budgeting tools, and reporting systems.

Responsibilities include building and optimizing ETL workflows with SSIS, integrating data from databases, APIs, CSV/Excel/XML/JSON sources, and developing T-SQL queries and Power BI datasets for senior management reporting.