Senior Data Integration Programmer

Perkins & Will Inc.; Minneapolis (MN); On-site; USD 144,000 - 176,000; Full time

Job summary

Perkins & Will Inc. in Minneapolis/Chicago is seeking a skilled data/BI professional to design, implement, and maintain financial data platforms, ETL pipelines, and reporting systems.

You will build SSIS-based ETL workflows, integrate Deltek APIs, and deliver accurate financial insights via Power BI while collaborating with cross-functional teams in a fast-paced environment.

Qualifications

• Experience designing and maintaining ETL workflows and data pipelines.
• Strong SQL and data modeling skills.
• Experience with Deltek APIs and BI/reporting tools.

Responsibilities

• Oversee financial systems design, implementation, and maintenance.
• Collaborate with cross-functional teams to translate business needs into scalable data solutions.
• Ensure data integrity through audits and controls.
• Develop and optimize ETL workflows using SSIS and SQL.
• Build data models, stored procedures, views, and functions to support ETL and Power BI.
• Create APIs using C# or Python and integrate with Postman.
• Parse XML/JSON data from diverse sources and maintain data pipelines.
• Lead software development projects with cross-functional partners.
• Provide regular financial reports to senior management.

Skills

ETL development

SQL Server

SSIS

Power BI

C# / Python

APIs integration

Deltek API

Data modeling

Data quality

Cross-functional collaboration

Communication skills

Problem solving

Education

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

Tools

MS SQL Server

SSIS

Power BI

Postman

Deltek API

Python

C#

XML/JSON parsing

Job description

Chicago 410 North Michigan Avenue Suite 1600 Chicago, IL 60611, USA

Responsibilities & Qualifications

• Oversee the design, implementation, and maintenance of financial systems, including accounting software, budgeting tools, and reporting systems.
• Collaborate with cross‑functional teams to understand business requirements and deliver scalable data solutions
• Ensure the integrity of financial data through regular audits and controls.
• Identify opportunities for system improvements and collaborate with cross‑functional teams to implement changes.
• Prepare and present financial reports to senior management, highlighting key insights and performance indicators.
• Collaborate with department heads to develop annual budgets and forecasts.
• Support project managers in tracking project budgets and financial performance.
• Design, develop, and implement ETL workflows using SQL Server Integration Services (SSIS) to meet business and data processing needs
• Integrate and process data from diverse sources, including databases, APIs, CSV, Excel, TXT, XML, and JSON files
• Develop, optimize, and maintain T‑SQL queries, stored procedures, views, and functions to support ETL processes and Power BI datasets
• Build custom ETL components and scripts using C# and Python for advanced data processing
• Design and maintain data models, database schemas, tables, views, and indexes
• Implement data validation and cleansing processes to ensure high data quality
• Monitor, troubleshoot, and optimize data integration workflows and SQL Agent jobs
• Strong understanding of software development methodologies and best practices
• Demonstrated ability to lead software development projects and work collaboratively in cross‑functional teams
• Excellent problem‑solving skills and attention to detail
• Strong written and verbal communication skills
• Ability to adapt to changing priorities and work effectively in a fast‑paced environment
• Understanding of professional services industry workflows (project accounting, billing, time & expense, budgeting, CRM)

Software:

• MS SQL Server, MS SQL Integration Services, Excel
• Proven experience developing and integrating APIs using C# (or) Python and Postman
• Strong experience working with and parsing XML and JSON data formats
• Experience working with Deltek APIs and integration frameworks
• Experience with Deltek Vision or Deltek Vantagepoint preferred
• Minimum of 2 years' experience with Power BI or other BI/reporting tools

Licensure/Certifications/Education

• A bachelor's or master's degree in computer science, Software Engineering, or a related field required

We foster a culture that is diverse and inclusive and strive for pay practices that are fair, and competitive and reflect our commitment to pay equity. Our compensation decisions include but are not limited to a candidate’s qualifications including skill sets, education, experience and training, licensure and certifications credentials if applicable, and business‑related factors. This practice extends to all employees, including performance considerations for merit increases, job promotions, and transfer opportunities. We additionally review our pay practices, conduct pay equity audits, and ensure our managers are trained in our pay practices on an annual basis. At the time of posting this job advertisement, commensurate with qualifications, the annual pay salary range for this position in Minneapolis or Chicago is between $120,000 and 160,000.

Perkins&Will has established and adopted an Equal Employment Opportunity Employment policy (“EEO”), which is part of the Company’s Human Resources Policy. The purpose of this EEO policy is to ensure that all employment decisions are made on a non‑discriminatory basis, and without regard to sex, race, color, age, national origin, religion, disability, genetic information, marital status, sexual orientation, gender identity or expression, gender reassignment, citizenship, pregnancy or maternity, veteran status, or any other status protected by applicable national, federal, state, or local law. In some cases, local laws and regulations may provide greater protections than those outlined here and employees will be covered by the laws of their local jurisdiction.

Perkins&Will will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities. This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.