Database Developer II

Company Overview

Team Focus Insurance Group provides insurance industry organizations with the policy management solutions they need so they can focus on profitably growing their business. Throughout our more than 25 years, we’ve built a solid reputation of financial stability, growth through innovation, and delivering outstanding service and results to our clients. And while our focus is on our clients, it’s also on our team members. 

When you join Team Focus Insurance Group, you immediately become one of our most valued components – and we’re committed to investing in you. That means you can look beyond the paycheck and excellent benefits to an environment that will help you grow and achieve your professional goals through development and advancement opportunities and the support of our outstanding leaders and teammates.

Summary: The Data Engineering team aligns with the Sales, Marketing, Finance, and Executive Leadership Teams allowing them to make fact-based decisions that direct our organization.  The Database Developer II at InsurTech is an opportunity to leverage your strong data domain knowledge and development skillset in a small organization directly supporting our business leaders and stakeholders.

Essential Duties and Responsibilities:

• Writing database scripts and queries: A database developer is responsible for writing SQL scripts and queries to extract, manipulate, and manage data. They must ensure that the queries are optimized for performance and security.
• Designing, reengineering, and troubleshooting advanced MS SQL SSIS packages.
• Designing, reengineering, and troubleshooting advanced PowerBI dashboards.
• Designing and developing databases: The database developer II is responsible for designing and developing efficient, secure, and scalable databases/marts to meet the organization's needs. This involves creating data models, tables, indexes, and other database objects.
• Creating/updating ETL specifications and supporting documentation
• Perform day-to-day tasks as an individual contributor for our most complex computer applications and/or application initiatives.
• Collaborate on the design & build of a reporting data infrastructure
• Interface with product owners and key stakeholders in Project Management, Business, QA and Technology Operations to ensure high quality delivery of software projects
• Work with business analysts to understand business requirements and use cases

Key Qualifications:

• A bachelor’s degree in computer science or a related discipline, or equivalent work experience
• 2-3 years' experience in database design, development, and management, including knowledge of SQL and one or more database management systems such as Oracle, SQL Server, or MySQL.
• 2-3 years hands-on experience in MS T-SQL and SSIS
• 2-3 years' experience in data warehouse, data modeling, ETL, BI projects
• 2-3 years SQL experience with the ability to develop, tune and debug complex SQL applications is required
• 2-3 year’ hands-on experience in PowerBI
• Knowledge in schema design, developing data models and proven ability to work with complex data is required
• Understanding of best practices for building different data architectures including a Data Mesh, Data Fabric, Data Lake, Data Warehouse and supporting analytical architectures.
• Good interpersonal, analytical, problem-solving and organizational skills
• Excellent written/verbal communication skills

Technology experience preferred:

• AWS
• GCP
• GIT / Bitbucket
• Docker
• Python
• DB2
• Oracle

Additional preferred experience:

• Networking
• Security / Authentication
• Service Provisioning / IaC
• Monitoring
• Containerization

Travel Required: 10 -15 %

Why join the Team Focus Insurance Group Team?  

The Team Focus Insurance Group Difference:

• Medical, Dental, Vision, Life, Pet; Flexible Spending Account

• Competitive Salaries

• 401K Match  

• Work-Life Balance: Personal Days, PTO Days, 12 Paid Holidays, Two Paid Days for Volunteer Service, Paid Parental Leave

• Short and Long-Term Disability

• Employee Support Programs, Including Mental Health

• Tuition Reimbursement  

• Matching Charitable Gift Program

• Lucrative Referral Program

• Commuter Benefits

• Flexibility: Remote and Hybrid Opportunities Available

This position is not able to be performed in California, Colorado, New York or Washington. 

 EEO

Team Focus Insurance Group is an equal opportunity employer that does not discriminate on the basis of race, color, religion, sex (including pregnancy, sexual orientation, and gender identity), national origin, age, disability, veteran status, marital status, or any other protected characteristic. Our hiring practices ensure that all qualified applicants receive fair consideration without regard to these characteristics.

Disability

Team Focus Insurance Group is committed to creating an inclusive and accessible workplace for all candidates, including those with disabilities. We are dedicated to ensuring equal employment opportunities and providing reasonable accommodations to qualified individuals with disabilities. If you require reasonable accommodations to participate in the application or interview process, please contact our HR department at hrinfo@peak6insurtech.com. We will work with you to provide the necessary accommodations to ensure your full participation in our hiring process.

Note to applicant: It is unlawful in Massachusetts and Maryland to require or administer a lie detector test as a condition of employment or continued employment. Please know that our company does not use lie detector tests in our hiring process.