Data Analyst at Government of Manitoba, Manitoba Health

Engineered robust data linkage solutions using Python to match patient records across disparate systems while ensuring full data scrambling and de-identification. Authored and maintained complex T-SQL stored procedures and utilized SAS for data analysis and data scrambling. Built automated data validation, backup, and archival processes using PowerShell, Bash, and Python, enabling continuous data quality improvement. Responded to ad-hoc data requests by collaborating with stakeholders to define requirements. Designed test strategies and validated reporting-platform functions; developed Python/R scripts and Excel macros to automate ETL tasks for large datasets. Created enterprise dashboards with Tableau and Power BI; ensured Manitoba Health privacy and confidentiality. Led development of statistical modelling and predictive analytics, and produced dashboards for decision-makers. Managed multiple concurrent projects with strict deadlines and quality standards.

Data Engineer at Four Eyes Financial, Saint John, Canada

Designed and implemented data ingestion pipelines using AWS services (Lambda, CloudWatch, Step Functions, Glue, Redshift, S3, EC2, ECS, Textract). Applied predictive modeling for risk-rating platform using big data. Employed a hybrid infrastructure (serverless and container-based components) to implement ETL processes and batch processing. Conducted data transformation through field mappings, rule sets, and data integrity verification. Leveraged structured and unstructured big data to derive actionable insights and support data-driven decisions. Built robust data pipelines to extract, transform, and load data into centralized data stores; led data development, testing, automation, deployment, and front-end involvement to ensure efficient and accurate data experiences. Monitored analytics trends to improve client portfolio performance and valuation methodologies.