Job Description

We are seeking an experienced Database Developer to design, develop, maintain, and optimize enterprise database solutions supporting critical business applications. The selected consultant will work on database development, ETL processes, data integration, migration, reporting, and performance optimization while ensuring the accuracy, reliability, and integrity of enterprise data.

This role also includes production support and close collaboration with cross-functional teams throughout the Software Development Life Cycle (SDLC) using Agile methodologies.

Key Responsibilities

Design and maintain enterprise databases, including stored procedures, indexing, views, SQL scripts, and database objects.
Develop and optimize ETL pipelines and workflows using SSIS, Python, PySpark, and SQL Server.
Build data ingestion and transformation workflows across raw, staging, curated, and analytics data layers.
Develop and optimize SQL scripts and stored procedures for data conversion, validation, and ongoing processing.
Execute large-scale data migration projects, including data cleansing, validation, and transformation across enterprise systems.
Design and implement logical and physical data models (ERDs).
Develop database components supporting transactional and reporting systems.
Build and maintain reporting solutions using SSRS and Power BI.
Monitor, troubleshoot, and optimize SQL Server database performance.
Provide production support, including troubleshooting performance issues and participating in on-call support when needed.
Collaborate with developers, business users, QA teams, and project stakeholders.
Participate in Agile ceremonies, development activities, code reviews, testing, and release cycles.
Provide technical documentation and knowledge transfer.

Qualifications

10+ years of experience in Database Development or Data Engineering.
Strong expertise with Microsoft SQL Server, T-SQL, and SQL performance tuning.
Hands-on experience with SSIS, Python, and/or PySpark for ETL development.
Strong experience with data modeling, data integration, and database design.
Experience developing Stored Procedures, Views, SQL Scripts, and other database components.
Experience executing enterprise-scale data migration, cleansing, validation, and transformation projects.
Experience building reporting solutions using SSRS and Power BI.
Strong understanding of indexing strategies, query optimization, and database performance tuning.
Experience working in Agile/Scrum environments.
Excellent analytical, troubleshooting, and communication skills.

Preferred Qualifications

Experience with Azure DevOps, GitHub, or Jenkins.
Experience supporting mission-critical applications in Government, Financial, or Legal environments.
Previous State or Government project experience is a plus.

Additional Information

Integres offers competitive salaries bolstered by a comprehensive benefits package, which provides safety and security for our employees and their families. Our generous benefits package includes:

Healthcare and Insurance: medical, dental, vision, short and long-term disability protection, basic life and AD&D insurance
401(k) Savings Plan
Accrued Paid Time Off (PTO)
Employee Recognition and Rewards
Employee Referral Bonuses

Integres is an equal opportunity affirmative-action employer. We encourage Minority/Female/Protected Veteran/Disabled applicants to apply. Integres, LLC proactively fulfills its role as an equal opportunity employer. We do not discriminate against any employee or applicant for employment because of race, color, sex, religion, age, sexual orientation, gender identity and expression, national origin, marital status, physical or mental disability, status as a Disabled Veteran, Recently Separated Veteran, Active Duty Wartime, or Campaign Badge Veteran, Armed Forces services Medal, or any other characteristic protected by law.

All your information will be kept confidential according to EEO guidelines.