Business Data Analyst

AEGIS Insurance Services, Inc. (“AEGIS”) has an immediate opening for a Business Data Analyst to work closely with the analytics team and business users to understand system requirements and assist in developing data solutions with our current data and analytics tools. The Data Analyst will monitor new requests and assist in the triage and oversight of the data lifecycle. The Data Analyst will work on designing and developing enterprise-wide data analysis and reporting solutions and work to test these solutions.

Job Requirements:

• Minimum 3 years of experience as a Business Data Analyst
• Experience in property and casualty experience desired
• Experience that effectively demonstrates the following skills and abilities:

- 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 express and organize thoughts, ideas, and information in a logical and concise manner both in writing and verbally.

- Interpersonal skills that build and maintain professional relationships with customers and counterparts

• Undergraduate degree in Computer Science, Information Technology, Data Analytics, or other data related field
• Highly proficient in SQL querying and data profiling tools
• Working knowledge of dimensional databases & star schema model designs and concepts
• Working knowledge of Business Intelligence and Analytics tools and techniques

Candidate Attributes:

• 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 Member-Policyholders and brokers
• Work Ethic: Takes ownership for one’s responsibilities by acting with integrity and holding oneself accountable to continuous improvement

Essential Job Functions:

Research and Analysis

• Responsible for business analysis and data analysis; ability to work independently with large datasets/extracts for analysis and inferences.
• Responsible for data analysis and providing insights into the data to the development team.
• Interview stakeholders to elicit business requirements and document the same

Data Management and Reporting

• Develop data mapping and transformation strategies to ensure seamless data integration and consistency between applications and the data warehouse.
• Review work requests and assist in the triage and assessment of work items.

Quality Assurance and Continuous Improvement

• Collaborate with the various teams (i.e., business, development, and QA) to ensure that tasks are handled and brought to closure in an efficient and timely manner.
• Gain an in-depth understanding of application functionality and the business processes supported by these applications. Perform quality assurance testing for reporting and analytics.
• Identify data issues and work with data specialists to identify the root cause.
• Provide user support/training in use of Dashboards, BI tools, and data marts.

www.aegislink.com

EOE

AEGIS Insurance Services, Inc. participates in E-Verify

We expect to pay a starting salary between $80,000 and $90,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, wellness incentive initiatives as part of the medical plan, 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