Data Analyst

WebTPA; Irving (TX); On-site; USD 65,000 - 90,000; Full time

Benefits offered by this job

Health insurance

401(k)

Paid time off

Disability coverage

Wellness program

Holidays

Job summary

WebTPA, based in Irving, TX, seeks a Data Analyst to enhance reporting and analytics capabilities. The role focuses on data management, BI support, and improvements to reporting processes, including involvement in data warehouse and data marts development for stakeholders.

Key responsibilities include generating reports, solving day-to-day workflow issues, identifying process improvements, and collaborating with vendors and clients to deliver data-driven solutions. Onsite position.

Qualifications

• 3+ years in analytical, data-driven roles.
• Bachelor's degree or equivalent experience.
• Strong SQL and data warehousing knowledge.
• Advanced Excel skills.
• Ability to translate business needs into data solutions.
• Able to work autonomously and in a team.

Responsibilities

• Generate accurate and timely reports for internal and external clients.
• Support reporting and analytics workflows and strategic company initiatives.
• Identify weaknesses in existing reporting processes and lead improvements.
• Design, develop, and refine proprietary software to address reporting and analytics needs.
• Assist in developing data warehouses and data marts for reporting and analytics support.
• Build reporting processes that support internal and external clients.
• Create data exports and support external vendor initiatives.
• Create ad-hoc data imports and support various company initiatives.

Skills

SQL

Excel

Vendor communication

Data integration

Project management

Time management

Education

Bachelor's degree in Business, Engineering, Math, Computer Science, or MIS

Tools

Power BI

SSIS

SSRS

SSAS

Access Form Development

VBA

Crystal Reports

SQL

Job description

The Data Analyst role at WebTPA focuses on improving reporting and analytics capabilities through data management, business intelligence support, and enhancements to reporting processes. The position also contributes to data warehouse and data mart development to support internal and external stakeholders.

Key Responsibilities

• Generate accurate and timely reports for internal and external clients using appropriate technology.
• Support problem solving for the day-to-day workflows of the reporting and analytics team, as well as longer-term strategic company initiatives.
• Identify opportunities and weaknesses in existing reporting processes, then lead the implementation of effective solutions.
• Design, develop, and refine proprietary software to address reporting and analytics team needs.
• Assist in the development of data warehouse and data marts for reporting and analytics support.
• Build reporting processes that support internal and external clients.
• Apply out-of-the-box solutions to business issues and long-term initiatives.
• Create data exports and provide expert support for external vendor initiatives.
• Create ad-hoc data imports and provide expert support for various company initiatives.

Required Qualifications

• 3+ years of 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, including knowledge of data warehousing.
• Advanced proficiency with Microsoft Excel.
• Comfort communicating directly with vendors and clients.
• Ability to work with many data sources to deliver solutions for internal and external clients.
• Strong capability to translate business needs into data and technology solutions.
• Ability to work both autonomously and collaboratively as part of a team.
• Self-motivated approach to assessing problems and proposing workable solutions.
• Strong time management and project management skills.

Technologies Used

• SQL
• Microsoft Excel
• Power BI
• SSIS
• SSRS
• SSAS
• Microsoft Access Form Development
• VBA
• Crystal Reports

Preferred Qualifications

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

Location and Job Details

• Onsite position in Irving, TX (6535 SH 161 Irving Texas 75063).
• No visa sponsorship provided.
• Local candidates only considered; relocation not provided.

Benefits

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

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.