Data Analyst I - Analytics & Reporting Specialist (Hybrid)

AISI AEGIS Insurance Services, Inc.; New Jersey; Hybrid; USD 80,000 - 100,000; Full time

Benefits offered by this job

Hybrid work schedule

Health & wellness benefits

401(k) with matching

Employee assistance programs

Job summary

AEGIS Insurance Services, Inc. is seeking a Data Analyst I to support the analytics team by translating business requirements into data solutions and dashboards. You will help design enterprise-wide reporting and test solutions using Pyramid Analytics and other BI tools.

Collaborate with source system teams, understand data lineage, perform QA, and assist in the data lifecycle governance while delivering insights to drive informed business decisions.

Qualifications

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

Responsibilities

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

Skills

SQL

Data lineage

Relational databases

Star schema

BI tools

Communication

Teamwork

Education

Undergraduate degree in Computer Science/IT/Data Analytics

Tools

Pyramid Analytics

Job description

AEGIS Insurance Services, Inc. is seeking a Data Analyst I to support the analytics team by translating business requirements into data solutions and dashboards. You will help design enterprise-wide reporting and test solutions using Pyramid Analytics and other BI tools.

Collaborate with source system teams, understand data lineage, perform QA, and assist in the data lifecycle governance while delivering insights to drive informed business decisions.