What You Can Expect In This Role
Looking for a Data Analyst to manage and analyze trouble tickets related to data inconsistencies and system errors, identifying root causes and implementing corrective actions. Analyze large datasets in the EDW and Snowflake environments to derive insights, support decision-making, and ensure data quality across insurance product lines.
What You'll Do In This Role
Key Competencies
- Analytical Thinking: Ability to analyze data patterns and trends, identify discrepancies, and provide solutions for data-related issues.
- Technical Expertise: Proficient in SQL, with experience in querying and managing data within both on-premise and cloud (Snowflake) data environments.
- Problem Solving: Skilled at troubleshooting data issues, addressing root causes, and implementing efficient solutions.
- Collaboration: Effective communication and teamwork skills to work with cross-functional teams across various time zones.
- Attention to Detail: Detail-oriented approach to data integrity, quality assurance, and documentation.
Technical Skills
- Proficiency in SQL, with knowledge of advanced queries and data manipulation.
- Familiarity with ETL processes, data warehouse design, and data integration methods.
- Experience with trouble ticketing systems or service management tools is a plus.
Other Skills
- Strong written and verbal communication skills.
- Ability to work independently and collaboratively within a team.
- Comfortable working in a fast-paced, multi-tasking environment with both onshore and offshore teams.
Key Responsibilities
- Troubleshoot and Resolve Data Issues: Manage and analyze trouble tickets related to data inconsistencies and system errors, identifying root causes and implementing corrective actions.
- Data Analysis and Reporting: Analyze large datasets in the EDW and Snowflake environments to derive insights, support decision-making, and ensure data quality across insurance product lines.
- Collaboration: Work closely with onshore and offshore team members to address data issues promptly and support operational objectives.
- Data Management and Querying: Use SQL extensively to query data, develop reports, and support ad-hoc data requests from business stakeholders.
- Support Data Integrity: Maintain and enhance data quality, integrity, and accuracy within the Enterprise Data Warehouse, ensuring compliance with company standards and regulatory requirements.
- Process Documentation: Document troubleshooting steps, analysis processes, and resolutions for knowledge sharing within the team.
What We're Looking For
- College Degree in the field of computer science, information science, management information systems Preferred
- Minimum 8 years' IT development experience or equivalent Preferred
- Effective verbal and written communications skills and the ability to communicate with business partners and other IT staff
- Problem solving skills sufficient to perform research and recommend a proposed solution to problems
- Able to work on multiple tasks and meet established deadlines
- Able to effectively direct and coordinate the work of other team members on a project without having HR management responsibility for them
- Knowledge of computer programming languages as required for the system
Other Requirements
- Criminal background check required.
What you can expect when you join Sammons Financial Group
- Sammons Financial Group offers a competitive benefit package that includes: Health, Dental, Vision, Company Paid Retirement, PTO and Holiday Pay.
- Our Employee Stock Ownership Plan (ESOP) is a 100% company-funded retirement plan, so you can save for retirement without contributing a penny of your own paycheck.
- Healthy balance between work and personal lives. Friday afternoons off all year long, competitive PTO, and generous number of paid holidays.
- Our incentive program for defined goals subject to eligibility and performance. Monetary rewards are based on individual and/or overall company performance.
- Colleagues who support one another, model our core values, and drive our healthy, high-performing culture.
Salary Range Information
USD $80,638.00 - USD $167,997.00 /Yr. Range includes data points from multiple labor markets. Specific range is dependent on the labor market where the incumbent will be hired to perform the position. Starting salary is dependent on candidate qualifications and experience. For a narrower salary range specific to your labor market, please inquire.
Work Authorization/Sponsorship
At this time, we’re not considering candidates that need any type of immigration sponsorship now or in the future or those needing work authorization for this role (This includes, but is not limited to students on F1-OPT, F1-CPT, J-1, etc.)
