Senior SQL & BI Architect - ETL, DW, SSIS/SSRS

TechDigital Group; New Jersey; Hybrid; USD 120,000 - 160,000; Full time

Job summary

TechDigital Group is seeking a Senior SQL Server/BI specialist to own enterprise database architecture, ETL, and reporting solutions. You will optimize T-SQL, build SSIS/SSRS pipelines, and design scalable OLTP and data warehousing structures.

Candidates should have 14–18 years of SQL Server experience, proven production support, and expertise in Power BI and governance.

Qualifications

• 14–18 years of SQL Server experience.
• Enterprise ETL development using SSIS.
• Enterprise reporting using SSRS/Power BI.
• Database architecture and design experience.

Responsibilities

• Develop and optimize: Stored Procedures, Functions, Views, Triggers, T-SQL Queries.
• Analyze execution plans and improve query performance.
• Troubleshoot blocking, deadlocks, and long-running queries.
• Design efficient indexing strategies.
• Implement database performance tuning.
• Design enterprise database architecture and data models.
• Build ETL processes and data warehouse loading with SSIS.
• Create dashboards and BI reports with SSRS/Power BI.

Skills

SQL Server

T-SQL

Query Optimization

Performance Tuning

Indexing

Partitioning

Always On

ETL Development

SSIS

SSRS

Power BI

Data Modeling

OLTP Architecture

Data Warehousing

BI Solutions

Data Governance

Security & Auditing

Backup & DR

Production Support

Tools

SQL Server Management Studio

SSIS

SSRS

Power BI

Job description

Primary Responsibilities
SQL Development

• Develop and optimize: Stored Procedures, Functions, Views, Triggers, T-SQL Queries
• Analyze execution plans and improve query performance.
• Troubleshoot blocking, deadlocks, and long-running queries.
• Design efficient indexing strategies.
• Implement database performance tuning.

SSIS Development

• Design and develop SSIS packages.
• Build ETL processes for: Data integration, Data migration, Data warehouse loading
• Handle data transformation and cleansing.
• Automate file imports and exports.
• Monitor SSIS package execution and troubleshoot failures.

SSRS Development

• Design and develop operational and executive reports.
• Create dashboards and analytical reports.
• Implement report subscriptions and automated delivery.
• Optimize report performance.

Database Architecture & Design

• Design enterprise database architecture.
• Create logical and physical data models.
• Perform normalization and denormalization.
• Establish database standards and best practices.
• Design highly scalable OLTP and reporting solutions.
• Design multi-tenant and enterprise application databases.

Performance & Troubleshooting

• Conduct root cause analysis.
• Resolve production incidents.
• Monitor wait statistics.
• Analyze memory, CPU, and I/O bottlenecks.
• Tune indexes and statistics.
• Improve SQL workload efficiency.

Data Warehouse & Business Intelligence

• Design dimensional models.
• Implement data marts and enterprise data warehouses.
• Build reporting and analytics platforms.
• Support Power BI, SSRS, and BI solutions.

Required Technical Skills
SQL Server

• SQL Server 2016/2019/2022, T-SQL, Query Optimization, Performance Tuning, Indexing, Partitioning, Replication, Always On Availability Groups

Integration & Reporting

• SSIS, SSRS

Database Design

• Data Modeling, OLTP Architecture, Data Warehousing, Star Schema, Database Security, Data Governance

Good to have Knowledge
SQL Server Administration

• Install, configure, and maintain SQL Server environments.
• Manage SQL Server upgrades, patching, and migrations.
• Configure security, roles, permissions, and auditing.
• Perform backup, recovery, and disaster recovery planning.
• Manage Always On Availability Groups, Failover Clustering, and replication.
• Monitor database health and capacity planning.

Experience

• 14– 18 years of SQL Server experience.
• Enterprise ETL development using SSIS.
• Enterprise reporting using SSRS/Power BI.
• Database architecture and design experience.
• Production support and performance tuning expertise.
• Healthcare, insurance, finance, or large enterprise application experience preferred.