Company Description
Integres, LLC is a Service-Disabled Veteran Owned Small Business (SDVOSB) which was established to provide high quality, insightful, agile information technology-based solutions to its customers. Integrity is a foundational element of everything we strive to do. We seek to develop solutions which respond to the evolving challenges that today’s organizations face using our own unique combination of industry best practices, and evolving techniques and technologies. We started Integres with the intent of building "a company with a soul". As such, we take a servant-leadership approach as the long-term strategy for our success. We are cultivating a corporate family culture which demands excellence and accountability while putting a premium on work/life balance. We empower and support our employees to contribute to achieving our corporate goals by interacting with our customers as true partners, rather than treating their engagement as just another job. We seek to be good corporate citizens and encourage and promote employee participation in community and volunteer work.
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.
