Rachel Walker
- Phone: +353 87 123 4567
- Email: rachel.walker@email.com
- Location: Dublin, Ireland
- LinkedIn: rachelwalker-datawarehouse
Summary
Architecting and optimizing robust data warehousing solutions for over 8 years, resulting in a 25% improvement in data retrieval times for enterprise-level analytics platforms. Specializing in end-to-end ETL processes, dimensional modeling, and leveraging cloud-based data warehouses to support critical business intelligence initiatives.
Proven ability to translate complex business requirements into scalable data models and implement efficient data pipelines, consistently delivering high-quality, actionable data for strategic decision-making.
Experience
Senior Data Warehousing Specialist, Fintan Solutions -- Dublin, Ireland
Mar 2019 – present
-
Led the design and implementation of a new enterprise data warehouse using Snowflake, reducing data processing time by 30% and storage costs by 15% for financial analytics.
-
Developed and maintained complex ETL pipelines using Azure Data Factory and SSIS, handling over 5TB of daily transactional data from diverse source systems.
-
Optimized existing data models and queries, resulting in a 20% increase in report generation speed for key business stakeholders.
-
Mentored junior data engineers on best practices in dimensional modeling, data governance, and performance tuning for data warehousing solutions.
Data Warehousing Engineer, Emerald Analytics -- Dublin, Ireland
July 2016 – Feb 2019
-
Designed and implemented star and snowflake schemas for new data marts, supporting departmental reporting requirements across sales and marketing.
-
Developed and automated data loading processes using Python scripts and SQL Server Integration Services (SSIS), improving data availability by 99%.
-
Performed data quality checks and resolved discrepancies, ensuring accuracy and reliability of data within the data warehouse.
-
Collaborated with BI developers to understand data needs and provide optimized data structures for dashboard creation in Tableau and Power BI.
Education
University College Dublin, MSc in MSc in Data Science -- Dublin, Ireland
Sept 2015 – Sept 2016
Trinity College Dublin, BSc in BSc in Computer Science -- Dublin, Ireland
Sept 2012 – June 2015
Skills
Data Warehousing & ETL: Snowflake, Azure Synapse Analytics, AWS Redshift, Google BigQuery, SQL Server, Oracle, Data Marts, Dimensional Modeling, Star Schema, Snowflake Schema, Data Vault 2.0
ETL Tools & Orchestration: Azure Data Factory, SSIS, Talend, Informatica PowerCenter, Apache Airflow, DBT
Programming & Scripting: SQL, Python, T-SQL, PL/SQL
Cloud Platforms: Microsoft Azure, Amazon Web Services (AWS), Google Cloud Platform (GCP)
Database Technologies: SQL Server, PostgreSQL, MySQL, NoSQL (MongoDB, Cassandra)
Business Intelligence & Reporting: Tableau, Power BI, Qlik Sense, SSRS
Methodologies & Concepts: Agile, Scrum, Data Governance, Data Quality, Performance Tuning, Data Security