Database Developer

MS SQL Database Developer

This position is a W2 position with Innovative Development/ID Discovery and is onsite in Radnor, PA 5 days/week.

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, PowerBI, 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 PowerBI 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 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.

Our Commitment to You:

At Innovative Development we value our employees and invest in their personal and professional growth. We offer comprehensive Medical, Dental and Vision options along with fully paid Life, Disability and Accident insurance. Our Employer matched 401(k) enables us to invest in your financial future, while our personalized Leadership Development program helps you thrive in your professional environment. In this fast-changing world, we prioritize mental health through our Employee Assistance Programs. We also encourage work/life balance by offering a variety of working arrangements, including remote, in-person, and hybrid. Join Innovative Development, LLC and develop your potential! Benefits Highlights:

• PTO
• Medical, Dental, and Vision. Health Savings accounts for qualified expenses under HSA plans
• Teledoc, Weight Loss and Wellness Plans included with Health Plans
• Employee Assistance Programs including Mental Health
• Employer Paid Life Insurance.
• Employer paid Long and Short Term Disability Coverage
• 401(k)/Roth IRA with Employer Matching
• Volunteer and Community Events
• Opportunity for growth

Innovative Development, LLC is an equal opportunity employer that is committed to diversity and inclusion in the workplace. We prohibit discrimination and harassment of any kind based on race, color, sex, religion, sexual orientation, national origin, disability, genetic information, pregnancy, or any other protected characteristic as outlined by federal, state, or local laws.