Ankercloud

Job Description: As a Senior Data Engineer you will play a crucial role in the development, maintenance, and optimization of our data infrastructure. You will work closely with cross-functional teams, including data scientists, analysts, and software engineers, to ensure that our data pipelines and systems are reliable, scalable, and efficient. Key Responsibilities: ● Create and maintain optimal Datalake and Data Warehouse setup. ● Assemble large and complex datasets that meet functional / non-functional business requirements. ● Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc. ● Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL. ● Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases. ● Experience building and optimizing ‘big data’ data pipelines, architectures and data sets. ● Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement. ● Build processes supporting data transformation, data structures, metadata, dependency and workload management. ● Working knowledge of message queuing, stream processing,and highly scalable ‘big data’ data stores. ● Strong project management and organizational skills. ● Experience supporting and working with cross-functional teams in a dynamic environment. ● Create and maintain clear and comprehensive documentation for data engineering processes and solutions. Technical Expertise ● Experience with Data Analytics services like EMR, Glue, Athena, Kinesis, MSK, Elasticsearch, Quicksight and Redshift. ● Experience with big data tools: Hadoop, Spark, Kafka, Hive etc. ● Experience with relational SQL and NoSQL databases, including Postgres and Cassandra. ● Experience with data pipeline and workflow management tools: Azkaban, Luigi, Airflow, etc. ● Experience with stream-processing systems: Storm, Spark-Streaming, etc. ● Experience with object-oriented/object function scripting languages: Python, Scala, etc ● Experience with Data warehouse concept and setup with different data modeling techniques.