Sr Analyst, Data Engineer
Scotts Miracle-Gro2 months ago
Marysville, OH, USASenior
Base Salary
$116k - $136k/yr
Responsibilities
- Perform data extraction, transformation, and loading processes and implement complex transformation logic.
- Develop, maintain, optimize, and troubleshoot data pipelines and data processing workflows.
- Implement data quality checks, validation processes, standards, and anomaly resolution.
- Manage and optimize databases, including schemas, indexes, structures, integrity, and security.
- Support analysts, data scientists, and business intelligence teams with reporting and analytical data solutions.
- Assist with integrating machine learning models into data engineering pipelines and optimize processing for machine learning tasks.
- Identify and implement automation for repetitive data engineering workflows.
- Document processes, workflows, and best practices and provide training and knowledge sharing.
Requirements
- Bachelor's degree in computer science, engineering, mathematics, or a related technical field.
- At least 6 years of experience developing and maintaining data pipelines using ETL/ELT processes.
- At least 6 years of programming experience with Databricks, Python, and Apache Spark.
- Experience with Apache Airflow.
- Experience deploying solutions in AWS Cloud, including Amazon S3, Glue, Athena, EMR, RDS, and Lake Formation.
- Experience with data modeling and writing complex SQL queries.
- Strong communication skills for conveying information and consulting effectively with others.
- AWS Certified Data Engineer certification is desired.
- The posting also lists 4–7 years of experience as preferred.
Benefits
- Base salary range is $115,900–$136,400 per year, with eligibility for corporate bonus programs.
- Medical, dental, vision, wellness reimbursement, and a 401(k) match of up to 7.5% are offered.
- Employees receive a 15% discount on company stock.
- Career growth and professional development opportunities are available.
- Maven Family Planning benefits and up to $30,000 for adoption, fertility, and surrogacy are provided.
- Employee resource groups, community service, and volunteerism opportunities are available.
- For remote roles, state-required pay thresholds may apply based on the candidate's location.
Tech Stack
Categories
Data Engineering
About Scotts Miracle-Gro
The Scotts Miracle-Gro Company sells branded consumer lawn and garden products—fertilizers, grass seed, soils, plant food, and household pest control—through retail and e-commerce channels across North America. Its portfolio includes Scotts, Miracle-Gro, Ortho, and Tomcat. Founded in 1868 and headquartered in Marysville, Ohio, the company is publicly traded on the NYSE.