Senior SQL Database Developer - ETL, SSIS & BI

Insight Global; Richmond (VA); On-site; USD 125,000 - 135,000; Full time

Job summary

Insight Global is seeking a Senior SQL Database Developer to support a large-scale enterprise database environment at a Virginia State Agency. This role focuses on designing, developing, and optimizing SQL Server databases, stored procedures, ETL processes, and reporting models to support complex business needs.

You will collaborate with application developers, implement indexing strategies, and drive performance improvements across hundreds of databases.

Qualifications

• 6+ years of SQL Server database development experience.
• 6+ years developing and maintaining complex stored procedures, functions, triggers, tables, and views.
• 6+ years working with SSIS, including advanced ETL development and custom scripting.
• 6+ years creating complex SQL queries and performance optimization solutions.
• 6+ years building and maintaining SSRS reports and reporting models.
• 6+ years working with SSAS or Azure Analysis Services.
• 5+ years supporting large data warehouse environments and enterprise database architectures.
• Strong understanding of indexing, query tuning, execution plans, and database performance analysis.
• Experience with data warehouse concepts including star schema, snowflake schema, data marts, and data lakes. Exposure to Azure Data Factory, Data Lake, or Databricks.

Responsibilities

• Design, develop, and maintain SQL Server databases, stored procedures, functions, triggers, tables, and views.
• Create and enhance SSIS packages, ETL processes, and data integration solutions.
• Develop and maintain SSRS reports and reporting models with dynamic user-driven filtering and parameters.
• Support SSAS/Azure Analysis Services cubes, dimensions, and data models.
• Analyze database structures and query performance to identify optimization opportunities.
• Design and implement indexing strategies and performance tuning solutions.
• Partner with development teams to support application and reporting requirements.
• Work within a large enterprise-scale database environment containing hundreds of databases and thousands of tables.

Skills

SQL Server

T-SQL / Stored procedures

SSIS

SSRS

SSAS / Azure Analysis Services

ETL development

Query tuning / performance analysis

Data warehousing concepts

Azure Data Factory / Data Lake / Datab

Enterprise database environments

Tools

SSIS

SSRS

SSAS

Azure Data Factory

Azure Data Lake

Databricks

Job description

Insight Global is seeking a Senior SQL Database Developer to support a large-scale enterprise database environment at a Virginia State Agency. This role focuses on designing, developing, and optimizing SQL Server databases, stored procedures, ETL processes, and reporting models to support complex business needs.

You will collaborate with application developers, implement indexing strategies, and drive performance improvements across hundreds of databases.