Design, develop, and maintain advanced reporting and datasets leveraging AI tools to accelerate data analysis, insight generation and reporting efficiency
Design, develop, and maintain scalable ETL pipelines using AWS glue to ingest, transform, and curate data from multiple source systems into analytics-ready datasets.
Partner with business stakeholders to translate key information needs into scalable analytics solutions and data products.
Own data quality by implementing validation, monitoring, and governance processes to ensure accuracy and consistency.
Enable self-service analytics by designing intuitive dashboards, datasets, and documentation that empower business users to explore data independently.
Continuously improve existing reporting by reducing redundancy and manual effort.
Partner with data services and enterprise analytics teams to ensure data pipelines meet analytical and business requirements.
Document data sources, transformations, and business logic to support transparency and scalability
Communicate insights clearly to both technical and non-technical audiences through presentations and written narratives
Requirements
Bachelor’s degree in business administration, information systems, or related field.
Minimum 5 years of experience in reporting and data analysis roles.
Strong proficiency with SQL and relational data models; experience querying cloud data warehouses such as Amazon Redshift preferred.
Experience developing and maintaining data pipelines and ETL processes within AWS environments.
Working knowledge of Python for data analysis, automation, or pipeline development
Experience working with APIs to extract, integrate, or validate data from internal or external systems
Experience designing, building, and maintaining dashboards and self-service analytics using BI tools, with Amazon QuickSight preferred.
Tech Stack
Amazon Redshift
AWS
Cloud
ETL
Python
SQL
Benefits
Medical/Dental/Vision available day one
Vacation/Sick
accruals start day one
Paid company holidays and personal holidays to celebrate what’s important to you
401K
company contribution and match (U.S.)
Registered Retirement Savings Plan (RRSP) – company contribution and match (Canada)