Senior ETL & BI Data Engineer

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

Job summary

Perkins & Will is seeking an experienced Data/BI Engineer in Minneapolis to design and maintain financial data systems and ETL pipelines. You will implement SSIS-based workflows, develop T-SQL queries, and support Power BI datasets for reporting and analytics.

You will collaborate with cross-functional teams to translate business needs into scalable data solutions, ensure data quality, and integrate data from diverse sources including APIs, CSV, XML, and JSON formats.

Qualifications

• Bachelor's or master's degree in computer science, software engineering, or related field.
• Power BI experience with at least 2 years in BI/reporting tools.
• Experience with Deltek APIs and integration frameworks.
• Strong understanding of software development methodologies and project teamwork.

Responsibilities

• Oversee the design, implementation, and maintenance of financial systems and reporting.
• Collaborate with cross-functional teams to deliver scalable data solutions.
• Ensure the integrity of financial data through audits and controls.
• Develop and optimize ETL workflows using SSIS and SQL.
• Build and maintain data models, schemas, and SQL queries for ETL and Power BI datasets.
• Integrate data from databases, APIs, and file formats (CSV, Excel, XML, JSON).

Skills

SSIS

SQL

Power BI

C#

Python

Data modeling

ETL development

APIs

JSON/XML

Data quality

Education

Bachelor's or Master's in CS/Software Engineering or related field

Tools

Deltek API

Deltek Vision/Vantagepoint

Postman

SQL Agent

Job description

Perkins & Will is seeking an experienced Data/BI Engineer in Minneapolis to design and maintain financial data systems and ETL pipelines. You will implement SSIS-based workflows, develop T-SQL queries, and support Power BI datasets for reporting and analytics.

You will collaborate with cross-functional teams to translate business needs into scalable data solutions, ensure data quality, and integrate data from diverse sources including APIs, CSV, XML, and JSON formats.