Pan-American Life Insurance Group (PALIG) is seeking a Data Analytics Analyst to join the U.S. Group Operations department within the U.S. Group Division. The Data Analytics Analyst will be responsible for working with the Data Analytics and Modeling Lead to maintain and run existing analytics and data ETL processes, to trouble-shoot data problems, and to collaborate to develop new products, better operational capabilities, and efficiency improvement initiatives. The Data Analytics Analyst will interact with all levels of staff and management in U.S. Group, across the organization, and with external business partners, and should consistently demonstrate an excellent ability to communicate. ESSENTIAL FUNCTIONS: Run Existing Analytics and Data ETL Processes and Trouble-Shoot Data Problems
- Run essential monthly Extract-Transform-Load (ETL) data processes for the Special Markets business area
- In collaboration with the Data Analytics and Modeling Lead, audit and trouble-shoot data problems as they arise, research and implement solutions
- Learn and understand the parts of the ETL flow and how to keep the data secure and uncorrupted as new data is loaded
- Produce necessary monthly reporting and collaborate on any changes and improvements requested during the monthly data cycle
- Work competently with the mix of technologies, including SQL Server, Access, Excel, and Excel VBA
Partner in Project Management and Coordination
- With the Data Analytics and Modeling Lead, act as liaison between business areas, IT, and, if necessary, external vendor partners to coordinate stakeholders, communicate needs, and document processes
- Create and maintain project plans and establish a high level of communication between stakeholders
- Understand system impacts and technology requirements to accomplish the project
- Document project requirements by listening to the needs of various internal stakeholders
- Establish task list for internal and external partners to ensure progress toward the timeline
- Understand and document internal dependencies and build project timeline to set realistic goals
- Facilitate internal and external meetings with relevant stakeholders
Research and Deploy Best Practices and Process Improvement
- Learn and understand current business processes and operational models
- Maintain current process documentation around implementation procedures
- Monitor implementations and attend opportunity assessment meetings to continually align with current and future business capabilities
- Standardize process documentation to facilitate accessibility and ease of use
- Conduct research, as needed, to explore industry best practices and provide recommendations and thought leadership to the business teams
EDUCATION & EXPERIENCE: - Bachelor's degree, preferably in business or a related field, plus 1 years' experience required
- 2+ years' experience in a technical business role, such as IT Analyst, Project Management, Business Analyst, etc., preferred
- Experience in the Financial Services industry, Insurance, in particular, preferred
KNOWLEDGE, SKILLS & ABILITIES: - Experience in at least one programming language (i.e., Python, VBA, R-Script, Java, JavaScript, C#, etc.)
- Experience in writing SQL queries for reporting and analysis (i.e., T-SQL, Access-SQL, or any SQL Variant)
- Experience with Informatica preferred
- Experience with Tableau preferred
- Interest in continuous improvement and promoting best practices
- Passionate about designing clear reporting, dashboards, and analytics
- Proficient in MS Office suite
- Bilingual (Spanish and English) skills preferred
- Excellent analytical and problem-solving skills
- Excellent verbal and written communication skills
- Project management skills
- Detail-oriented and able to discern the important details needed for an analytics task and project
- Strong organization and time management skills with the ability to prioritize tasks
- Ability to build collaborative relationships while focusing on achieving business goals
- Ability to document processes and procedures
- Ability to interpret data, formulate reports, and present data
- Ability to manage multiple tasks, deadlines, and priorities
- Ability to present ideas effectively to individuals or groups, formally or informally
Pan-American Life Insurance Group Offers: - Comprehensive Compensation Packages (base & bonus)
- A Comprehensive Benefits Package: Medical, Dental, 401K, Paid Time Off, and Tuition Reimbursement (etc.) are some examples. New hires are eligible for medical and dental coverage on the first of the month following 30 days of service.
- Hybrid Work Opportunities
Who We Are: Pan-American Life Insurance Group (PALIG) serves the life, accident, and health insurance needs of individuals and businesses in 49 U.S. states, the District of Columbia, Puerto Rico and the U.S. Virgin Islands through its U.S. based member companies - Pan-American Life Insurance Company and Pan-American Assurance Company. At Pan-American Life, our employees are our greatest asset. We are grateful for the collaborative efforts of our employees and partners, and for the confidence of the policyholders whose life and health we protect. It is through this long-standing commitment that Pan-American Life continues to succeed.
Pan-American Life is an Equal Opportunity Employer/Drug Free Workplace.