Junior-Middle Data Analytics Engineer IRC292597

Description About the client: Our Client is the fast-paced digital healthcare company which creates the growing portfolio of online health communities for people with chronic conditions. Company’s mission is to improve patient’s quality of life by connecting them with each other, with caregivers and healthcare industry partners, building beneficial social interactions and meaningful health conversations. About the project: The core of the project is working with the data; the target is to re-design and enhance data-driven solutions. The team is responsible for expanding and optimizing the data flow and data pipeline architecture, model and analyze data, interpret trends or patterns in complex data sets and translate them into product and marketing insights. If you are excited by the prospect of optimizing or even re-deg our data architecture to support our next generation of products and data initiatives, we would be thrilled to have you apply!

Requirements: ● Good Python skills ● Good working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases ● A successful history of manipulating, processing and extracting value from large disconnected datasets ● Experience building and optimizing data pipelines, architectures and data sets

Technologies: Python AWS: SES, RDS (MySQL), EC2, Elasticsearch Service, Route 53, VPC, etc Snowflake Docker dbt Airflow

Job Responsibilities: ● Manage and optimize core data infrastructure ● Build monitoring infrastructure to give visibility into the pipeline’s status ● Monitor all jobs for impact on cluster performance ● Run maintenance routines regularly ● Tune table schemas to minimize costs and maximize performance ● Build and maintaining custom ingestion pipelines ● Build non-SQL transformation pipelines ● Build processes supporting data transformation, data structures, metadata, dependency and workload management