#ASSOC282999

Associate Data Engineer

2023-11-28
  • Location FRANKLIN, TN (CHS Corporate)
    Full Time
  • Department Data Intel & Bus Analytic
  • Field Information Technology
  • Location FRANKLIN, TN (CHS Corporate)

  • Department Data Intel & Bus Analytic

  • Field Information Technology

  • Full Time

Job Description

POSITION SUMMARY:
Associate application systems analyst is a data engineer position that provides development and technical support to maintain the Google cloud platform based data warehouse. In addition, this position will collaborate with other cross-functional teams to ensure data availability and accuracy, enabling data-driven development and driving the success of our organization.

JOB RESPONSIBILITIES: 

  • Develop, maintain, and optimize ETL scripts and queries for data extraction, ingestion, transformation, and reporting in Google cloud platform based data warehouse.
  • Design and build extensible data acquisition and integration solutions to meet business reporting and analytics needs from one or more disparate data sources.
  • Review and analyze reporting implementations to identify data anomalies and areas needing enhancement.
  • Monitor and troubleshoot data pipelines and resolve any issues to ensure data availability and reliability.
  • Optimize data storage, retrieval, and processing to improve overall system efficiency.
  • Conduct data profiling and analysis for investigation and resolution of data issues.
  • Proactively communicate and collaborate with internal customers to analyze information needs and functional requirements in a fast-paced environment.
  • Self-starter and ability to work effectively with minimum supervision.
  • Performing all other duties and responsibilities as assigned.

JOB QUALIFICATIONS: 

  • 4-year college degree in Computer Science, or related technical engineering field.
  • 1+ years of experience using SQL queries as well as writing and optimizing SQL queries in a business environment with large-scale, complex datasets.
  • 1+ years of experience with cloud-based databases (such as Big Query)
  • 1+ years of experience in building scalable applications in programming languages, (e.g. SQL, Python, Java, Scala)
  • 1+ years of experience working with distributed systems and big data processing frameworks
  • 1+ years of experience with developing program specifications, pseudo code, or logic diagrams to identify system changes.
  • 1+ years of experience working with structured and unstructured data sources like flat files, XML files and databases

PREFERRED QUALIFICATIONS: (what will give you a competitive edge) 

  • Experience writing stored procedures (SQL preferred).
  • Experience with GCP technologies (e.g., Big Query, Pub/ Sub, Dataflow, Composer DAGs, Cloud SDK, Looker BI).
  • Experience creating ETL and/or ELT jobs (Google cloud services preferred)
  • Proficient in object-oriented programming (Python in particular).
  • Experience with Big Data tools like Spark, PySpark

Physical Demands:
In order to successfully perform this job, with or without a reasonable accommodation, the following are outlined below:

  1. The Employee is required to read, review, prepare and analyze written data and figures, using a PC or similar, and should possess visual acuity.
  2. The Employee may be required to occasionally climb, push, stand, walk, reach, grasp, kneel, stoop, and/or perform repetitive motions.
  3. The Employee is not substantially exposed to adverse environmental conditions and; therefore, job functions are typically performed under conditions such as those found within general office or administrative work.

 

 

 

Apply Now