Excel Expert

WeCare Medical; San Antonio (TX); Remote; USD 169,000 - 245,000; Full time

Job summary

WeCare Medical, a leading healthcare organization, is seeking a Remote Excel Expert. In this role, you'll utilize advanced Excel capabilities to develop spreadsheets, automate tasks with VBA, and create reports supporting operational metrics. Candidates should possess 5+ years of experience and a deep understanding of Excel features and functions.

Benefits

Health, dental, and vision insurance

Paid time off (PTO) and holidays

Retirement plan with company match

Opportunities for professional development

Flexible remote work environment

Qualifications

• Minimum 5 years experience as an Excel expert.
• Demonstrated mastery of Microsoft Excel including advanced formulas.
• Proven ability to develop and implement VBA macros.

Responsibilities

• Design and build complex spreadsheets to track and report healthcare data.
• Develop and implement advanced formulas for data manipulation.
• Analyze data sets and create insightful reports.

Skills

Advanced Excel Functions

Data Analysis

VBA Automation

Data Validation

Education

Associate's or Bachelor's degree in Business, Finance, or Data Analysis

Job description

2 days ago Be among the first 25 applicants

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

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.

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.

Data Validation and Integrity: Implement robust data validation rules and techniques to ensure data accuracy, consistency, and integrity within spreadsheets.

Automation with VBA (Macros): Develop, implement, and maintain VBA macros to automate repetitive tasks, streamline workflows, and improve efficiency.

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.

Template Creation and Standardization: Develop and maintain standardized Excel templates to ensure consistency in data collection and reporting across different departments.

Data Import and Export: Efficiently import and export data from various sources (e.g., CSV, TXT, databases) into and out of Excel.

Collaboration and Communication: Work closely with various departments and stakeholders to understand their data needs, gather requirements, and provide Excel-based solutions.

Troubleshooting and Support: Provide expert-level troubleshooting and support to end-users for Excel-related issues and questions.

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.

Staying Current: Keep abreast of the latest Excel features, updates, and best practices.

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.

WeCare Medical Specialty Group offers a competitive salary and a comprehensive benefits package, including:

Health, dental, and vision insurance

Paid time off (PTO) and holidays

Retirement plan with company match

Opportunities for professional development and growth

Flexible remote work environment

Equal Opportunity Employer

WeCare Medical Specialty Group is an equal opportunity employer and values diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. All qualified applicants are encouraged to apply.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Other

• Industries

  Wellness and Fitness Services

Referrals increase your chances of interviewing at WeCare Medical Specialty Group by 2x

Get notified about new Expert jobs in San Antonio, TX.

San Antonio, Texas Metropolitan Area 1 month ago

San Antonio, TX $169,228.80-$244,441.60 1 month ago

San Antonio, TX $131,622.40-$169,228.80 1 month ago

Automotive / Car Sales Consultant - Ford of Boerne

ARPA Accountant (Temporary) Grant-Funded

Prevention Specialist (Part-Time) (44335)

San Antonio, Texas Metropolitan Area $55,000.00-$65,000.00 23 hours ago

San Antonio, TX $49,500.00-$71,500.00 1 month ago

San Antonio, TX $78,624.00-$113,568.00 1 month ago

Technical Author (multiple roles and seniority levels)

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.