Sr. Software Engineer

at  Safety Insurance Company

Safety Insurance has become one of the leading property and casualty insurance providers in Massachusetts mainly because of our unwavering commitment to independent agents and their customers. Our success is built on a philosophy of offering the highest quality insurance products at competitive rates and providing the best service at all costs.
Through our supportive career, educational and family policies, we enable our employees to be their best. We respect the balance of work and leisure by offering flexible, hybrid schedules and a 37.5 hour workweek. Safety employees enjoy a positive environment in our convenient downtown office located in the heart of Boston’s financial district.
Along with our competitive salaries, we offer a comprehensive benefits package including medical and dental insurance, 100% matching 401k retirement plan, 100% tuition reimbursement and much, much more!
The Senior Software Engineer supports strategic projects by providing database knowledge and development both at an architecture level and a database coding / ETL level through the analysisand understanding of business and technical requirements. The Senior Software Engineer will be responsible for technical leadership by sharing best practices and technology trends and acting as a technical mentor related to their area(s) of expertise.

QUALIFICATIONS

• Bachelor’s Degree in Computer Science or related field experience.
• 5+ years of ETL development experience preferred, i.e. Talend.
• Proficient with CI/CD pipelines and workflow management tools (i.e. Jenkins/Nexus, Airflow).
• Ability to collaborate through code version control tools like GitLab(for peer-reviews, feature branches, resolving conflicts and commits)
• Proficient with SQL (writing and optimizing) and stored procedures.
• Proficient with Python, Java and shell scripting.
• Proficient with data warehousing concepts, designs, and data modelling tools.
• Knowledge of Greenplum database and relational databases.
• Experience implementing API Integrations (REST, SOAP, JSON) between multiple products.
• Experience with UNIX/Linux OS.
• Ability to lead a group through an architectural development process and collaborate with application development team and business users.
• Strong written and communication skills required.
• Strong analytic, problem solving and decision-making skills.
• Ability to interact and work with third party vendors.

• Design, develop, and implement ETL processes to extract, transform, and load data from diverse sources into the data warehouse.
• Create and maintain documentation for ETL processes, including source-to-target mappings, transformations, and workflows.
• Perform ETL performance tuning, optimization, and troubleshooting to ensure efficient data processing.
• Work closely with business analysts and stakeholders to understand data requirements and translate them into technical solutions.
• Collaborate with database developers and administrators to ensure proper data governance and quality standards are maintained.
• Support data modeling activities and ensure alignment of ETL processes with the overall data architecture.
• Ability to produce logical data models for relational and dimensional databases.
• Strong analytical skills with the ability to collect, organize, analyze and disseminate significant amounts of information with attention to detail and accuracy.
• Ability to lead a group through an architectural development process and collaborate with application development team and business users.
• On-call/Production Support: Sometimes outside of regular business hours along with interacting with offshore partners.