System Data Architect

Information Technology Malvern, Pennsylvania

About The Institutes

A not-for-profit organization located in beautiful Malvern, PA, The Institutes have been the leading provider of risk management and property-casualty insurance education for more than 100 years. By living our values—Put the Customer First, Do What You Say, Work Together, Be Innovative and Do the Right Thing— our talented team delivers innovative solutions that best empower risk and insurance professionals to help those in need. In 2022, The Institutes were named a Top Workplace by for the seventh time. We understand the importance of work-life balance and provide excellent benefits and a friendly and team-focused work environment to drive employee engagement.

System Data Architect

As part of our Architecture and Solutions team, the System Data Architect will develop a high-level understanding of the complex systems governing and facilitating our business applications, making recommendations, and implementing changes to increase efficiency, architectural fit, and to further business and technical future state objectives. The System Data Architect will design and implement DevOps capabilities supporting our database architecture, contribute to the overall data architecture specification, and perform database implementation and tuning enhancements. In addition, the System Data Architect will assist Service Desk technicians in resolving system issues, and support and mentor Institutes’ agile software teams in the design and planning of new software development.

What You’ll Be Doing:

  • Provide leadership and coordination, for system and database architecture design, documentation, and implementation requests, working with and across teams to ensure that architecture deliverables are correct and aligned with best practices
  • Periodically audit existing systems and data architecture to ensure an accurate, high-level understanding of present capabilities, and compliance with data management and data governance best practices
  • Ensure enterprise critical databases are optimized for security, performance, and reliability
  • Oversee and mentor development teams to ensure seamless integration of new technologies and adherence to SDLC best practices and principles
  • Interact with business stakeholders to understand requirements for system enhancements. Perform analysis to understand the impact on our systems and determine feasibility and level of effort of proposed solutions. Consider Institutes strategic goals and make recommendations to support long-term goals and improvements.
  • Act as technical lead on projects as required to support planning and estimating related to scope and level of effort, and to provide technical input on requirements and feature design. Work with Business Analysts, Project Managers and Product Owners on story breakdown, timeline, and roadmap development.
  • Ensure that systems are accurately documented when created or changed, in our standard Confluence environment.
  • Create proof-of-concept and foundational software components that teams can build upon when developing application features.
  • Perform data analysis as needed and make business recommendations on improvising existing processes, troubleshooting issues, and ironing out technicalities on new business requirements.
  • Advise and offer direction to the development teams daily by communicating and clarifying technical requirements. Ensure delivery of the requested features and enforce architecture guidelines by participating in code reviews and assisting with testing.
  • Research and recommend software products and services and ensure their successful integration into The Institutes architecture.
  • Act as a Subject Matter Expert, leveraging in-depth understanding of Institutes systems to assist system users, mentor, and train junior staff, and inform troubleshooting, impact analysis and strategic recommendations.
  • Work with IT Leadership to define and enforce department standards.
  • Assist Service Desk with in-depth troubleshooting and root cause analysis.
  • Identify areas where technology or process revision could improve or enhance existing functionality and create project plans to implement approved recommendations.
  • Perform other duties as assigned


Education and Experience

  • Five years of computer programming and/or system analyst experience.
  • Knowledge of full SDLC and five plus years leading software implementations.
  • Bachelor’s degree in Computer Science or related field, or equivalent experience.
  • Management experience or experience managing technical project resources.
  • Agile/Scrum experience required, including experience writing user stories.
  • Preferred programming skills including but not limited to a working knowledge of: Relational databases (Oracle, MySQL, MSSQL), NoSQL and Data Lake environments like Snowflake, RedShift, or Dynamo DB, JSON, XML, HTML, NodeJS, JavaScript, Drupal, PHP, Web Services, REST.
  • Knowledge of release management/continuous integration techniques, as well as tools and technologies such as Git, GitHub, Bitbucket, and Python a plus.

The Best Part? The Benefits!

To enforce the importance of work-life balance, employees enjoy excellent benefits, including:

  • 401(k) plan with company contribution up to 16%
  • Generous time off package that includes paid vacation, personal, sick and holidays
  • Paid maternity and parental leave
  • Tuition reimbursement
  • Medical, dental, vision and prescription coverage