• Data Platform Engineer

    Job Locations US-CT-Farmington
    Job ID
    # of Openings
    Product Development
  • The Position

    The Arch Re Fac Product management team has responsibility over all systems and the EDW consumed by Arch Re Facultative business unit as well as solving human and business problems with new technology. This technical engineer/architect role will have oversight and drive technical solution, design and development across a spectrum of projects within and outside the data warehouse landscape.


    The Data Platform Engineer will work closely with the rest of the Arch Re Fac product management team and business peers to effectively execute project initiatives including but not limited to EDW expansion, vendor products, in-house products, analytic technologies etc. The candidate will be an experienced dynamic, multidimensional professional who is strategic, technology savvy, and skilled in both technical strategy and operational efficiencies. This person should be able to make decisions in a fast-paced, deadline-driven and rapidly changing environment.

    Job Responsibilities


    • Lead strategic technical direction and system architecture for individual initiatives
    • Collaborate with internal and external technology and business partners to implement product changes
    • Produce technical/architectural specification and design/technical documents, as required
    • Critically analyze business requirements and architect and implement design flows and data integration, reduce rework
    • Design and enhance the data warehouse and all related extraction, transformation and load of data function; define, develop and maintain standards and processes to ensure effective SSIS packages
    • Implement stored procedures and effectively query databases
    • Identify and unit test for defects and bottlenecks in the ETL solution; fix issues, ensure performance and quality in the packages
    • Provide feedback and technical guidance to product manager on issues of critical importance to achieving business objectives
    • Work closely with product manager to develop and execute action plans to address gaps
    • Recommend innovations that enhance and/or provide a competitive advantage to the organization
    • Communicate effectively with both the business and technical teams
    • Mentor other developers to accomplish results; provide training 

    Desired Skills/Experience

    • Demonstrated understanding of database administration, design and query planning, execution and optimization
    • Experience monitoring and supporting production database and server environment
    • Experience with the design and development of UI, Web Services, server-side components including database schema design and business logic implementation
    • Strong understanding of technologies utilized in the industry and the ability to see their impact as well as enhancement management and product lifecycle development
    • Knowledge of source code version control systems such as Git, Perforce, TFS, including branching/merging, resolving code conflicts, and 3-way and baseless merges
    • Ability to overcome internal barriers and negotiate resource constraints to produce successful initiatives with the ability to convey technical concepts in a clear, understandable way
    • Relevant experience working with 3rd party vendors to deliver results

    Required Skills/Experience

    • 7-10 years’ experience with data transformation (SSIS), Scripting experience, SSRS and Technologies/(SSIS) ETL development
    • 3 years’ hands-on experience with C#.NET framework, Java, Microsoft SQL Server, Web Services
    • Experience in insurance or reinsurance – desired
    • Experience with product centric IT and agile methodologies


    • Bachelor’s Degree in business, computer science or related field

    The Company

    Arch Re is a well-capitalized, leading diversified insurer that focuses on supplying significant capacity to the global reinsurance marketplace. We have the worldwide reach, agility and resources to support ceding companies capitalizing on changing market conditions and new opportunities in various lines and geographic areas around the globe. Our business strategy keeps operational controls tight and costs low, helping to maximize efficiencies for our broker partners. A subsidiary of Arch Capital Group Ltd., Arch Re has been recognized by clients around the globe for providing expert underwriting, skilled claims management, outstanding service and world-class product offerings.


    Arch Capital Group Ltd. is a Bermuda-based company which provides insurance, reinsurance and mortgage insurance on a worldwide basis through its wholly owned subsidiaries. Arch offers competitive pay and a comprehensive benefits package. Additionally, Arch is committed to helping its associates create what’s next by providing access to a variety of programs supporting your professional development and a culture that encourages innovation, collaboration and professional growth. We seek talent that thinks innovatively, values collaboration and will go the extra mile to serve our customers and develop our company.


    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed