Junior Data Analyst Job at Keystone Advisors, Houston, TX

Y1Awc1dsVEhoWVM1NVNQTUd3TEQ0dUNiZUE9PQ==
  • Keystone Advisors
  • Houston, TX

Job Description

Company Overview

Keystone Advisors is a full-service marketing company aligned with Top Health Insurance Carriers to provide our partners and clients a broad and competitive portfolio of Insurance Options. We have over 20 years of experience in Insurance marketing while serving our local communities with Medicare, Individual, Group Health, Life, and Annuity products. Our core values are Customer service, integrity, compassion, tenacity, and collaboration.

Job Summary

We are seeking a detail-oriented Junior Data Analyst to join our growing team. In this role, you will transform raw data into meaningful insights by collecting, cleaning, and analyzing data to support data-driven decision-making across our organization. The ideal candidate will have advanced proficiency in Excel—including expertise in functions such as XLOOKUP—and some entry-level experience with Python for data manipulation. This is an excellent opportunity to develop your analytical skills and grow in a dynamic, collaborative environment.

Key Responsibilities

  • Data Collection & Cleaning: Gather, organize, and validate data from various internal and external sources. Ensure data integrity through routine cleaning and quality checks using Excel and other tools. Major emphasis on attention to detail.
  • Data Analysis & Reporting: Analyze datasets to identify trends, patterns, and insights. Develop and maintain reports using Excel (advanced functions including XLOOKUP, pivot tables, and macros) as well as visualization tools such as Salesforce Analytic Studio. A Utilize entry-level Python skills to automate routine data tasks, including data cleaning and basic statistical analysis using libraries such as pandas, NumPy, and matplotlib.
  • Collaboration & Communication: Work closely with cross-functional teams to understand data needs and support business initiatives. Present findings in a clear and concise manner to both technical and non-technical audiences.
  • Continuous Improvement: Support initiatives to improve data collection and analysis processes. Stay updated on best practices in data analysis and reporting, with a focus on maximizing technical capabilities.

Required Qualifications

  • Bachelor’s degree in Data Science, Statistics, Mathematics, Computer Science, or a related field.
  • Advanced Excel skills, including proficiency with functions such as XLOOKUP, pivot tables, and macros.
  • Experience with at least one data analysis tool/language (e.g., SQL, Python, or R).
  • Strong analytical skills and attention to detail.
  • Familiarity with data visualization tools (e.g., Tableau, Power BI, or similar).
  • Familiarity with Salesforce.
  • Excellent communication and problem-solving skills.
  • Ability to work collaboratively in a team environment.

Preferred Qualifications

  • Internship or prior work experience in data analysis or a related field.
  • Familiarity with statistical analysis techniques and tools.
  • Experience with data cleaning and transformation processes.

Job Tags

Work experience placement, Local area,

Similar Jobs

Johns Hopkins Medicine

Business Intelligence Analyst II Job at Johns Hopkins Medicine

Join an amazing global healthcare organization with lots of opportunities for growth! Awesome benefits include: Medical ~ Dental ~ Vision ~ Nutrition Management ~ Fitness Programs ~ Retirement ~ Daily-Life Assistance ~ Family Resources ~ Educational Benefits ...

iRecruitMD

Pulmonary Sleep Medicine Physician Job at iRecruitMD

(Physician/MD qualifications required) Sleep Medicine - Pulmonary - Sleep Medicine Physician (No Critical Care) Scottsdale, AZ Area Are you ready to elevate your career while enjoying an exceptional quality of life? We are seeking a Pulmonary - Sleep Medicine Physician... 

Glen Haven Health And Rehabilitation LLC

Dietary Aide Job at Glen Haven Health And Rehabilitation LLC

 ...will form significant relationships with them and celebrate the successes they experience along the way. We are in search of a Dietary Aide to join ourorganization: # Assist in the preparation, service and delivery of meals and snacks. # Assist in daily or... 

Cordis

Analytical Chemist I, Selution Job at Cordis

 ...of millions, then Cordis is just the place for you. We are the people behind the people who keep saving lives. The Analytical Chemist I will be responsible for the various chemistry lab related tasks including, data management, testing, ordering supplies, and lab... 

Stokes Creative Group, Inc.

Senior Communications/Public Relations Specialist Job at Stokes Creative Group, Inc.

 ...Group, Inc., a full-service marketing and public outreach firm specializing in the...  ...communication team to develop and implement public information and outreach efforts. Assisting the...  ...WBE/DBE/SBE/WBENC company and with office locations in New Jersey, Florida,and Maryland...