Data Analyst - Irving, Texas

GuideWell; Irving (TX); On-site; USD 70,000 - 90,000; Full time

Job summary

WebTPA, a GuideWell Company, is seeking a Data Analyst in Irving, Texas to manage data, BI, and reporting processes. You will generate timely reports, solve daily workflow issues, and lead improvements across reporting activities within a collaborative team.

The role focuses on designing and refining proprietary software, developing data warehouse components, and delivering actionable insights for internal and external clients with strong communication to vendors and stakeholders.

Qualifications

• 3+ years of experience in an analytical, data-driven role.
• Bachelor’s degree in Business, Engineering, Math, CS, MIS or related equivalent work experience.
• Strong SQL writing skills and data-warehousing knowledge.
• Mastery of Microsoft Excel.
• Comfortable communicating with vendors and clients.
• Able to translate business needs into data-driven solutions.

Responsibilities

• Generate accurate and timely reports for internal and external clients.
• Assist with problem solving in reporting & analytics day-to-day processes.
• Identify weaknesses in reporting processes and implement solutions.
• Design, develop and refine software to support analytics needs.
• Assist in developing data warehouse & data marts.
• Build reporting processes for clients and internal teams.
• Apply innovative solutions to business challenges and initiatives.
• Create data exports and support external vendor initiatives.
• Create ad-hoc data imports and support various initiatives.

Skills

SQL writing

Data warehousing

Microsoft Excel

Vendor/Client communication

Education

Bachelor's degree in Business, Engineering, Math, CS, MIS

Tools

Power BI

SSIS

SSRS

SSAS

MS Access Form Development

VBA

Crystal Reports

Job description

GetToKnow Us!

WebTPA, a GuideWell Company, is a healthcare third-party benefit administrator with over 30+ years of experience building unique benefit solutions and managing customized health plans.

Key Job Details:

• In office 6535 SH 161 Irving Texas 75063
• No VISA sponsorship provided
• Local candidates only considered, relocation not provided

What is your impact?

The Data Analyst is responsible for data management, business intelligence management, and reporting process improvement. This position will focus on management of reporting data and evaluating, developing and implementing impactful reporting process solutions.

What Will You Be Doing:

• Generate accurate and timely reports to internal and external clients using technology.
• Assist with problem solving efforts related to day-to-day processes of the reporting & analytics team and long-term strategic initiatives of the company.
• Recognize opportunities and weaknesses within reporting processes and lead implementation of their effective solutions.
• Design, develop and refine proprietary software to support reporting & analytics team needs.
• Assist in the development of data warehouse & data marts for the reporting & analytics team.
• Build reporting processes to assist internal and external clients
• Apply out-of-the-box solutions to business issues and long-term initiatives.
• Construct data exports and/or provide expert support for external vendor initiatives.
• Construct ad-hoc data imports and/or provide expert support for various initiatives.

What You Must Have:

• 3+ years related work experience in an analytical, data-driven role
• Related Bachelor’s degree in Business, Engineering, Math, Computer Science, or MIS or additional related equivalent work experience
• Strong SQL writing skills with knowledge of data-warehousing
• Master of Microsoft Excel
• Comfortable communicating directly with vendors and clients.
• Comfortable using many sources data to generate solutions for internal and external clients
• Strong ability to translate business needs directly into solutions using data and technology
• Ability to work both autonomously and collaboratively as a member of a team
• Must be self-motivated with the ability to assess problems/issues and offer workable solutions
• Strong time and project management skills

What Is Preferred:

• Experience with healthcare claims data, healthcare terminology and healthcare operations preferred.
• Experience with Power BI, SSIS, SSRS, SSAS, Microsoft Access Form Development, VBA, or Crystal Reports a plus.

What We Can Offer YOU!

To support your wellbeing, comprehensive benefits are offered. As a WebTPA employee, you will have access to:

• Medical, dental, vision, life and global travel health insurance
• Life insurance, Short- and long-term disability programs
• Leave programs to support personal circumstances.
• 401(k) includes employer contribution match
• Paid time off, volunteer time off, and 11 holidays
• Additional voluntary benefits options avaliable
• Comprehensive wellness program

Employee benefits are designed to align with federal and state employment laws. Benefits may vary based on the state in which work is performed. Benefits for interns and part-time employees may differ.

General Physical Demands

Sedentary work: Exerting up to 10 pounds of force occasionally to move objects. Jobs are sedentary if traversing activities are required only occasionally.

We are an Equal Employment Opportunity employer committed to cultivating a work experience where everyone feels like they belong and can perform at their best in pursuit of our mission. All qualified applicants will receive consideration for employment.