> Markdown version of [/jobs/ext/1296921-senior-data-integration-programmer](https://www.wearedevelopers.com/jobs/ext/1296921-senior-data-integration-programmer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Senior Data Integration Programmer

- **Company:** Perkins+Will, Inc.
- **Location:** Chicago, IL, United States
- **Experience:** Expert
- **Salary:** $120,000.0
- **Contract:** Permanent contract
- **Skills:** Microsoft Excel, Application Programming Interfaces (APIs), Application Integration Architecture, C Sharp (Programming Language), Databases, Data Validation, Data Integration, Extract Transform Load (ETL), JSON, Python (Programming Language), Microsoft SQL Server, Parsing, Power BI, Software Engineering, SQL Stored Procedures, SQL Server Agent, SQL Server Integration Services, Systems Integration, Transact-SQL, Extensible Markup Language (XML), Data Processing, Postman, Information Technology, Tools for Reporting
- **Published:** July 16, 2026
- **Apply:** https://recruiting2.ultipro.com/PER1007PWILL/JobBoard/0ca393a4-bf82-4db6-acae-91e6a0315a4a/OpportunityDetail?opportunityId=be63ea7f-53bf-4a7d-8136-5c2cd1a4ea95

## About the Role

* 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

## Description

* 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


## Related Videos

- [Tips and Tricks for Working with JSON](https://www.wearedevelopers.com/videos/1229-tips-and-tricks-for-working-with-json)
- [Replacing Excel with SAP APIs & Python validation](https://www.wearedevelopers.com/videos/1944-replacing-excel-with-sap-apis-python-validation)
- [Are Your APIs Ready for AI Agents](https://www.wearedevelopers.com/videos/2004-are-your-apis-ready-for-ai-agents)
- [Introducing JSON Structure](https://www.wearedevelopers.com/videos/100219-introducing-json-structure)
- [Building a Compiler with C#](https://www.wearedevelopers.com/videos/116-building-a-compiler-with-c)
- [Why make use of an integration platform in today's software developments and infrastructure?](https://www.wearedevelopers.com/videos/758-why-make-use-of-an-integration-platform-in-today-s-software-developments-and-infrastructure)

## Related Articles

- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)
- [The 12 Best Jobs for Software Engineers](https://www.wearedevelopers.com/magazine/401-the-12-best-jobs-for-software-engineers)
- [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)