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
The Data Systems Engineer is responsible for designing, implementing, and maintaining data systems that support efficient business operations and data-driven decision-making. 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 large-scale 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 real-time 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 cross-functional teams to design and implement data-driven 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:
Bachelor’s 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 cloud-based data solutions and large-scale data systems is required.
Additional Skills:
Strong problem-solving skills and attention to detail.
Excellent communication skills for both technical and non-technical 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.