SQL & ETL Developer

Insight Global; Thornton (CO); Hybrid; USD 99,000 - 150,000; Full time

Job summary

Insight Global in Thornton, CO is seeking a Senior Software Engineer to design, develop, test, and maintain complex software applications, relational databases, and data warehousing systems. You will troubleshoot issues, support OS and DB management, contribute to product architecture, and collaborate across departments throughout the full development lifecycle.

This direct hire role offers a hybrid schedule with 4 days on-site in Thornton and a salary range of $99,000-$149,968 based on

Qualifications

• Bachelor’s degree or 4 additional years of relevant experience in place of the degree.
• 5+ years of software engineering experience.
• 5+ years of experience with systems analysis, software development, programming methodologies, design, and implementation.
• Advanced knowledge of logical and physical data modeling.
• Advanced knowledge of 2-tiered and 3-tiered architectures.
• Advanced knowledge of data warehousing methodologies and Data Mart design.
• Advanced knowledge of SQL Server dialect, relational database theory, ETL toolsets, and OLAP technologies.
• Strong object-oriented programming skills.
• Strong communication, interpersonal, and documentation skills.

Responsibilities

• Design, develop, test, implement, and maintain complex software applications, relational databases, and data warehousing systems.
• Troubleshoot software and client issues, support operating systems and database management systems.
• Contribute to product architecture and collaborate across departments and clients throughout the full development lifecycle.
• Test programs for accuracy, maintain technical documentation, and mentor lower-level programmers.

Skills

Software engineering

Systems analysis

Programming methodologies

Data modeling

2-tier architecture

3-tier architecture

Data warehousing

SQL Server

Object-oriented programming

Documentation

Education

Bachelor's degree

4+ years related experience in lieu of degree

Tools

ETL tools

Analysis Services

Crystal Reports

Microsoft tools

Job description

Location: Thornton, CO - 3-4 days ONSITE

Duration: Direct hire with the client

Pay Range: $99,000-$149,968

Must Haves:

• Bachelor’s Degree or 4 additional years of relevant experience in place of the degree
• 5+ years of software engineering experience
• 5+ years of experience with systems analysis, software development, programming methodologies, design, and implementation
• Advanced knowledge of logical and physical data modeling
• Advanced knowledge of 2-tiered and 3-tiered architectures
• Advanced knowledge of data warehousing methodologies and Data Mart design
• Advanced knowledge of SQL Server dialect, relational database theory, ETL toolsets, and OLAP technologies
• Strong object-oriented programming skills
• Strong communication, interpersonal, and documentation skills

Plusses:

• Experience with Business Intelligence tools, including Crystal Reports and Microsoft tools
• Experience using data modeling tools such as Analysis Services
• Advanced knowledge of servers, mainframes, and networks
• Experience as a trainer, facilitator, or course developer
• Experience mentoring or assisting lower-level programmers
• Experience developing and coordinating production processing schedules

A client of Insight Global is seeking a Senior Software Engineer to design, develop, test, implement, and maintain complex software applications, relational databases, and data warehousing systems. This individual will troubleshoot software and client issues, support operating systems and database management systems, contribute to product architecture, and collaborate with departments and clients throughout the full development lifecycle. Responsibilities also include testing programs for accuracy, maintaining technical documentation, keeping systems current with changing technologies, mentoring lower-level programmers, and providing system or programming training to users as needed.

We are looking for an analytical, detail-oriented, and collaborative individual with strong problem-solving, communication, and documentation skills. The ideal candidate can quickly learn new technologies, work effectively within a formal software development lifecycle, maintain confidentiality, and follow established District and department policies and procedures.

This position is direct hire position with a hybrid schedule working 4 days a week on-site in Thornton, Colorado. This position can support a salary range of $99,000-$149,968 based on experience level.