Excel Expert

WeCare Medical Specialty Group; San Antonio (TX); Remote; USD 60,000 - 80,000; Full time

Job summary

A leading healthcare organization is seeking a Remote Excel Expert responsible for advanced spreadsheet development, data analysis, and automation using VBA. The ideal candidate will have extensive experience with Excel, strong analytical skills, and excellent communication abilities. This fully remote role requires a proactive individual who can collaborate effectively across departments to meet data needs and ensure data integrity.

Qualifications

• Minimum of 5 years of professional experience as an Excel expert.
• Demonstrated mastery of Microsoft Excel, including advanced formulas and functions.

Responsibilities

• Design and build complex Excel spreadsheets for healthcare data.
• Develop and implement advanced Excel formulas and functions.
• Analyze large datasets and create reports using charts and graphs.

Skills

Excel Proficiency

Data Analysis

Communication Skills

Organizational Skills

Problem-Solving Skills

Education

High school diploma or equivalent

Associate's or Bachelor's degree

Tools

VBA

Power Query

Job description

Join to apply for the Excel Expert role at WeCare Medical Specialty Group.

WeCare Medical Specialty Group is a leading healthcare organization committed to delivering exceptional patient care and operational excellence. We recognize the critical role of data management and analysis in achieving our goals. We foster a collaborative and results-oriented environment where skilled individuals can contribute significantly to our success through their expertise.

Position Summary:

We are seeking a highly skilled and detail-oriented Remote Excel Expert to join our team. In this role, you will be the go-to resource for all things Excel, responsible for creating, maintaining, and optimizing complex spreadsheets, developing sophisticated formulas and functions, automating tasks using macros (VBA), and generating insightful reports to support various departments across our organization. This is a fully remote position requiring a proactive, organized, and communicative individual with a deep understanding of Excel and its advanced capabilities.

Responsibilities:

1. Advanced Spreadsheet Development: Design and build complex and efficient Excel spreadsheets and workbooks to track, analyze, and report on various healthcare data, including patient information (de-identified), operational metrics, financial data, and more.
2. Formula and Function Mastery: Develop and implement advanced Excel formulas and functions (e.g., SUMIFS, COUNTIFS, VLOOKUP, INDEX/MATCH, array formulas) to perform complex calculations, data manipulation, and analysis.
3. Data Validation and Integrity: Implement robust data validation rules and techniques to ensure data accuracy, consistency, and integrity within spreadsheets.
4. Automation with VBA (Macros): Develop, implement, and maintain VBA macros to automate repetitive tasks, streamline workflows, and improve efficiency.
5. Data Analysis and Reporting: Analyze large datasets within Excel, identify trends and patterns, and create clear, concise, and visually appealing reports and dashboards using charts, graphs, and conditional formatting.
6. Template Creation and Standardization: Develop and maintain standardized Excel templates to ensure consistency in data collection and reporting across different departments.
7. Data Import and Export: Efficiently import and export data from various sources (e.g., CSV, TXT, databases) into and out of Excel.
8. Collaboration and Communication: Work closely with various departments and stakeholders to understand their data needs, gather requirements, and provide Excel-based solutions.
9. Troubleshooting and Support: Provide expert-level troubleshooting and support to end-users for Excel-related issues and questions.
10. Documentation and Training (Occasional): Create clear and concise documentation for developed spreadsheets and macros, and potentially provide basic training to other employees on Excel best practices.
11. Staying Current: Keep abreast of the latest Excel features, updates, and best practices.
12. Data Security and Compliance: Adhere to all data security and privacy regulations, particularly concerning sensitive healthcare information, when working with Excel.

Qualifications:

• Work Permit/Citizenship: Must be a United States citizen or possess a valid work permit allowing employment in the United States.
• Education: High school diploma or equivalent required; Associate's or Bachelor's degree in a related field (e.g., Business, Finance, Data Analysis) is a plus.
• Experience: Minimum of 5 years of professional experience as an Excel expert or in a role heavily reliant on advanced Excel skills.
• Expert-Level Excel Proficiency: Demonstrated mastery of Microsoft Excel, including advanced formulas, functions, charting, data validation, conditional formatting, pivot tables, and Power Query (Get & Transform Data).
• VBA (Macros) Proficiency: Proven ability to develop, implement, and troubleshoot VBA macros to automate tasks and enhance spreadsheet functionality.
• Data Analysis Skills: Strong analytical and problem-solving skills with the ability to interpret data, identify trends, and generate meaningful insights.
• Attention to Detail: Meticulous attention to detail and a commitment to accuracy in all aspects of work.
• Communication Skills: Excellent written and verbal communication skills, with the ability to clearly explain technical concepts to non-technical users.
• Organizational Skills: Strong organizational and time management skills with the ability to manage multiple requests and prioritize tasks in a remote environment.
• Problem-Solving Skills: Ability to independently identify and resolve complex Excel-related issues.
• Remote Work Capabilities: Must have a reliable internet connection and a dedicated home office setup suitable for remote work.
• Healthcare Industry Knowledge (Preferred): Familiarity with healthcare data and terminology is a plus but not required.