Enterprise Data Architect

Mutual Benefit International Group, Ltd. - Huntingdon, PA

Full-time - Mid Level

Huntingdon, PA

About the position

The Enterprise Data Architect's role is to strategically design and implement data warehouses, data marts, and data stores while ensuring high levels of data availability for the data analytics team and for other business units. This individual is also responsible for working with the data analytics team and defining data standards and models for warehouse architectures. The Enterprise Data Architect will also assist in evaluating and selecting infrastructure components such as software, hardware, database management systems, and networking capabilities. Specific duties include assessing and cultivating long-term strategic goals for data warehousing in conjunction with the enterprise data analytics team, data users, department managers, clients, and other key stakeholders. The role requires collaboration with other technical staff to develop database architectures, coding standards, and quality assurance policies and procedures. Additionally, the Enterprise Data Architect will work with the enterprise architect and other technical staff to design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective availability, protection, and integrity of data assets. The position involves conducting research and making recommendations on data warehouse products, services, protocols, and standards in support of procurement and development efforts. The Enterprise Data Architect will oversee data collection and master data and database(s), working with end users to identify, create, and deliver reports according to requirements. They will also design and manage data warehouse improvement and growth projects, identify inefficiencies and gaps in current data extraction and reports, and leverage solutions to ensure data standards. Furthermore, the role includes identifying data discrepancies and data quality issues, working to ensure data consistency and integrity, and collaborating with technical staff to monitor system details within the data warehouse, including stored procedures and execution time, while implementing efficiency improvements. The Enterprise Data Architect will develop, implement, and maintain change control and testing processes for modifications on data systems, and perform other duties as assigned or directed.

Responsibilities

• Assess and cultivate long-term strategic goals for data warehousing in conjunction with the enterprise data analytics team, data users, department managers, clients and other key stakeholders.
• Work with other technical staff to develop database architectures, coding standards, and quality assurance policies and procedures.
• Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective availability, protection, and integrity of data assets.
• Conduct research and make recommendations on data warehouse products, services, protocols, and standards in support of procurement and development efforts.
• Oversee data collection and master data and database(s).
• Work with end users to identify, create, and deliver reports according to requirements.
• Design and manage data warehouse improvement and growth projects.
• Identify inefficiencies and gaps in current data extraction and reports and leverage solutions to ensure data standards.
• Identify data discrepancies and data quality issues, and work to ensure data consistency and integrity.
• Monitor system details within the data warehouse, including stored procedures and execution time, and implement efficiency improvements.
• Develop, implement, and maintain change control and testing processes for modifications on data systems.
• Perform other duties as assigned or directed.

Requirements

• Bachelor's degree in computer science, engineering, or comparable course of study.
• Managerial technical experience with designing, building, installing, configuring, and supporting enterprise data warehouses.
• Experience with database platforms.
• Strong knowledge of P&C insurance data, insurance carrier workflows, data analytics fundamentals, and technology.
• Strong knowledge of data governance and compliance.
• Strong understanding of relational database structures, theories, principles, and practices.
• Hands-on experience with data architecting, data mining, large-scale data modeling, and business requirements gathering/analysis.
• In-depth technical knowledge of network, PC, and platform operating systems.
• Proven project management experience.
• Good knowledge of applicable data privacy practices and laws.
• Strong written and oral communications skills.
• Exceptional analytical, conceptual, and problem-solving abilities.
• Ability to present ideas in user-friendly language.

Nice-to-haves

• Certified Data Management Professional (CDMP)
• The Open Group Architecture Framework (TOGAF)
• Microsoft Certified - Azure Data Engineer Associate or Azure Solution Architect Expert

Benefits

• Full benefits package, including health, dental reimbursement, vision, 401(k) and Roth 401(k), and PTO, starts the first of the month following employment.