Position Purpose:

Serves as an advanced analytical resource responsible for defining data requirements, validating enterprise data solutions, and ensuring alignment between business objectives and technical implementation.

Acts as the primary analytical owner for reporting and data initiatives, translating business needs into structured data definitions and validation logic. Partners closely with Data Engineers to ensure accurate implementation within established data models and architectural standards.

Independently leads small to medium initiatives and contributes significantly to larger efforts by bringing forward well-developed recommendations and risk assessments prior to implementation.

Essential Functions:

Gathers and defines reporting and data requirements in collaboration with managers and operational stakeholders. Translates business needs into data definitions, transformation rules, validation criteria, and reporting specifications. Ensures requirements are complete and testable prior to development.

Develops SQL queries and analytical logic to validate ETL outputs and reporting accuracy. Reconciles discrepancies and confirms adherence to defined business rules. Collaborates with Data Engineers to resolve issues and refine logic as needed.

Coordinates and executes UAT efforts to confirm solutions meet defined functional and data accuracy requirements. Documents findings and ensures corrections are addressed prior to production release.

Traces data flow across systems to assess downstream impacts of new data elements or definition changes. Identifies risks and dependencies and communicates findings and recommendations as appropriate.

Reinforces enterprise data definitions, naming conventions, and documentation practices. Identifies inconsistencies in business logic and recommends improvements. Provides mentorship and peer guidance as the analyst function grows.

Performs other duties as assigned.

Requirements:

Education: Bachelor's degree in Business Administration, Computer Science, Management Information Systems, or related field; or equivalent combination of education and experience.

Experience:

• 4-6 years in data analysis, reporting, or data warehouse environments with increasing responsibility.
• Demonstrated leadership in requirements gathering and user acceptance testing efforts.
• Proven ability to validate and reconcile data within ETL or warehouse solutions.
• Strong track record translating business rules into structured data definitions and technical specifications.
• Industry knowledge in insurance or financial services preferred.

Skills:

• Advanced proficiency in SQL and strong working knowledge of relational and warehouse data environments.
• Ability to define, document, and validate business data logic with precision.
• Demonstrated strength in structured problem-solving, impact analysis, and issue resolution.
• Effective communicator capable of engaging technical teams and business stakeholders.
• Demonstrates accountability and sound judgment while managing multiple concurrent initiatives.

Mental Demands: Ability to analyze complex business and data scenarios with limited direction. Ability to interpret requirements, evaluate alternatives, and identify root causes through structured problem-solving. Must be able to manage multiple initiatives, communicate findings clearly, and maintain a high level of accuracy while working under deadlines. Ability to adapt to changing priorities and collaborate effectively with technical and business stakeholders.

Physical Demands: Continuous sitting for extended periods of time, some standing, walking, bending and reaching. Frequent use of fingers and hands to manipulate computer, telephone and other office equipment. Ability to be able to look and concentrate at a computer screen/monitor for extended periods of time.