The company is looking for a Data Engineer to expand and optimize their data pipeline architecture, supporting software developers, data analysts, and data scientists on various data initiatives. The role involves leading the creation of data architecture for the enterprise data lake and enabling the data platform.
Requirements
- Hands-on building data applications using AWS Glue, Lake Formation, AWS Batch, AWS Lambda, Python, Linux shell & Batch scripting.
- Hands on experience with AWS Database services (Redshift, RDS, DynamoDB, Aurora etc.)
- Experience in writing advanced SQL scripts involving self joins, windows function, correlated subqueries, CTE’s etc.
- An understanding of data management fundamentals, including concepts such as data dictionaries, data models, validation, and reporting.
- Extensive understanding of SQL queries. Ability to fine tune queries based on various RDBMS performance parameters such as indexes, partitioning, Explain plans and cost optimizers.
- Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and AWS technologies stack
- Participate in the design and development of the AWS-based data platform and data analytics.
Responsibilities
- Design and implement data ETL frameworks for secured Data Lake, creating and maintaining an optimal pipeline architecture.
- Examine complex data to optimize the efficiency and quality of the data being collected, resolve data quality problems, and collaborate with database developers to improve systems and database designs
- Hands-on building data applications using AWS Glue, Lake Formation, AWS Batch, AWS Lambda, Python, Linux shell & Batch scripting.
- Hands on experience with AWS Database services (Redshift, RDS, DynamoDB, Aurora etc.)
- Experience in writing advanced SQL scripts involving self joins, windows function, correlated subqueries, CTE’s etc.
- Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and AWS technologies stack
- Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics.
Other
- The hire will be responsible for expanding and optimizing our data pipeline architecture.
- The Data Engineer will support our software developers, data analysts and data scientists on various data initiatives.
- This is a highly visible role within the enterprise data lake team.
- Working within our Data group and business analysts, you will be responsible for leading creation of data architecture that produces our data assets to enable our data platform.
- This role requires working closely with business leaders, architects, engineers, data scientists and wide range of stakeholders throughout the organization to build and execute our strategic data architecture vision.
