Job Summary:
Designing, developing, and modifying data infrastructure to accelerate the processes of data analysis and reporting
Responsibilities:
- Analysis and profiling in preparation for data ingestion to data lake
- Develop, maintain and monitor ETL/ELT jobs
- Analysis and preparation of data models for the data warehouse
- Develop, maintain and monitor SQL queries
- Analysis and preparation of descriptive, prescriptive or predictive analytics
Qualifications:
- We are looking for a candidate with at least 3 to 5 years of experience in a Data Engineer/Operations role, who has attained a Graduate degree in Computer Science, Statistics, Informatics, Information Systems or another quantitative field.
- 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 data pipelines, architectures and data sets.
- Experience with AWS cloud services: EC2, EMR, RDS, Redshift
- Experience with object-oriented/object function scripting languages: Python, Java, C++, Scala, etc.
- Experience with ETL/ELT tools: AWS Glue, Informatica, Talend, etc.
