Sr Data Engineer

Primary Responsibility: 

Data is at the foundation of Americold’s success. The Data Engineering team at Americold builds database solutions for various use cases including reporting, product analytics, operations and financial reporting. By implementing and modeling data structures, and data warehouse architecture; this team serves as the foundation for decision-making at Americold. Working primarily with solving the data engineering/analytics/applications related business problems, transforms business needs into solutions, develops solutions/prototypes, performs testing, and takes the solutions from stages of development like proof-of-concept prototypes to functional software. Maintain and give inputs to the current technical environment. Provides on-call support, as required.

Essential Functions:

•    Design, Develop and implement large scale, high-volume and high-performance Data Engineering and Analytics solutions for Data Lake and operational Data Warehouse like data dictionary, data pipelines, data models, reporting systems, data automation systems, ad-hoc reporting processes, dashboards and performance metrics that support key business decisions. 
•    Scale our data infrastructure, data pipelines and tools to meet growing business needs.
•    Build and implement cloud based ETL frameworks to improve code quality and reliability, enforce common design patterns to increase code maintainability.
•    Validate detailed specifications and development in the data/analytics and refactor legacy code into cloud native code.
•    Provide data analytics and visualization using PowerBI.
•    Evaluate and enhance data quality and reliability.
•    Collaborate with stakeholders within – Business Operations, Sales / Business Development, Finance and Customers. 
•    Leads/Collaborates in all phases of SDLC: 
•    DESIGN: Designs software/business-analytics solutions using the Agile/Scrum Process. Prepares and validates time estimates. 
•    DEVELOPMENT:  Develops proof-of-concept, software capabilities using the Data and Analytics best practices. Follows appropriate internal processes, as well as established industry standards for software coding, documentation, and code management.
•    TESTING:  Creates/Reviews test plans and ensures quality of the data/metrics/KPIs.
•    ROLLOUT:  Follows appropriate change management and implementation procedures.       Ensures that appropriate technical and functional documentation is prepared. 
•    SUPPORT:  Creates/Participates in the on-call rotation to ensure business analytics are supported in the data and analytics platform.
What Experience and Education You Need
•    Bachelor of Science degree in Computer Science or equivalent; or equivalent combination of education.
•    3-5 years of hands-on technical experience designing, developing, and implementing data pipelines and analytic solutions for Data Warehouse/Data Lake.
•    Technical experience in AWS Cloud Based Technologies (AWS – Data Migration Service, Postgres, Glue, S3, Lambda, Step Functions, Document DB, RedShift)
•    AWS Solution Architecture Certification and/or AWS Data Engineer Certification are a plus.
•    Experience working with stakeholders and putting together solution-architecture for Data/Analytics products.
•    Experience with data visualization tools: Power BI, SSRS, Tableau, etc.
•    Strong SQL skills, ability to perform effective querying involving multiple tables and subqueries.
•    Experience of data mining principles: predictive analytics, machine learning, mapping, collecting data from multiple data systems on premises and cloud-based data sources
•    Experience in programming languages extensively used in Data Science applications (e.g., R, Python, Scala, Java, etc.)
•    Experience working with Cloud Based Technologies (AWS – Data Migration Service, Glue, S3, Lambda, Step Functions, Document DB, RedShift)
•    Experience leveraging and improving the Agile Scrum Process.
•    Experience understanding/eliminating functional and technical blockers for the team.
•    Level of Experience: Performs work with little to no supervision – Leads & provides guidance to experienced analysts/developers. Acts as project leader on large, complex projects. Maintains a senior-level workload. Fully capable of working at the highest technical level. Has 5+ years of relevant experience.

What Could Set You Apart:

•    Experience leveraging Agile Scrum Process.
•    Experience working with stakeholders and putting together solution-architecture for Data/Analytics products.