Data Analyst (SQL, Excel) Job at Elan Partners in Dallas

Title: Data Analyst (SQL, Excel)

Long-term contract, 1+ year

No Sponsorship

Remote (prefer candidates local to Texas)

Seeking a highly skilled and detail-oriented Data Analyst to join our team. In this role, you will play a pivotal part in synthesizing, managing, and visualizing data to support legal departmental and client needs. You will leverage your expertise in SQL, Excel, and data management tools to analyze, streamline workflows, and deliver actionable insights for internal and external stakeholders.

REQUIREMENTS:

• Advanced knowledge of SQL, Microsoft Excel, and VBA (Python and Power Query are a plus)
• Experience with data extraction, including reviewing, auditing, analysis, and manipulation of large datasets for internal/external reporting.
• Experience creating reports with data visualization tools like Power BI and Tableau and writing Excel Macros to create client deliverable reports and clean raw data to show progression to legal and medical clients.

PREFFERED:

• Familiarity with NoSQL databases and cloud-based data solutions like Ragic.
• Experience as a Data Analyst in Legal, Medical, or Financial fields.

JOB RESPONSIBILITIES:

• Extract, manipulate, and analyze client data for internal and external use with SQL and Excel.
• Receive, format, and import client data to custom-built database applications with Excel, SQL, and MS Access.
• Leverage Excel, SQL, and Python for data processing and transformation and Tableau for visualization and tracking.
• Coordinate with business stakeholders, technical analysts, and other developers to identify and define specifications; Indicate areas of system impact and continuously communicate project status and needs.
• Create and maintain digital files for data transfer with department-related agencies.
• Audit medical claims itemizations and investigate discrepancies, both manually and with the use of the auditor tool.
• Follow all QC checklists as required and note each file clearly explaining what steps were taken.
• Maintain digital client files.
• Follow up on assigned files in a timely manner and exercise judgment regarding solutions to problematic files, including when to escalate to a senior case analyst or management.
• Organizing and tracking case progress in our systems.
• Assisting with resolution and negotiation, including proposing solutions to escalated issues based on historical data.