Reports Developer(ETL/SQL/AWS)

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.