Senior Data Integration Programmer
About The Position
The Senior Data Integration Programmer designs, develops, implements, and maintains data integration workflows and financial data systems. The role uses SQL Server Integration Services (SSIS), T-SQL, C#, and Python to process data from databases, APIs, and file formats including CSV, Excel, TXT, XML, and JSON. It also supports Power BI datasets and other reporting needs by developing and optimizing database objects, data models, and data quality processes. The position includes overseeing financial systems such as accounting software, budgeting tools, and reporting systems; collaborating with cross-functional teams on business requirements and scalable solutions; and supporting financial integrity through audits and controls. It also contributes to system improvements, financial reporting, budgeting, forecasting, and project financial performance tracking. The job posting lists an annual salary range of $120,000 to $160,000 for Minneapolis or Chicago, commensurate with qualifications.
Requirements
- Bachelor's or master's degree in computer science, software engineering, or a related field.
- 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, including project accounting, billing, time and expense, budgeting, and CRM.
- Experience developing and integrating APIs using C# or Python and Postman.
- Strong experience working with and parsing XML and JSON data formats.
- Minimum of 2 years' experience with Power BI or other BI/reporting tools.
Nice To Haves
- Experience with Deltek APIs and integration frameworks.
- Experience with Deltek Vision or Deltek Vantagepoint.
Responsibilities
- 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).
- Integrate and process data from databases, APIs, and 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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
