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
- Document, optimized and maintain existing data pipelines
Qualifications:
- 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 performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
- Strong analytic skills related to working with structured and unstructured datasets.
- Build processes supporting data transformation, data structures, metadata, dependency and workload management.
- A successful history of manipulating, processing and extracting value from large disconnected datasets.
