SQL Developer, Mid Level (Remote)
Jobright is an AI-powered career platform that helps job seekers discover the top opportunities in the US. We are NOT a staffing agency. Jobright does not hire directly for these positions. We connect you with verified openings from employers you can trust.
Job Summary:
Marsh McLennan Agency (MMA) is a provider of business insurance, employee health & benefits, retirement, and private client insurance solutions. They are seeking a SQL Developer to design, develop, and maintain SQL scripts and data integration solutions that support custom applications, ensuring efficient data flow and application performance.
Responsibilities:
• Actively contribute as a key member of a development team focused on building and maintaining data solutions for custom applications.
• Design, develop, test, and debug SQL scripts, stored procedures, and SSIS packages following current coding standards and best practices.
• Assist with development initiatives that involve creating complex data integration projects to support application functionality and ensure high-quality deliverables.
• Collaborate with lead developers and team members to develop project user stories, manage backlogs, and plan sprints.
• Be an integral part of an innovative and passionate team working on user stories, backlog items, and sprint goals, ensuring timely completion of deliverables.
• Escalate technical issues and challenges as appropriate to ensure smooth project progress.
• Provide Level 2 and Level 3 support for data-related application issues, ensuring quick resolution and minimal downtime.
• Develop reusable SQL code and data solutions to reduce time to market, promote code consistency, increase scalability, and support agile application development.
• Build high-performance data solutions, such as optimized stored procedures and queries, to ensure efficient data processing and application responsiveness.
• Create and maintain data solutions with a security-first mindset, ensuring data integrity and compliance.
• Collaborate with team members on integrating data solutions with other technologies and platforms, including REST API design and implementation when applicable.
• Leverage continuous integration and automated build/test processes (e.g., Azure DevOps, GitHub Actions) to streamline development workflows.
• Utilize Entity Framework to develop data access layers, enabling efficient and maintainable interaction with databases within application development.
Qualifications:
Required:
• Actively contribute as a key member of a development team focused on building and maintaining data solutions for custom applications.
• Design, develop, test, and debug SQL scripts, stored procedures, and SSIS packages following current coding standards and best practices.
• Assist with development initiatives that involve creating complex data integration projects to support application functionality and ensure high-quality deliverables.
• Collaborate with lead developers and team members to develop project user stories, manage backlogs, and plan sprints.
• Be an integral part of an innovative and passionate team working on user stories, backlog items, and sprint goals, ensuring timely completion of deliverables.
• Escalate technical issues and challenges as appropriate to ensure smooth project progress.
• Provide Level 2 and Level 3 support for data-related application issues, ensuring quick resolution and minimal downtime.
• Develop reusable SQL code and data solutions to reduce time to market, promote code consistency, increase scalability, and support agile application development.
• Build high-performance data solutions, such as optimized stored procedures and queries, to ensure efficient data processing and application responsiveness.
• Create and maintain data solutions with a security-first mindset, ensuring data integrity and compliance.
• Collaborate with team members on integrating data solutions with other technologies and platforms, including REST API design and implementation when applicable.
• Leverage continuous integration and automated build/test processes (e.g., Azure DevOps, GitHub Actions) to streamline development workflows.
• Utilize Entity Framework to develop data access layers, enabling efficient and maintainable interaction with databases within application development.
Preferred:
• Bachelor's degree in computer science, information technology, or a related field, or equivalent relevant experience (preferred).
• 5+ years of hands-on SQL development experience, including designing, optimizing, and troubleshooting complex queries and stored procedures.
• Practical experience working with Azure Data services such as Azure SQL Database and Azure Data Factory, along with other cloud-based data solutions.
• Proficiency with continuous integration and automated testing tools like Azure DevOps or GitHub Actions to enhance development efficiency.
• Extensive experience using SQL Server Management Studio (SSMS) and other industry-standard tools for database management, performance tuning, and troubleshooting.
• Familiarity with data visualization platforms such as Power BI for creating interactive dashboards and reports.
• Knowledge of scripting languages like Python or R for data analysis, automation, and process scripting.
• Exposure to NoSQL databases such as MongoDB or Cassandra for managing unstructured or semi-structured data.
• Experience automating tasks and workflows using PowerShell scripting.
• Understanding of DevOps practices related to database deployment, version control, and automation pipelines.
• Awareness of security best practices, including data encryption, access controls, and auditing to ensure data integrity and compliance.
• Experience working within Agile or Scrum environments, adapting to fast-paced development cycles.
Company:
Marsh McLennan is an insurance company that provides business insurance, employee benefits, and private client insurance solutions. It is a sub-organization of Marsh & McLennan. Founded in 2003, headquartered in White Plains, New York, USA, team size 10001+ employees, currently Late Stage. Marsh McLennan Agency has a track record of offering H1B sponsorships.
Apply tot his job