Data Analyst I

AEGIS; Jersey City (NJ); On-site; USD 80,000 - 100,000; Full time

Job summary

AEGIS Insurance Services, Inc. is seeking a Data Analyst I to join the analytics team and translate business requirements into reporting and data solutions using our tools. You will design dashboards and perform QA testing, ensuring data quality and timely insights.

You will collaborate with source system teams, document requirements, and support business users in interpreting data patterns to drive informed decisions. Salary range $80,000–$100,000 with annual incentive eligibility.

Qualifications

• Undergrad degree in a data-related field.
• Proficiency in SQL for data querying and manipulation.
• Knowledge of relational databases and star schema concepts.
• Exposure toBI and analytics tools and techniques.

Responsibilities

• Translate business requirements into technical specifications for reporting and analytics.
• Document requirements and convert them into specs.
• Configure and create reports, analytics, and dashboards with Pyramid Analytics.
• Coordinate and report on data and analytics work.
• Perform QA testing for reporting and analytics.
• Review requests and triage work items.
• Identify data issues and work with data specialists to root cause.
• Review and analyze data from multiple sources to provide insights.
• Develop QA testing methodologies and execute them.
• Provide user support and training for dashboards and data marts.

Skills

SQL

Data analysis

BI concepts

Interpersonal skills

Collaboration

Documentation

Quality assurance

Data visualization

Education

Undergraduate degree in Computer Science / IT / Data Analytics

Tools

Pyramid Analytics

Job description

AEGIS Insurance Services Inc. has an immediate opening for:

Data Analyst I

Job Description:

AEGIS Insurance Services, Inc. ("AEGIS") has an immediate opening for a Data Analyst I 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 I will monitor new requests and assist in the triage and oversight of the data lifecycle. The Data Analyst I will work on designing and developing enterprise-wide data analysis and reporting solutions and also work to test these solutions.

Job Requirements:

• 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.

• Knowledge of relational database & star schema model designs and concepts.

• Proficiency in SQL for data querying and manipulation.

• Some exposure to Business Intelligence and Analytics tools and techniques.

Candidate Attributes:

• Collaborative Communications and Behavior: Develops and maintains effective working relationships as a team member and across divisions; readily collaborates and shares information, seeks and provides constructive feedback, and supports a respectful workplace

• Initiative and Accountability: Proactively addresses opportunities to enhance AEGIS’ people, processes, products, and services, takes ownership for one’s responsibilities by acting with integrity and in the best interest of the organization and stakeholders

• Quality-Focused: Demonstrates a solution-focus, displays thoroughness and accuracy through quality deliverables, and demonstrates persistence and perseverance in achieving concrete and tangible outcomes

• 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

Essential Job Functions:

• Work closely with the business and the analytics team to understand business requirements and translate them into specifications for building reporting and analytics solutions including visualizations.

• Document business requirements and translate them into technical specifications.

• Configures and creates reports, advanced analytics, and dashboards with AEGIS’ Pyramid Analytics platform.

• Coordinate and report on work in support and delivery of data and analytics functions in the organization.

• Perform quality assurance testing for reporting and analytics.

• Review work requests and assist in the triage and assessment of work items.

• Identify data issues and work with data specialists to identify the root cause.

• Review and analyze data from multiple internal and external sources, identifying data patterns & trends, and provides insights to enhance business decision making capabilities.

• Develop quality assurance testing methodology/criteria and execute them.

• 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 $100,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 & wellness, retirement, income protection, time off and additional benefits:

• Health &