Argo Group
Senior Enterprise Data Warehouse Architect
Argo Group, Chicago, Illinois, United States, 60290
Argo Group is a leader in specialty insurance with a vibrant culture built on respect, equality, wellness and opportunity. We’re an innovative organization that’s small enough to be agile and big enough to make a difference in our industry. Our flexible workplace is continuously evolving to ensure all employees feel:Comfortable bringing their whole selves to work.Confident that they will be treated respectfully.Recognized for their performance and provided with equal opportunities to succeed.At Argo, skill meets opportunity. If you’re wired to raise your hand and ask, “Where can I help?”, you’ll thrive with us.Responsibilities:
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.Qualifications:
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.P&C Insurance Industry is preferred, although other insurance sectors of financial services may be considered.Served as a database manager, data modeler, data architect, enterprise information architecture.Experience in data warehouse, data mart, ETL, analytics.5+ years SQL Server environment.A solid understanding of key BI tools and trends.Experience in and understanding of a wide variety of analytical processes (retention, governance, measurement, information security, etc.).What’s Required For The Position
10+ years professional work experience in delivering data and analytics solutions.At Minimum 3+ year of experience in P&C or other insurance sectors or in financial services.At 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 modelling 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.Working with a variety of colleagues, including Product Owners and the Engineering community, to ensure the best data solutions are delivered.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 modelling 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.Required Competencies:
Problem Solving
Demonstrates strong problem solving capabilities.Takes high level business objectives and creatively comes up with technical solutions to satisfy business intent.Willing and able to overcome challenges and roadblocks to enable the business to meets its goals.Communication
Communicate effectively in both verbal (i.e. day-to-day discussions, team meetings) and written (requirements and design specifications) form, as well as have an overall ability to be clear and concise in all communications.Comfortable communicating with all audiences from highly technical engineers to non-technical executives in both written and verbal channels.Actively listens to customers and teams.Builds good relationships with peers, executives and other departments.Ownership
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.PLEASE NOTE: At this time, Argo Group will not sponsor an applicant for employment authorization for this position.If you have a disability under the Americans with Disabilities Act or a similar law and you wish to discuss potential accommodations related to applying for employment at Argo Group, please contact our Benefits Department.To all recruitment agencies : Unless you have been requested to work on this position, or other positions with Argo Group, please do not forward any resumes to Argo Group employees. Argo Group is not responsible for any fees related to unsolicited resumes.The published salary range applies to applicants that reside in the state of Colorado. The salary range for this role is $113,600 - $135,100.Argo Group International Holdings, Ltd. (NYSE: ARGO) is a global multiline underwriter of specialty insurance and reinsurance products in the property and casualty market. We help power the businesses that drive the world economy, offering a comprehensive line of high-quality products and services designed to meet the unique coverage and claims-handling needs of our clients. We foster an inclusive culture that embraces diversity and design thinking, relies on innovation and agility, promotes collaborative service delivery, offers frequent, integrated communication and values authentic recognition of excellence. We are an Equal Opportunity Employer. We do not discriminate on the basis of age, ancestry, color, gender, gender expression, gender identity, genetic information, marital status, national origin or citizenship (including language use restrictions), denial of family and medical care leave, disability (mental and physical), including HIV and AIDS, medical condition (including cancer and genetic characteristics), race, religious creed (including religious dress and grooming practices), sex (including pregnancy, child birth, breastfeeding, and medical conditions related to pregnancy, child birth or breastfeeding), sexual orientation, military or veteran status, or other status protected by laws or regulations in the locations where we operate. We do not tolerate discrimination or harassment based on any of these characteristics.The collection of your personal information is subject to our HR Privacy Notice. Our Benefits
A culture that recognizes performance and empowers employees to excel, offering competitive compensation and merit driven profit sharing.Flexible workplace policies that support employee well-being include compressed hours, flex-time, job-sharing, remote work, sabbatical leave, holiday and summer hours.Comprehensive health, wellness, and financial planning options that employees can tailor to meet their personal and family needs. In addition to traditional health and wellness plans, benefits include 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 (up to 14 days) leave, employee assistance program (EAP), and an array of voluntary benefits.Argo Academy, a digital and instructor-led platform that offers continuous learning and professional development – Training magazine lists Argo among the Training "Top 125" Companies. Argo encourages career mobility and continuing education to pursue and maintain professional and industry designations, in addition to traditional university and higher education programs.An inclusive culture that develops and sponsors diverse teams, encourages cross-functional engagement and collaboration, builds community through employee resource groups (ERGs), and provides an environment that welcomes ongoing dialogue, creative innovation, professional and personal development.Active community outreach and volunteer programs in addition to matching charitable gifts by 100%.A generous Employee Referral program that results in approximately 25% of all new hires annually.
#J-18808-Ljbffr
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.Qualifications:
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.P&C Insurance Industry is preferred, although other insurance sectors of financial services may be considered.Served as a database manager, data modeler, data architect, enterprise information architecture.Experience in data warehouse, data mart, ETL, analytics.5+ years SQL Server environment.A solid understanding of key BI tools and trends.Experience in and understanding of a wide variety of analytical processes (retention, governance, measurement, information security, etc.).What’s Required For The Position
10+ years professional work experience in delivering data and analytics solutions.At Minimum 3+ year of experience in P&C or other insurance sectors or in financial services.At 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 modelling 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.Working with a variety of colleagues, including Product Owners and the Engineering community, to ensure the best data solutions are delivered.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 modelling 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.Required Competencies:
Problem Solving
Demonstrates strong problem solving capabilities.Takes high level business objectives and creatively comes up with technical solutions to satisfy business intent.Willing and able to overcome challenges and roadblocks to enable the business to meets its goals.Communication
Communicate effectively in both verbal (i.e. day-to-day discussions, team meetings) and written (requirements and design specifications) form, as well as have an overall ability to be clear and concise in all communications.Comfortable communicating with all audiences from highly technical engineers to non-technical executives in both written and verbal channels.Actively listens to customers and teams.Builds good relationships with peers, executives and other departments.Ownership
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.PLEASE NOTE: At this time, Argo Group will not sponsor an applicant for employment authorization for this position.If you have a disability under the Americans with Disabilities Act or a similar law and you wish to discuss potential accommodations related to applying for employment at Argo Group, please contact our Benefits Department.To all recruitment agencies : Unless you have been requested to work on this position, or other positions with Argo Group, please do not forward any resumes to Argo Group employees. Argo Group is not responsible for any fees related to unsolicited resumes.The published salary range applies to applicants that reside in the state of Colorado. The salary range for this role is $113,600 - $135,100.Argo Group International Holdings, Ltd. (NYSE: ARGO) is a global multiline underwriter of specialty insurance and reinsurance products in the property and casualty market. We help power the businesses that drive the world economy, offering a comprehensive line of high-quality products and services designed to meet the unique coverage and claims-handling needs of our clients. We foster an inclusive culture that embraces diversity and design thinking, relies on innovation and agility, promotes collaborative service delivery, offers frequent, integrated communication and values authentic recognition of excellence. We are an Equal Opportunity Employer. We do not discriminate on the basis of age, ancestry, color, gender, gender expression, gender identity, genetic information, marital status, national origin or citizenship (including language use restrictions), denial of family and medical care leave, disability (mental and physical), including HIV and AIDS, medical condition (including cancer and genetic characteristics), race, religious creed (including religious dress and grooming practices), sex (including pregnancy, child birth, breastfeeding, and medical conditions related to pregnancy, child birth or breastfeeding), sexual orientation, military or veteran status, or other status protected by laws or regulations in the locations where we operate. We do not tolerate discrimination or harassment based on any of these characteristics.The collection of your personal information is subject to our HR Privacy Notice. Our Benefits
A culture that recognizes performance and empowers employees to excel, offering competitive compensation and merit driven profit sharing.Flexible workplace policies that support employee well-being include compressed hours, flex-time, job-sharing, remote work, sabbatical leave, holiday and summer hours.Comprehensive health, wellness, and financial planning options that employees can tailor to meet their personal and family needs. In addition to traditional health and wellness plans, benefits include 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 (up to 14 days) leave, employee assistance program (EAP), and an array of voluntary benefits.Argo Academy, a digital and instructor-led platform that offers continuous learning and professional development – Training magazine lists Argo among the Training "Top 125" Companies. Argo encourages career mobility and continuing education to pursue and maintain professional and industry designations, in addition to traditional university and higher education programs.An inclusive culture that develops and sponsors diverse teams, encourages cross-functional engagement and collaboration, builds community through employee resource groups (ERGs), and provides an environment that welcomes ongoing dialogue, creative innovation, professional and personal development.Active community outreach and volunteer programs in addition to matching charitable gifts by 100%.A generous Employee Referral program that results in approximately 25% of all new hires annually.
#J-18808-Ljbffr