Job description

Company Overview

FOCUS provides cloud-based, core administration solutions (FOCUS Tech) and services (FOCUS Insurance Services) for P&C insurance companies and MGAs. Using decades of industry experience, FOCUS is taking the risk out of insurtech for small, mid-size, and growth-focused insurance organizations.

When you join FOCUS, 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:

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

Education/Experience: A bachelor’s degree in computer science or a related discipline, or equivalent work experience.

Technology experience preferred:

AWS
GCP
GIT / Bitbucket
Docker
Python
DB2
Oracle

Additional preferred experience:

Networking
Security / Authentication
Service Provisioning / IaC
Monitoring
Containerization

Education/Experience: A bachelor’s degree in computer science or a related discipline, or equivalent work experience

Travel Required: Minimal. Example (Dept. Offsite)

Why join the FOCUS Team?

The FOCUS 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.

Required profile