Data Systems Engineer Hybrid MUST be able to drive into office 3 days per week in Houston

Company Overview
Keystone Advisors is a fullservice 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
The Data Systems Engineer is responsible for designing implementing and maintaining data systems that support efficient business operations and datadriven decisionmaking. This role involves working with cloud platforms data warehouses and data pipelines to ensure that systems run smoothly securely and efficiently. The engineer will collaborate with IT data analytics teams and developers to develop and manage largescale data solutions that support organizational needs.

Primary Responsibilities Data Systems Design & Engineering 75

Design build and maintain scalable data systems and architecture to support business needs.
Develop and optimize ETL (Extract Transform Load) processes for data integration and management.
Implement and maintain data pipelines for realtime and batch processing.
Work with cloud platforms such as Azure AWS or Google Cloud to architect data storage solutions ensuring high availability and security.
Develop automated solutions for data ingestion processing and reporting using modern technologies (e.g. Python Spark SQL).
Monitor and ensure the performance security and integrity of data systems and databases.
Collaborate with crossfunctional teams to design and implement datadriven solutions that meet business requirements.Implement and optimize data storage solutions such as data lakes data warehouses or NoSQL databases.
Write clear and maintainable documentation for system architecture data flows and technical procedures.

Secondary Responsibilities IT Support & Maintenance 25

Provide technical support and troubleshooting for data systems and related technologies.
Assist in system upgrades and troubleshooting for performance improvements.
Ensure data systems are compliant with security privacy and regulatory standards.
Provide training to internal teams on best practices for utilizing data systems effectively.
Serve as a backup for critical IT operations and support during peak times or absences.

Required Skills & Qualifications

Data Systems Engineering Skills (Primary):

• Strong knowledge of data architecture databases (SQL and NoSQL) and data modeling techniques.

• Proficiency in cloud platforms (e.g. Azure AWS Google Cloud) for data management.

• Expertise in data pipeline design and implementation using technologies like Python Apache Spark or Kafka.

• Experience with data storage solutions such as data lakes data warehouses and cloud storage.

• Familiarity with data integration tools like Azure Data Factory Talend or ...

• Ability to troubleshoot and optimize data systems and processes for efficiency.

Technical Skills (Secondary):

• Experience in system monitoring database administration and ensuring data security.

• Familiarity with big data technologies and frameworks (e.g. Hadoop Spark etc..

• Basic knowledge of machine learning models or data science workflows is a plus.

• Familiarity with software development practices and programming languages such as Python SQL and Java.

Education & Experience:

Bachelors degree in Computer Science Information Systems Data Science or a related field.
Minimum 3 years of experience in data engineering or a related technical field.
Experience with cloudbased data solutions and largescale data systems is required.

Additional Skills:

Strong problemsolving skills and attention to detail.
Excellent communication skills for both technical and nontechnical audiences.
Ability to work well in a team environment and collaborate effectively with other teams.
Knowledge of data privacy regulations and best practices (e.g. GDPR HIPAA) is a plus.

Working Conditions & Physical Requirements:

Office environment with occasional requirements for system setup and physical movement for IT tasks.

Must be local as there are 3 in office days per week.

Ability to handle occasional hardware setup data system upgrades and related IT tasks.
Primary work involves computer use coding and system architecture design.