Senior SQL Database Developer — SSIS/PowerBI & DW

Innovative Development, LLC; Radnor (Delaware County); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

PTO

Medical, Dental, and Vision

Health Savings accounts

Teledoc, Wellness Plans

Employee Assistance Programs

Employer Paid Life Insurance

Long and Short Term Disability

401(k)/Roth IRA with Employer Matching

Volunteer and Community Events

Opportunity for growth

Job summary

Innovative Development, LLC in Radnor, PA is seeking an experienced MS SQL Database Developer to design, develop, optimize, and support enterprise SQL Server environments.

The role requires deep expertise in SSIS, SSRS, PowerBI, data warehousing, and modern cloud data pipelines such as Azure Data Factory, with a focus on performance and reliability. Onsite, 5 days a week; strong benefits and growth opportunities are offered.

Qualifications

• 5+ years as MS SQL Database Developer in an enterprise environment.
• Expert in T-SQL, stored procedures, functions, views, and indexing strategies.
• Experience with query optimization, execution plans, and SQL Server performance tuning.
• Extensive SSIS development, deployment, monitoring for large-scale environments.
• Strong SSRS reporting, including subscriptions and data-driven reports.
• PowerBI reporting experience with production support.
• Knowledge of data warehousing, dimensional modeling, and data marts.
• Experience with SQL Server migrations and cloud-based data pipelines (Azure Data Factory).
• Familiarity with CI/CD for database deployments and version control.
• Understanding security, access control, data privacy, auditing and compliance.

Responsibilities

• Design, develop, and optimize enterprise SQL Server databases.
• Develop and maintain SSIS ETL pipelines at scale.
• Create and maintain SSRS and PowerBI reports for stakeholders.
• Collaborate with teams on data warehousing and migration projects.
• Implement CI/CD and source control for database deployments.

Skills

MS SQL Server

T-SQL

Query optimization

ETL development (SSIS)

SSRS reporting

PowerBI reporting

Data warehousing concepts

Azure Data Factory

CI/CD and source control

Database security and compliance

Education

Bachelor's degree in Computer Science or related field

Tools

SSIS

SSRS

PowerBI

Azure Data Factory

Job description

Innovative Development, LLC in Radnor, PA is seeking an experienced MS SQL Database Developer to design, develop, optimize, and support enterprise SQL Server environments.

The role requires deep expertise in SSIS, SSRS, PowerBI, data warehousing, and modern cloud data pipelines such as Azure Data Factory, with a focus on performance and reliability. Onsite, 5 days a week; strong benefits and growth opportunities are offered.