Senior Enterprise Data Warehouse Architect

The Senior Data Architect at Argo Group is responsible for designing and building advanced data solutions and models within the organization's data architecture. They collaborate with engineering teams to shape and design new products and services, ensuring they align with the overall data architecture. This role requires a strong understanding of the P&C Insurance industry, technical development, design, and multitasking skills. The Senior Data Architect also plays a key role in establishing analytic environments, implementing data warehouse solutions, and ensuring data quality control and optimization.

• Creates and maintains responsibility for the overall design of the enterprise-wide data/information architecture
• Analyzes, designs and implements enterprise-wide data warehouse that is a single, accurate source of truth
• Collaborates with Data Governance to define data/information standards for enterprise warehouse repository
• Collaborates with Data Governance to help define metadata management to manage all enterprise information architecture project artifacts
• Interacts with Data Governance to ensure existing data/information assets are identified, stewarded and leveraged across the enterprise
• Performs a key management and leadership role in the areas of advanced data techniques, including data modeling, data access, data integration, data visualization, data discovery, statistical methods, database design and implementation
• Provides leadership in establishing analytic environments required for structured, semi-structured and unstructured data
• Participates in projects and works with business and IT to ensure quality implementations using an agile methodology
• Draws conclusions and effectively communicates findings with both technical and non-technical team members
• Develops specific metrics and controls for quality and consistency reviews of data
• Produces ETL design guidelines to ensure a manageable ETL infrastructure
• Produces database/architecture documentation and technical specifications for the ETL programs to implement data warehouse and BI platforms
• Facilitates consistent data quality control and optimization in EDW at enterprise level
• Performs other duties as assigned
• Triaging new requirements, providing impact assessments and appropriate estimates for amending data models in line with solution designs and requirements
• Developing and enhancing business physical data models in line with new requirements
• Enhancing data models and being their custodian, driving alignment as appropriate
• Defining and owning modeling within a delivery team from a physical perspective on a day-to-day basis
• Ensuring the data models developed meet the appropriate standards and principles
• Creating solutions that meet business needs and move towards end state architecture
• Ensuring data models are documented, communicated, updated and centrally managed in an appropriate manner
• Collaborates with Data Governance to define data/information standards for enterprise warehouse repository
• Collaborates with Data Governance to help define metadata management to manage all enterprise information architecture project artifacts
• Working with the broader architecture community of practice to support architects and teams in other domains; sharing personal learning and expertise, and sharing plans to promote alignment and innovation
• Demonstrates strong problem-solving capabilities
• Takes high-level business objectives and creatively comes up with technical solutions to satisfy business intent
• Communicate effectively in both verbal and written form
• Actively listens to customers and teams
• Builds good relationships with peers, executives, and other departments
• Cares about the quality of the product systems and the success of the organization
• Expresses opinion on solutions and does not allow bad solutions
• High sense of urgency to meet commitments
• Will go outside of primary role if needed to help drive success

• Bachelor's degree in Computer Science, Information Technology or 7+ yrs. related field experience
• 7+ years of experience with large and complex database management systems in the financial industry
• Experience in data warehouse, data mart, ETL, analytics
• 5+ years SQL Server environment
• 10+ years professional work experience in delivering data and analytics solutions
• Minimum 3+ year of experience in P&C or other insurance sectors or in financial services
• Minimum 3+ year of experience with data Modeling tools like Spark, Erwin Data Modeler
• Experienced in Data Warehousing/Analytic end to end architecture
• Comfortable with different modeling methodologies – 3NF, Dimensional and Data Vault
• Abreast of the latest industry developments across data, including machine learning and modern algorithmic techniques at scale
• Strong communication and influencing skills used to drive the implementation of data design best practice at the Engineering and Product Manager levels within and across teams
• Curiosity and drive to understand business processes and the data they generate in addition to the opportunities to structure and use this data to drive business value
• Triaging new requirements, providing impact assessments and appropriate estimates for amending data models in line with solution designs and requirements
• Developing and enhancing business physical data models in line with new requirements
• Enhancing data models and being their custodian, driving alignment as appropriate
• Draws conclusions and effectively communicates findings with both technical and non-technical team members
• Defining and owning modeling within a delivery team from a physical perspective on a day-to-day basis
• Ensuring the data models developed meet the appropriate standards and principles
• Creating solutions that meet business needs and move towards end state architecture
• Ensuring data models are documented, communicated, updated and centrally managed in an appropriate manner
• Collaborates with Data Governance to define data/information standards for enterprise warehouse repository
• Collaborates with Data Governance to help define metadata management to manage all enterprise information architecture project artifacts
• Working with the broader architecture community of practice to support architects and teams in other domains; sharing personal learning and expertise, and sharing plans to promote alignment and innovation
• Demonstrates strong problem-solving capabilities
• Communicate effectively in both verbal and written form
• Actively listens to customers and teams
• Cares about the quality of the product systems and the success of the organization
• Expresses opinion on solutions and does not allow bad solutions
• High sense of urgency to meet commitments
• Will go outside of primary role if needed to help drive success

• Competitive compensation and merit-driven profit sharing
• Flexible workplace policies (compressed hours, flex-time, job-sharing, remote work, sabbatical leave, holiday and summer hours)
• Comprehensive health, wellness, and financial planning options (including dental, disability, life insurance, medical and vision insurance, matching 401(k) retirement savings)
• Generous paid time off (21 days of PTO, 11 paid company holidays, 3 floating holidays, and a paid voluntary day)
• Paid caregiver and parental leave
• Paid bereavement, jury duty/court appearances, and military leave (up to 14 days)
• Employee assistance program (EAP)
• Array of voluntary benefits
• Argo Academy for continuous learning and professional development
• Career mobility and continuing education opportunities
• Inclusive culture that develops and sponsors diverse teams
• Employee resource groups (ERGs)
• Active community outreach and volunteer programs
• Generous Employee Referral program (approximately 25% of all new hires annually)