AEGIS Insurance Services, Inc. (“AEGIS”) has an immediate opening for an Insurance Business Analyst to work closely with the data analytics team and business users to understand system requirements and assist in developing data solutions with our current data and analytics tools. The Business Analyst will monitor new requests and assist in the triage and oversight of the data lifecycle. The Business 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 resistanceCollaborative : Develops and maintains effective working relationships across functional and divisional lines by readily sharing information, knowledge, and resourcesDetail-Oriented : Displays thoroughness and accuracy in quality communications and deliverables through the application of technical skills and industry / product knowledgeService-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 brokersWork Ethic : Takes ownership for one’s responsibilities by acting with integrity and holding oneself accountable to continuous improvementEssential 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 sameData 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.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 accountsRetirement : 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 insuranceWellness : 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 servicesAdditional 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 opportunitiesHybrid work schedule
Salary : $80,000 - $90,000
