Hybrid Data & Analytics Associate - Turn Data Into Strategy

Security Mutual Life Insurance Company of New York; City of Binghamton (NY); Hybrid; USD 55,000 - 75,000; Full time

Job summary

Security Mutual Life Insurance Company of New York is seeking a Data & Analytics professional in the Binghamton, NY area. The role involves collecting, cleansing, and analyzing data from various systems to identify trends and forecast outcomes.

You will develop and maintain SQL queries and Power BI dashboards to track KPIs, quality, timeliness, and compliance. Collaborating with management, you will translate business requirements into analytics solutions, conduct routine data audits, and

Qualifications

• 0 to 2 years in data analytics, business intelligence, reporting, or a related field required.
• Advanced proficiency in Microsoft Windows and Office Suite required.
• Experience using querying, joins, and aggregations within SQL required.
• Intermediate Power BI Experience Required.

Responsibilities

• Collect, organize, validate, and analyze data from multiple sources to identify trends and forecasts.
• Write, update, and maintain SQL queries, reports, and Power BI dashboards.
• Translate business requirements into reporting solutions and evaluate data solutions to meet needs.
• Conduct routine audits of systems and databases to ensure data accuracy, integrity, and security.
• Prepare and respond to ad hoc data requests, balancing speed and accuracy.
• Validate and reconcile data from multiple sources to identify discrepancies and improve quality.
• Apply basic statistics to interpret data patterns for decision-making.
• Design and format reports for non-technical audiences; document data definitions and sources.
• Support automation of recurring reporting; prepare materials for management analysis and recommendations.
• Stay current with data analytics tools and best practices.

Skills

Data analysis

SQL

Power BI

Microsoft Office

Job description

Security Mutual Life Insurance Company of New York is seeking a Data & Analytics professional in the Binghamton, NY area. The role involves collecting, cleansing, and analyzing data from various systems to identify trends and forecast outcomes.

You will develop and maintain SQL queries and Power BI dashboards to track KPIs, quality, timeliness, and compliance. Collaborating with management, you will translate business requirements into analytics solutions, conduct routine data audits, and