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 Apply To this Job