Database Developer
This position•Radnor, PA
•Onsite
About The Position
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.
Requirements
- 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.
- Bachelor's degree in computer science, Information Systems, Data Engineering, or a related field, or equivalent professional experience.
Nice To Haves
- Experience with modern cloud-based data pipeline technologies such as Azure Data Factory.
Responsibilities
- Design, develop, optimize, and support enterprise database solutions across Microsoft SQL Server environments.
- Develop and optimize SQL development, stored procedures, query optimization, ETL processing, enterprise reporting, and database performance tuning.
- Utilize SSIS, SSRS, data warehousing, PowerBI, dimensional modeling, SQL Server migrations, and modern cloud-based data pipeline technologies such as Azure Data Factory.
- Mentor junior developers and promote database development best practices across teams.
Benefits
- Comprehensive Medical, Dental and Vision options
- Fully paid Life, Disability and Accident insurance
- Employer matched 401(k)
- Personalized Leadership Development program
- Employee Assistance Programs including Mental Health
- PTO
- Health Savings accounts for qualified expenses under HSA plans
- Teledoc, Weight Loss and Wellness Plans included with Health Plans
- 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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Senior
