Patrick Dumont
Senior Solutions Data Analyst @Ovintiv
Signup · Get unlimited contacts
WORK HISTORY
Senior Solutions Data Analyst @Ovintiv
Calgary, AB, CA
Acting as a solutions data analyst for the Business Technology Solutions team which supports initiatives across corporate services, operations, and enterprise data. Providing reliable, timely, and accurate data analysis to the I.T. project delivery team, which included many key projects. • Delivering timely solutions to business problems through the use of Microsoft Fabric via Dataflows, Pipelines, Notebooks, integrating with on prem and cloud datasets via the powerbi service and working with OneLake Datahub, configuring and prepping data with the SQL analytics endpoint and orchestrating all of the dataflows required, as well as documenting data flows efficiently. • Demonstrated strong understanding of PowerBI, PowerBI Report Builder, power query, report visualization, design in PowerBI including user interface, data modeling, data integration, data transformation, the PowerBI service, PowerBI app, calculated columns, summarized tables, and DAX to deliver solutions.• Exhibited understanding of SQL coding and scripting via SQL Navigator and SQL Server Management Studio to find, QC, extract, test, and deliver data to various teams via the enterprise data warehouse, and other key datasets.• Implemented expertise with data modeling and design including working with dimension and fact tables to build and utilize a star schema reporting design.• Acted as a key member of multiple I.T. projects which involved agile project delivery with daily scrums while utilizing DevOps for work tracking and sprint planning.• Developed an awareness of Azure/Microsoft technologies used in supporting ETL pipelines for large datasets as well as continuous integration via DevOps and building enhancements and changes via code branches.• Utilizing prompt engineering via AI assistance to build python-based scripts for data cleansing and transformation tasks to enhance data quality and facilitate effective data visualization.
EDUCATION
The University of Calgary
Bachelor of Commerce (B.Com.)
SKILLS
ABOUT PATRICK DUMONT
My goal is to maximize my information technology and business knowledge and successfully translate this into value for the organizations I work for.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.