A career at Concord Insurance Group is challenging and rewarding. Our group of caring associates create financial security by helping individuals and businesses make a new start when a loss occurs.
Job Description
We are seeking a motivated and talented SQL/Power BI Developer II to join our IT department. In this role, you will collaborate with an experienced team of SQL Developers and contribute to developing and maintaining business intelligence solutions. If you have strong problem-solving abilities, attention to detail, and excellent communication skills, we want to hear from you!
Responsibilities
- Perform analysis, technical design, coding, testing, and implementation of data warehouse, data mart, and reporting applications.
- Develop, optimize, and maintain complex database applications using Microsoft SQL Server 2016 and higher.
- Write and optimize complex T-SQL queries, stored procedures, functions, views, and triggers.
- Design, build, and maintain Power BI reports and dashboards for actionable insights.
- Ensure data integrity and accuracy by performing thorough testing and validation.
- Document processes, data models, and best practices for reporting solutions.
- Perform code reviews and provide feedback to team members.
- Maintain and support production systems as assigned.
Requirements
- Minimum 3+ years of experience in SQL development, including query optimization and database design.
- BA/BS degree in Computer Science, Information Technology, or related field, or equivalent experience.
- Strong knowledge of data warehousing concepts, including dimensional design, star schema models, and time-variant data.
- Experience with SQL partitioning and SQL Server Reporting Services (SSRS).
- Familiarity with Power BI for report and dashboard creation.
- Experience with performance tuning of database applications, including indexing.
- Ability to communicate complex data insights to both technical and non-technical stakeholders.
- Experience with SSIS packages for data export and import and SQL Server Analysis Services (SSAS)
- Exposure to programming with an object-oriented language such as C#.
- Property and Casualty Insurance or Financial Services knowledge preferred.
- Understanding of Agile methodologies.
Benefits
Concord Group employees are eligible for a comprehensive total compensation package including but not limited to medical, vison, dental, life, and disability insurance. We offer a generous Paid Time Off Program that includes vacation, personal, sick time and holiday pay. Invest in your future with our competitive 401(k) plan with company match!
