Sr. SQL & SSIS Developer

Senior SQL & SSIS Developer - Greater Denver Area, CO - Remote FTE (First 1-2 months onsite)- 100 to 120K + Benefits - Residents of Denver Metropolitan Area or Willing to relocate without financial assistance

About Cogent Infotech

At Cogent Infotech, we create opportunities that empower individuals and transform organizations. With over 21 years of excellence in consulting and talent solutions, we build inclusive workplaces and drive innovation across both public and private sectors.

Position Overview

We are seeking a high-performing Senior SQL & ETL (SSIS) Developer to join our public sector client’s Enterprise Systems & Data Services team in a permanent, hybrid FTE role in the Greater Denver Area. In this position, you will lead complex product development, build robust data warehousing solutions, and architect high-impact enterprise systems.

Responsibilities

1. Architect, develop, test, and deploy complex relational databases and data solutions to ensure high performance and reliability.

2. Diagnose, troubleshoot, and resolve complex software and system issues to maintain continuous operational integrity.

3. Development and technical support for core operating systems and database management platforms.

4. Partner with cross-functional teams and clients through the full project lifecycle, establishing efficient production execution schedules.

5. Evaluate new software programs for optimal logic and accuracy while mentoring junior developers on programming tasks.

6. Conduct continuous systems analysis and modernization to align data infrastructure with evolving technologies.

7. Maintain comprehensive technical documentation across modular code, system architectures, and database configurations.

8. Design and deliver tailored system and technical training sessions to empower end-users and stakeholders.

9. Execute additional technical and enterprise data initiatives as needed.

Technical Skills & Competencies

• Data Modeling & Architecture: Advanced knowledge of logical/physical data modelling (e.g., Analysis Server), 2-tiered/3-tiered architectures, and Data Mart design.
• Database & ETL: Expertise in T-SQL, relational database theory, ETL (SSIS) toolsets, and OLAP technologies.
• Programming & Frameworks: Proficiency in C#, .NET, Visual Basic, JavaScript, HTML, and XML; strong object-oriented programming background.
• Business Intelligence: Hands-on experience with Crystal Reports and Microsoft BI tools.
• Infrastructure & Systems: Solid understanding of servers, mainframes, networks, and general operating environments.

Job Details & Application Process

• Role Type: Permanent FTE (Remote after 1-2 months onsite- flexible)
• Openings: 1 Position
• Start Date: ASAP
• Interview Process: Initial phone screen followed by an on-site interview for qualified candidates.

Benefits

• Comprehensive Coverage: Benefit-eligible employees enjoy full medical, dental, vision, and life insurance coverage.
• Day-One Benefits for All: Regardless of hours worked, all employees gain immediate access from day one to the Employee Assistance Program (EAP), voluntary life insurance through PERA, and robust retirement options—including 401(k), 403(b), and 457(b) plans.
• Paid time off

Equal Opportunity & Diversity

Cogent Infotech is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment where everyone feels welcome and valued. If you are excited about this role, even if you don't match every qualification perfectly, we still encourage you to apply!