Junior Data Analyst Job at Keystone Advisors, Houston, TX

TmZVbm1JYy9peWZJUGF5WEU2a3VHWEhoc0E9PQ==
  • 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

Stellent IT LLC

QuickBase Administrator / Developer- Remote Job at Stellent IT LLC

 ...Job Title QuickBase Administrator / Developer Location Remote Duration 6 Weeks Job Description: The project...  ...workflows within QuickBase, tables and schemas. 100% remote, working in EST hours. Describe your experience with Quickbase... 

Centria Autism

Entry Level Autism Caregiver Job at Centria Autism

An Autism Caregiver job is available through Centria Healthcare. This job will help the development of children who are on the Autism Spectrum by providing ABA (Applied Behavior Analysis) Therapy. This therapy is used to increase language and communication skills.\\... 

Frito-Lay

Warehouse/Material Handler Job at Frito-Lay

No experience requited, hiring immediately, appy now.Work Schedule: 4-5 days per week25 hours per week average Frito-Lay Warehouse/Material Handlers are responsible for a variety of warehouse duties. A key component of PepsiCo's success, Frito-Lay has been making the very... 

Domino's Franchise

Delivery Driver - 8404 Preston Highway Job at Domino's Franchise

 ...staff stores in your area. We're growing so fast it's hard to keep up, and that means Domino's has lots of ways for you to grow (if...  ...ADVANCEMENT Many of our team members began their careers as delivery drivers and today are successful Domino's franchise owners. From... 

Culpeper Baptist Child Development Center

Substitute Teacher Job at Culpeper Baptist Child Development Center

 ...Summary Job description We are in need of substitutes willing to work in all three of our programs: Infant/toddler, preschool...  ...outs. Implement substitute plans that are left by the lead teacher. Assist teachers with the implementation of our HighScope curriculum...