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

Bonaventure Senior Living

Nurse/Quality Assurance Job at Bonaventure Senior Living

Bonaventure Senior Living has an exciting job opening for a Nurse in our Quality Assurance Specialist position!This position is located in Oregon and will require travel.No experience necessary for Quality Assurance Specialist! We provide on-the-job training... 

1Password

Remote Privacy and Data Protection Manager Job at 1Password

 ...to implement and maintain effective data protection practices. This role reports to the Senior Director of Privacy. This is a remote opportunity within Canada and the US. What were looking for ~ Bachelors degree in Business, Legal Studies, or a... 

Daylight Beach Club

PROMOTER - DAYLIGHT BEACH CLUB Job at Daylight Beach Club

 ...include but not limited to Consistently following SOPs outlined by Promotions and venue management. Actively market Self and the venue. Market both Light Nightclub and Daylight Beach Club during seasonal operation. Utilize network to drive guests into the... 

Blue Cross and Blue Shield of Minnesota

Healthcare Coding Analyst Job at Blue Cross and Blue Shield of Minnesota

 ...If you are ready to make a difference, join us. The Impact You Will Have In this role you will be responsible for ensuring healthcare medical coding and reimbursement policies are implemented and integrated in all systems for accurate claims adjudication. This includes... 

VDart Inc

Azure Cloud Engineer with Snowflake Job at VDart Inc

 ...Snowflake and Azure Cloud Engineer Boston, MA FTE Preferred Qualifications: Experience with cloud computing platforms such as AWS, Azure, or GCP Familiarity with data engineering tools and technologies like Spark, Hadoop, and Kafka Experience...