Job Description
Palm Medical Centers is seeking a self-motivated and detail-oriented Data Analyst to support our healthcare analytics team. This role is ideal for an early-career professional with strong analytical skills and a desire to grow within a fast-paced, data-driven environment. While initial responsibilities will include recurring report execution and Excel-based analysis, the position offers a clear path to expand into more advanced tools such as Power BI, SSRS, SSIS, Power Automate, and Python .
The successful candidate will demonstrate strong ownership, the ability to work independently, and the drive to evolve repetitive processes into automated, scalable solutions.
Duties/Responsibilities: - Develop, update, and maintain recurring reports using PostgreSQL, SQL, Excel, and Power BI.
- Perform detailed data validation and analysis across healthcare datasets (claims, encounters, members, providers).
- Automate manual Excel-based workflows using macros and scripting.
- Conduct root cause analysis of data anomalies and communicate findings clearly.
- Build Power BI dashboards with meaningful visualizations to support decision-making.
- Collaborate cross-functionally to gather requirements, prioritize tasks, and deliver accurate outputs independently.
- Support the migration of manual and legacy processes into automated workflows using SSIS, SSRS, KNIME, or Power Automate.
- Maintain documentation of data logic, reporting processes, and business rules.
Required Skills and Experience: - 1–3 years of experience in a data analyst, reporting analyst, or similar role.
- Advanced proficiency in Microsoft Excel, including macros, pivot tables, and formulas.
- Proficiency in PostgreSQL and SQL for querying and data manipulation.
- Experience building interactive dashboards in Power BI, including DAX and data modeling.
- Understanding of database languages, database design, and relational data structure.
- Strong sense of business ethics and ability to follow company policies and procedures.
- Quick learner with a creative, problem-solving mindset.
- Excellent time management skills with the ability to work independently and meet deadlines.
- Strong verbal and written communication skills for non-technical audiences.
Preferred/Developmental Skills: - Exposure to SSIS, SSRS, Power Automate, or KNIME.
- Familiarity with data warehousing concepts, including dimensional modeling and ETL processes.
- Understanding of healthcare data and managed care MA analytics.
Education/Experience: - Experience working with databases, data verification, and data management required; Managed Care MA Healthcare experience is highly preferred.
- Preferred (but not required) Bachelor’s degree in Information Systems, Computer Science, Healthcare Informatics or related field or equivalent experience.
- Bilingual (English/Spanish) required.
Physical Demand: - Prolonged periods sitting at a desk and working on a computer.
- Must be able to lift up to 15 pounds at times.
- Majority of work is performed in a corporate office setting, indoors.
- No travel requirement.
Schedule: - 8-hour shift
- Day shift
- Monday to Friday
Work setting: Palm Medical Centers is an equal opportunity employer that is committed to diversity and inclusion in the workplace. We prohibit discrimination and harassment of any kind based on race, color, sex, religion, sexual orientation, national origin, disability, genetic information, pregnancy, or any other protected characteristic as outlined by federal, state, or local laws.
This policy applies to all employment practices within our organization, including hiring, recruiting, promotion, termination, layoff, recall, leave of absence, compensation, benefits, training, and apprenticeship. Palm Medical Centers makes hiring decisions based solely on qualifications, merit, and business needs at the time.
Job Tags
Full time, Apprenticeship, Work at office, Local area, Shift work, Day shift, Monday to Friday,