Senior Data Engineer - Financial Systems

Crum & Forster Company Overview

Crum & Forster (C&F) provides market leading property & casualty, accident & health, specialty and standard commercial lines insurance solutions. A true underwriting company, we have a 200-year history of helping our customers manage risk with laser-focused expertise, integrity and discipline. Our people are empowered to make decisions and problem-solve with you smartly and swiftly. Our annual gross written premium is 6.2 billion. C&F enjoys a financial strength rating of "A+" (Superior) by AM Best.

Our most valuable asset is our people. We have 3000 employees, and locations throughout the United States and India. With our employee-first focus, the Company is consistently recognized as a great place to work, earning multiple workplace and wellness awards, including the Great Place to Work® Award, Fortune 100 Best Companies to Work For, Fortune Best Workplaces for Parents, Fortune Best Workplaces for Millennials, and many others.

C&F is part of Fairfax Financial Holdings. For more information about C&F, please visit our website: www.cfins.com

Job Description

Overview:

ITFS requires a senior-level Application Developer to assist on a variety of efforts related to those applications supported by ITFS as well as the interfaces into and out of them. The workload for this position will likely be coordinated by a team lead, though the individual will be administratively reporting to management at some level.

What you will do:

• Learn our applications to the level required for providing proper support and maintenance
• Receive business requirements and ensure proper understanding for appropriate coding
• Actively participate in appropriate Scrum, Kanban, or stand-up meetings
• Understand development standards and utilize them when planning/executing the coding tasks
• Provide appropriate input for solid project planning and the setting of target dates
• Manage time and workload properly to ensure meeting of deadlines
• Ensure review of design and code with team members prior to code promotion
• Work with technical architect to ensure documentation is created/updated as appropriate for assigned task(s)
• Ensure high levels of communication and transparency, demonstrating traceability and best practice
• Ensure close collaboration with the lead and Assistance Vice President of IT Financial Systems knowing what to communicate and when to escalate
• Work with experts to monitor performance of our production environment, and implement any necessary changes to improve it, including small fixes, and large architectural changes
• Assist in effectively managing all non-production environments
• Assist in ensuring our controls are adhered to (e.g. change controls)
• Continue to expand technical skill set, both in terms of ITFS needs and new technologies, utilizing both internal and external training tools.
• There may be a small amount of travel, on an as needed basis, to NJ

What you will bring to C&F

• Bachelor’s degree in Computer Science, Engineering. or related field and 2-6+ years of experience working as a Data Developer or Engineer
• Experience with SQL Server and related tools (SQL queries, SSIS, SSRS)
• Experience with source version control and related tools (Stash, GIT, Bitbucket, etc.)
• A basic foundation in data (e.g. integrity, governance, architecture, extraction, manipulation, storage, mining)
• Experience with job schedulers (SQL Server agent, Autosys, etc.)
• Familiarity with DevOps concepts, CI/CD, and related tools
• Ability to convert business requirements into technical specifications
• Understanding of financial concepts (accounts payable, general ledger, etc.)
• An understanding of basic SDLC and project management principles
• Familiarity with in Microsoft Office tools
• Experience with additional coding languages and tools (C#, VB, .NET, UIPath, Python, XML, JSON, Azure Technologies), is perferred but not required
• Strong analytical skills
• Ability to build and maintain solid working relationships
• Ability to be pro-active and self-directed with solid time management
• Excellent communication and collaboration skills – MUST be a team player
• Ability to collaborate with team members to ensure solutions are appropriate and fit for purpose
• Ability to work across teams (internal to ITFS, external IT teams, business units within Finance, cyber, audit, etc.)
• Ability to analyze system functionality and data flow to troubleshoot production issues
• Ability to research and analyze business/system/process issues for improvement potential
• Ability to handle constantly changing priorities
• Excited by new technologies, and a love of learning. Evidence of being self-motivated and driven
• An enthusiastic/positive/collaborative/helping/sharing/team focused attitude
• Desire to work on challenging problems with smart and collaborative people
• An understanding of working with vendor-based applications and APIs
• Be an advocate for best practice, success, and excellence
• Believe and adhere to the principles of traceability and best practice in an agile manner
• Ensure internal controls are adhered to and that evidence of adherence is available
• Understand concepts of performance monitoring, tuning, and improvement
• Ability to assess and prioritize feature requests based on both effort and value
• Ability to develop and execute unit testing based on tickets and acceptance criteria

Desired, but not required skills:

• Knowledge of the insurance industry
• Experience with data warehouses and/or data marts
• Experience in additional DBMSs (Oracle, Snowflake, SYBASE, MongoDB, NOSQL, etc.)
• Experience in, or understanding of, additional BI tools (SSAS, Tableau, PowerBI, OneStream, Crystal Reports, Business Objects)
• Experience in, or understanding of, additional ETL tools (Informatica)
• Knowledge of Agile principles and Scrum and/or Kanban
• Familiarity with Jira and Confluence
• Experience working across multiple time zones
• Experience working with employees and contractors

#LI-MS

#LI-REMOTE

What C&F will bring to you

• Competitive compensation package
• Generous 401K employer match
• Employee Stock Purchase plan with employer matching
• Generous Paid Time Off
• Excellent benefits that go beyond health, dental & vision. Our programs are focused on your whole family’s wellness, including your physical, mental and financial wellbeing
• A core C&F tenet is supporting your career development, so we provide a wealth of ways for you to keep learning, which may include tuition reimbursement, industry-related certifications and professional training to keep you progressing on your chosen path
• A dynamic, ambitious, fun and exciting work environment
• We believe you do well by doing good and want to encourage a spirit of social and community responsibility, matching donation program, volunteer opportunities, and an employee-driven corporate giving program that lets you participate and support your community

At C&F you will BELONG

If you require special accommodations, please let us know. We value inclusivity and diversity. We are committed to equal employment opportunity and welcome everyone regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity, or Veteran status. If you require special accommodations, please let us know. Belonging at C&F, is a mindset. It’s about fostering a culture of inclusion and connection, where everyone feels valued, heard, and empowered to thrive and where our social impact efforts help strengthen the communities where we live and work.

For California Residents Only:  Information collected and processed as part of your career profile and any job applications you choose to submit are subject to our privacy notices and policies, visit https://www.cfins.com/onlineprivacypolicy/ca/noticeatcollection/  for more information.

Crum & Forster is committed to ensuring a workplace free from discriminatory pay disparities and complying with applicable pay equity laws.  Salary ranges are available for all positions at this location, taking into account roles with a comparable level of responsibility and impact in the relevant labor market and these salary ranges are regularly reviewed and adjusted in accordance with prevailing market conditions. The annualized base pay for the advertised position, located in the specified area, ranges from a minimum of $85,000 to a maximum of $120,000. The actual compensation is determined by various factors, including but not limited to the market pay for the jobs at each level, the responsibilities and skills required for each job, and the employee’s contribution (performance) in that role. To be considered within market range, a salary is at or above the minimum of the range. You may also have the opportunity to participate in discretionary equity (stock) based compensation and/or performance-based variable pay programs.