Systems Specialist - KellyMitchell Group : Job Details

Job Summary: Our client is seeking a Systems Specialist to join their team! This position is remote. Duties:

• Build and maintain complex data pipelines that integrate data from a wide variety of sources, including APIs, AWS, Data Cloud, and databases
• Design and develop optimized data models and scalable data structures in company Data Cloud and Snowflake to support reliable analytics, reporting, and downstream data products
• Perform comprehensive data profiling to identify data gaps and continuously improve data quality across ingestion and transformation layers
• Implement robust data transformation logic to convert raw data into golden records and trustworthy analytical datasets
• Build automated data quality checks and validation rules within pipelines to ensure accuracy, completeness, and consistency of critical datasets
• Partner with product analysts, product engineering, and other stakeholders to understand instrumentation needs for insights and analytics
• Collaborate with data architects to define and maintain data governance, naming standards, and data lineage documentation

Desired Skills/Experience:

• Bachelor's degree in Computer Science, Engineering or a related field
• 4+ years of experience in data engineering or ELT/ETL development using SQL, Shell Scripting, Python, and Java
• Strong proficiency in Apache Spark, Python, and advanced SQL for large-scale data transformation and analytics
• Hands-on experience with Apache Airflow or equivalent orchestration tools for managing data workflows
• Experience with dbt for building and managing modular, version-controlled, and tested data transformations
• Proven ability to build, deploy, and optimize data pipelines on AWS infrastructure
• Experience with data Lakehouse architectures and familiarity with modern data mesh principles
• Strong analytical skills with the ability to work with complex data models, derive insights, and recommend actionable strategies
• Proficient in Tableau for developing interactive dashboards and visual storytelling
• Exposure to data governance, metadata management, and data cataloging tools
• Ability to work effectively in an agile, distributed, and fast-paced environment, and have a high degree of self-management with clear communication and commitment to delivery timelines

Benefits:

• Medical, Dental, & Vision Insurance Plans
• Employee-Owned Profit Sharing (ESOP)
• 401K offered

The approximate pay range for this position is between $47.00 and $68.00. Please note that the pay range provided is a good faith estimate. Final compensation may vary based on factors including but not limited to background, knowledge, skills, and location. We comply with local wage minimums.