Data Analyst II

Description:

We are looking for a data analyst who will adhere to our reporting initiatives to deliver timely, relevant information to stakeholders. The ideal candidate will be motivated, results-driven, flexible, detail-oriented, and collaborative. Our fast-paced environment has a supportive culture that values autonomy, initiative, and personal accountability.

Job Duties:

• Prepare standard and ad hoc health management reports for presentation by client teams.

• Work collaboratively to ensure reporting that is accurate, timely, and of high quality.

• Generate benchmark data on a requested basis.

• Develop and support new analytical tools and reports, primarily using SQL and Tableau.

• Responsible for data consolidation, analysis, and business reporting.

• Develops and maintains reports for stakeholders at all levels of the organization.

• Provides support to research teams or management by collecting and analyzing data and reporting results based on the needs of end users.

• Maintains data integrity and data processing efficiency by working to eliminate redundancy and applying best practice data stewardship techniques.

• Stays informed of the ways the organization uses its data.

• Recognize data issues and work with data quality team to resolve problems.

• Must continuously be learning and staying abreast of technology advances.

• Provide exceptional customer service and adhere to the Lockton philosophies.

Requirements:

• Bachelor's degree required. Major in Mathematics, Statistics, Finance, Insurance, or Economics preferred.

• Intermediate knowledge and experience using SQL.

• Knowledge of Tableau and Power BI preferred.

• Advanced knowledge and experience using MS Excel.

• Understand data sources, processes, formulas, and output.

• Ability to understand data integrity and correctness.

• Previous experience working with claims data, CPT codes, and ICD-10 codes preferred.

• Proven ability to manage multiple projects simultaneously.

• Aptitude to develop unique, creative, and efficient work products.

• Excellent written and oral communication skills to effectively present information to associates at all levels of the Lockton organization.

• Assumes ownership for individual projects. Strong proactive style and self-motivated to actively seek solutions to problems without supervision.

• Ability to comply with all company policies and procedures, proactively protecting confidentiality of client and company information.

Qualifications:

• Bachelor's degree required. Major in Actuarial Science, Mathematics, Statistics or Finance.
• MS Excel experience required. In addition, experience using SQL and MS Access a plus.
• Understands data sources, processes, formulas and output General knowledge of healthcare issues and their associated impacts on plan sponsors and plan members.
• Ability to understand data integrity and correctness.
• Excellent written and oral communication skills to effectively present information to Associates at all levels of the Lockton organization.
• Strong proactive style.
• Proven ability to manage multiple projects simultaneously.
• Understands industry trends and governmental regulations
• Ability to complete continuing education requirements as needed
• Ability to attend company, department, and team meetings as required, including industry training sessions
• Ability to comply with all company policies and procedures, proactively protecting confidentiality of Client and company information
• Ability to efficiently organize work and manage time in order to meet deadlines
• Ability to travel by automobile and aircraft
• Ability to use office equipment such as a computer, keyboard, calculator, photocopier, and facsimile machine
• Ability to work on a computer for a prolonged amount of time
• Ability to work outside of normal business hours as needed
• Legally able to work in the United States