Database Developer

Location: Radnor, PA (onsite, 5 days/week). W‑2 position with Innovative Development/ID Discovery.

Position Summary

We are seeking an experienced MS SQL Database Developer to design, develop, optimize, and support enterprise database solutions across Microsoft SQL Server environments. This role requires deep expertise in SQL development, stored procedures, query optimization, ETL processing, enterprise reporting, and database performance tuning. The ideal candidate will have strong hands‑on experience with SSIS, SSRS, data warehousing, Power BI, dimensional modeling, SQL Server migrations, and modern cloud‑based data pipeline technologies such as Azure Data Factory.

Required Qualifications

• Strong hands‑on experience as an MS SQL Database Developer or SQL Server Developer in an enterprise environment.
• Expert‑level proficiency in T‑SQL, stored procedures, functions, views, triggers, indexing strategies, and complex query development.
• Demonstrated experience with query optimization, execution plan analysis, database performance tuning, and troubleshooting SQL Server performance issues.
• Extensive ETL development experience using SSIS, including design, development, deployment, monitoring, and support of large‑scale SSIS environments.
• Strong SSRS reporting experience, including report design, parameterized reports, subscriptions, data‑driven reporting, and production support.
• Strong Power BI reporting experience, including report design, parameterized reports, subscriptions, data‑driven reporting, and production support.
• Solid understanding of data warehousing concepts, dimensional modeling, data marts, fact and dimension tables, and reporting data structures.
• Experience with SQL Server migrations, data integration, data validation, and enterprise reporting solution delivery.
• Familiarity with Azure Data Factory and modern cloud‑based data pipeline design, orchestration, and monitoring.
• Strong analytical, problem‑solving, communication, and documentation skills.
• Knowledge of CI/CD practices for database deployments and automated release management.
• Experience with source control tools, deployment pipelines, and database change management processes.
• Understanding of database security, role‑based access, data privacy, auditing, and compliance considerations.
• Experience working in regulated, financial services, insurance, mortgage, or other data‑intensive enterprise environments.
• Ability to mentor junior developers and promote database development best practices across teams.
• Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or a related field, or equivalent professional experience.

Benefits

• PTO
• Medical, Dental, and Vision coverage
• Health Savings Accounts (HSA) for qualified expenses
• Teledoc, Weight Loss, and Wellness Plans included with health plans
• Employee Assistance Programs, including mental health support
• Employer‑paid Life Insurance
• Employer‑paid Long and Short Term Disability coverage
• 401(k)/Roth IRA with employer matching
• Volunteer and community events
• Opportunities for growth and leadership development
• Flexible working arrangements (remote, in‑person, hybrid) to support work/life balance

Innovative Development values its employees and invests in personal and professional growth, offering comprehensive benefits, a leadership development program, and a commitment to diversity, inclusion, and mental‑health support.