AEGIS Insurance Services, Inc. (“AEGIS”) has an immediate opening for a Manager, Enterprise Data responsible for the design, development, and maintenance of our Enterprise Data Warehouse. The Enterprise Data Manager may also participate in the business analysis process, conduct data quality investigations, and assist in the development of test plans and test data. He or she will work closely with ETL developers and may assist in the development of ETL solutions with Microsoft SQL server and associated tools. The individual should possess excellent technical/business communication skills to interact with both IT & business teams for understanding requirements to develop and deploy appropriate data solutions. This includes understanding and experience in applying SDLC processes.
Job Requirements:
- Minimum 10 years of direct hands-on experience in Data Warehouse design and implementation for P&C Insurance
- Minimum 3 years of experience designing and implementing data warehouse designs and techniques
- Minimum 2 years of experience in designing, building and optimizing data marts
- Experience with SSIS, SSAS, SQL Server and other Data warehouse tools
- Bachelor’s degree in Computer or Data Science, Engineering or related discipline
- In depth knowledge of Data Warehouse Architecture, design extract, and load processes
- In depth knowledge of Relational Database Design, ETL and Data Warehouse Concepts
- Significant SQL skills which include the ability to analyze, design, develop, and evaluate complex SQL queries and stored procedures
- Ability to facilitate meeting of peers and team, clearly articulate issues and enable discussion that leads toward resolution
- Ability to mentor technical teams (developers, QA, infrastructure) and business analysts to implement data warehouse solutions, including ETL implementation
- Ability to liaise with source system teams to understand data lineage, resolve data origination issues, weed out and correct process and/or operational issues as well as partner on data initiatives for new source system enhancements
- Ability to present the results of analysis of highly complex and broad business and technical requirements to senior business users and IT
- Demonstrated ability to express and organize thoughts, ideas and information in a logical and concise manner both in writing and verbally
- Demonstrated success in time management, handling multiple priorities, as well as analytical and problem solving skills
Candidate Attributes:
- Excellent interpersonal and communication skills, including strong listening skills
- Work cross-functionally and think creatively, critically and strategically
- Comfortable with ambiguity and willing to take principled bets on new technology
- Strong leadership and negotiation skills with business and technical groups with demonstrated ability to build consensus among many stakeholders
- Excellent organizational, initiative and follow-through skills with a positive attitude, and leadership by example
- Achievement-Oriented: Demonstrates persistence and perseverance in achieving concrete and tangible outcomes by taking action to get optimum results when encountering obstacles or resistance
- Collaborative: Develops and maintains effective working relationships across functional and divisional lines by readily sharing information, knowledge, and resources
- Detail-Oriented: Displays thoroughness and accuracy in quality communications and deliverables through the application of technical skills and industry/product knowledge
- Service-Oriented: Conveys a genuine desire and ability to anticipate and meet customer needs and creates and nurtures mutually beneficial relationships within AEGIS and with AEGIS Members and brokers
- Work Ethic: Takes ownership for one’s responsibilities by acting with integrity and holding oneself accountable to continuous improvement
- Leadership: Motivates employees to exercise their talents to the fullest and holds them accountable for their best efforts; provides support to develop potential skills for improved individual growth and trains and empowers subordinates effectively
Essential Job Functions:
- Provide guidance regarding the use of data warehouse systems, capability of systems to deliver information, and subject matter expertise regarding current systems and emerging technology
- Responsible for managing the specialized IT professionals, who design, develop, maintain, and support data warehousing and data mart technologies and systems
- Leads the activities of data warehouse project teams in the design, development and implementation of data warehouses; and the configuration and auditing of data warehouses to ensure quality control of data
- Coach the team on techniques to validate data quality, and identify and address data biases and discrimination
- Responsible for overseeing the development, operations and maintenance of data warehouse environment, including organizational balance and system coherency between front-end desktop/client environment and data warehouse back-end processing functions
- Establish and implement data warehouse policies, strategies, and procedures
- Ensure data quality and accuracy through quality assurance processes. Liaise with Business to determine and document candidate data source systems, databases, entities and attributes that could add and enhance the data in the warehouse.
- Communicate with business and stakeholders regarding data warehouse capabilities and delivering data and information
- Provides guidance regarding the use of data warehouse systems, capability of systems to deliver information
- Stay current with industry trends and recommend and implement new technologies to enhance current processes
www.aegislink.com
EOE
AEGIS Insurance Services, Inc. participates in E-Verify
We expect to pay a starting salary between $145,000 and $247,000. An applicant’s placement within this range is based on their individual qualifications and professional experience. In addition to base salary, AEGIS employees are eligible to participate in the Company’s annual incentive program, with competitive awards based on corporate and individual performance.
In addition, we offer a comprehensive and competitive suite of options for health, retirement, income protection, wellness, and additional benefits:
- Health: medical and prescription coverage, behavioral health, dental, vision, health savings account (includes a Company contribution), and flexible spending accounts
- Retirement: 401(k) plan that includes matching contributions and an additional Company contribution of 4% (subject to IRS limitations)
- Income Protection: basic and supplemental life insurance, short-term and long-term disability coverages, accident and critical illness insurance
- Wellness: on-site health and fitness center, on-demand fitness and well-being app, and employee assistance program with support on mental health, financial, and legal services
- Additional benefits: commuter benefits that include a transit subsidy from the Company, pet insurance, paid time off (vacation, floating holidays, sick, and Company paid holidays), and a variety of leaves of absence (health, family, and military)
- Educational assistance and professional development opportunities
- Hybrid work schedule
