Sr Analyst, Data Engineer

The Scotts Company

Marysville (OH)

On-site

USD 116,000 - 136,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Live Total Health
401K match
Stock purchase discount

Job summary

ScottsMiracle-Gro seeks a Senior Analyst in Data Engineering to strengthen data pipelines, ensure reliable data delivery, and bridge data engineering with data analytics teams. You will drive ETL, data quality, and database optimization to support reporting and ML workflows.

You will collaborate with data scientists and BI teams, automate processes, and maintain documentation. A strong technical foundation and communication skills are essential for success.

Qualifications

  • Bachelor’s degree in a technical field such as Computer Science, Engineering or Math.
  • Required: Databricks, Python, Spark SQL, Airflow.
  • Desired: AWS Certified Data Engineer.

Responsibilities

  • Data Processing and Transformation: perform ETL, design complex transformation logic, ensure accuracy of processing tasks.
  • Data Quality and Validation: implement data quality checks, define standards, troubleshoot issues.

Skills

Databricks
Python
Spark SQL
Airflow

Education

Bachelors Degree in Computer Science/Engineering/Math

Tools

AWS Cloud
S3
Glue
Athena
EMR
RDS

Job description

Here at ScottsMiracle-Gro there is no such thing as a typical day. Our culture is constantly energized by new and exciting growth opportunities and at a rapid pace. Below are details on an open job.

The Senior Analyst in Data Engineering is a technical role that supports data processing and integration efforts. You'll use your advanced analytical skills to improve data pipelines and ensure data delivery is consistent across projects. This role bridges the gap between data engineers and data analysts/scientists to optimize data-driven initiatives.

In this role you will:
  • Data Processing and Transformation
    • Perform data extraction, transformation, and loading (ETL) processes.
    • Design and implement complex data transformation logic to meet business requirements.
    • Ensure the accuracy and reliability of data processing tasks.
  • Data Quality and Validation
    • Implement and execute data quality checks to identify and address anomalies.
    • Collaborate with stakeholders to define and enforce data quality standards.
    • Monitor and troubleshoot data quality issues to maintain high standards.
  • Database Management
    • Manage and optimize databases to support efficient data storage and retrieval.
    • Implement database schemas, indexes, and structures for optimal performance.
    • Collaborate with database administrators to ensure database integrity and security.
  • Reporting and Analytics Support
    • Support data analysts and data scientists in creating reports and analytics solutions.
    • Collaborate with business intelligence teams to integrate data for reporting purposes.
    • Ensure data availability and accuracy for analytical purposes.
  • Collaboration with Data Scientists
    • Work closely with data scientists to understand their data requirements and provide support.
    • Assist in the integration of machine learning models into data engineering pipelines.
    • Optimize data processing for machine learning tasks.
  • Process Automation
    • Identify opportunities for process automation within data engineering workflows.
    • Implement automation scripts and tools to streamline repetitive tasks.
    • Enhance operational efficiency through the use of automation.
  • Documentation and Knowledge Sharing
    • Document data engineering processes, workflows, and best practices.
    • Share knowledge and provide training to team members and other stakeholders.
    • Maintain up-to-date documentation for reference and training purposes.
What you'll need to be successful:
  • Bachelors Degree in Computer Science in Engineering, mathematics, or related technical field
  • Required : Databricks, python, Spark SQL, Airflow
  • Desired : AWS Certified Data Engineer
  • -4-7 years of experience preferred
  • -6+ years of experience in Data Engineering
  • Strong communication skills to timely and effectively convey information and consult with others
Skills:
  • -6+ years of developing and maintaining data pipelines (ETL/ELT)
  • -6+ years of programming experience in Databricks, Python, and Apache Spark
  • -Experience with Apache Airflow
  • -Experience in deploying solution in AWS Cloud with emphasis on Amazon S3, Glue, Athena, EMR, RDS, and lake formation
  • - Experience in data modelling and writing complex SQL queries

The starting budgeted pay range for this role will generally fall between $115,900.00 - $136,400.00 per year. Scotts will consider various factors in determining the actual pay including your skills, qualifications, and exceptional experience. In addition to the determined base salary, this role is also incentive eligible under our corporate bonus programs. For remote roles where the final candidate resides in Alaska, California, Colorado, Illinois, NewYork, Oregon or Washington state required pay thresholds will be factored into base salary.

Here at ScottsMiracle-Gro, we believe providing an enriching and engaging employee experience is what sets us apart from other organizations. We recognize our employees are so much more than just their job title so we offer programs and benefits that support them in all aspects of their lives. Wondering how we do it? Below is a glimpse of our highlight reel... Our Live Total Health program provides you with options to align to your personal needs. Selections range from medical, dental and vision coverage for you, your spouse/domestic partner and dependents to an outstanding wellness reimbursement program to an unbelievable 401K match (up to 7.5%) as well as a 15% discount on company stock and much more

We know our talent is our most precious asset and your unique development contributes to our organization's success now and in the future. Career growth at our company is not always a ladder. It's much more like a rock climbing adventure. Grow through exploration and experiences rather than a predictable linear path.

We value the importance of family. We provide access to Maven Family Planning and up to $30,000 to accommodate for adoption, fertility and su

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Sr Analyst, Data Engineer
Sr Analyst, Data Engineer

Scotts Miracle-Gro Co. • Marysville (OH)

On-site
USD 116,000 - 136,000
Health coverage
401K match
Stock discount
+2
Data Steward
Data Steward

The Scotts Company • United States

Remote
USD 88,000 - 103,000
401K match
Live Total Health program
Wellness reimbursement
Sr Analyst, HR Shared Services
Sr Analyst, HR Shared Services

The Scotts Company • Marysville (OH)

Hybrid
USD 80,000 - 94,000
Live Total Health program
401K match (up to 7.5%)
Stock discount (15%)
+1
Data Steward
Data Steward

Hawthorne Gardening Co. • Marysville (WA)

On-site
USD 88,000 - 103,000
Health benefits
401K match
Stock discount
+1
Senior Analyst, Cloud Computing Engineering
Senior Analyst, Cloud Computing Engineering

Hawthorne Gardening Co. • Marysville (WA)

On-site
USD 116,000 - 136,000
Live Total Health program
401K match
Adoption assistance up to $30,000
Sr. Manager Data Science
Sr. Manager Data Science

Hawthorne Gardening Co. • United States

Remote
USD 176,000 - 207,000
Live Total Health program
401K with company match
Stock purchase discount
+2
Sr. Manager Data Science
Sr. Manager Data Science

Scotts Miracle-Gro Co. • Marysville (OH)

On-site
USD 175,700 - 206,700
Live Total Health
401K match
Stock discount
+2
Data Steward
Data Steward

Scotts Miracle-Gro Co. • Marysville (OH)

On-site
USD 91,000 - 107,000
Health coverage
Wellness reimbursement
401K match
+3
Sr Analyst, HR Shared Services
Sr Analyst, HR Shared Services

Hawthorne Gardening Co. • United States

Hybrid
USD 80,000 - 94,000
Health benefits
401K match
Stock purchase discount
+2
Senior Analyst, Cloud Computing Engineering
Senior Analyst, Cloud Computing Engineering

Scotts Miracle-Gro Co. • Marysville (OH)

On-site
USD 116,000 - 136,000
Health benefits
401K match
Stock discount
+2