Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

James Dehler

Lino Lakes,Minnesota

Summary

Data Engineer with deep knowledge and broad breadth of experience in data-driven technologies and solutions. Driver of systems and solutions that provide high-quality and high-value results for mission critical business objectives and vision. Continuous learning with a passion for evolving data-centric capabilities and technologies.

Overview

29
29
years of professional experience
1
1
Certification

Work History

Sr. Cloud Data Engineer

Patterson Companies Inc.
07.2024 - Current
  • Part of a small team the implemented a Microsoft Fabric Medallion Architecture platform.
  • Created data pipelines in both ADF and Fabric.
  • Designed and implemented full and incremental loads of data from disperse sources.
  • Developed and implemented a data quality and data governance strategy in our cloud environment. Utilized Purview, Fabric and Azure capabilities and best practices
  • Designed dimensional data models for complex analysis needs. Implemented in a gold layer Medallion Data Warehouse.
  • Created a CICD process that unitizes Azure/Fabric Capabilities and a Git Repository in Azure DevOps.
  • Worked closely with report analysts, AI professionals and business team members to ensure all requirements were identified and manage to ensure highest quality outcomes.
  • Presented to stakeholders and led high profile initiatives including the implementation of our Fabric Platform from the ground up.

SR. DATA ENGINEER BIG DATA/CLOUD

Optum Insight
06.2018 - 07.2024
  • Data Warehouse development including Snowflake Data Lake technologies
  • Created on Premise and Cloud Native Managed Data Pipelines with MS SSIS, Azure Data Factory and GCP with Airflow and BigQuery
  • Wrote complex queries in SQL and Hive queries to perform data quality and ad-hoc reporting activities.
  • Developed in SCRUM, Kanban and traditional project management processes.
  • Presented findings to stakeholders and leadership.
  • Developed complex ETL Jobs with structured and unstructured data sources utilizing on-premise tools as well as cloud based technologies including Databricks and platform specific capabilities.
  • Performed exploratory data analysis on a diverse set of data to define requirements for data models to support Machine Learning Initiatives, Reporting in both DOMO and PowerBI.
  • Utilized tools such as SPARK, Python (Pandas, NumPy, SciKit-Learn and others to develop Python applications for Data Analysis including machine learning models.
  • Created diagrams and documentation in support of all activities and projects.

SR DATA ENGINEER

University of St. Thomas - Organizational Effectiveness
08.2017 - 06.2018
  • Developed and engineered data and reporting solutions in commercial platforms including SalesForce, IBM SPSS, and IBM Cognos.
  • Developed ETL scheduled jobs for both full and incremental updates.
  • Developed batch and real-time triggered ETL jobs to support data and reporting requirements.
  • Created dimensional data models for analytical reporting including star schema models for data warehousing.
  • Developed Type II data management techniques to support slow changing dimensions and historical data for analytics and reporting.
  • Worked closely with all business units to identify and define both functional and non-functional requirements for data and reporting needs.

LEAD DATA ENGINEER

Target - Enterprise Data Management
06.2014 - 08.2017
  • Designed and implemented a data warehouse architecture for a large mission critical initiative.
  • Migrated legacy on-premise systems onto both AWS and AZURE big data modeled cloud platforms.
  • Provided technical guidance and mentorship to other Data Engineers on best practices for developing ETL pipelines on cloud based big data platforms.
  • Developed and deployed data pipelines to ingest, process, store, and visualize large datasets with Apache Spark and Hadoop clusters.
  • Wrote complex HIVE queries, utilized Spark and Kafka to created efficient and robust Extract, Load and Transform (ELT) models.
  • Led cross-functional teams in gathering requirements, designing solutions, testing plans and implementation strategies.

SR. DATA ARCHITECT AND ENGINEER

Target
10.2005 - 06.2014
  • Collaborated with stakeholders to define business objectives and translated them into technical specifications for implementation for data-centric projects and processes for both Stores and Marketing Pyramids.
  • Designed efficient ETL workflows to extract, transform and load high volumes of data into target systems.
  • Member of the Target Architectural Review Board providing technical leadership across the I.T. organization to ensure high-value and hi-quality systems.
  • Performed data profiling to identify trends in large datasets including internal and external data sources to model and implement SQL databases for various development teams and projects.
  • Refactored and optimized existing databases to support business intelligence solutions.

SR. TECHNICAL ARCHITECT

Target Corporation
06.2001 - 10.2005
  • Architect and platform administrator of Stores servers and applications with over 1600 remote locations requiring orchestrated distributed computing capabilities.
  • Collaborated with stakeholders to define requirements and ensure successful delivery of projects.
  • Analyzed existing application components and identified areas for improvement or optimization.
  • Managed third party vendors providing services related to application architecture design and development.
  • Created strategies for deploying enterprise applications across multiple platforms and environments.
  • Developed detailed system architectures and designs for mission-critical applications including Point of Sales.
  • Developed automated testing frameworks for validating application functionality and usability.
  • Identified and designed solutions for scalability, reliability, availability, security, performance, and maintenance.

SR. SYSTEMS ENGINEER

SuperValu - Cub Foods
01.1997 - 06.2001
  • Configured network devices including routers, switches, firewalls.
  • Designed and implemented high availability solutions to ensure maximum uptime of mission-critical services including leading a company wide replacement of Point-Of-Sale checkout systems with better performance and increased capabilities.
  • Collaborated with IT staff to troubleshoot complex hardware and software problems.
  • Performed system and server upgrades, patching, and maintenance as needed.
  • Conducted root cause analysis of production incidents and developed corrective action plans accordingly.

Education

Bachelor of Science (B.S.) -

Metropolitan State University
St. Paul, MN
05.2018

Associate in Science (A.S.) - Computer Science and Technologies

Northwestern Electronics Institute
Columbia Heights, MN
06.2005

Skills

  • Data Pipelines - Azure and Fabric Data Factory, Data Flow, WCF
  • CICD - Azure DevOps, Git, Jenkins
  • Cloud Computing - Azure, Fabric, Google
  • Programming - Python, Scala Programming
  • Dimensional and relational Data Modeling
  • Data Quality Assurance, Purview, HIPPA, classification, labeling
  • Agile / Scrum - Practitioner occasional Scum Master
  • Data Warehousing
  • SQL Programming, Queries, Views, Stored Procedures, T-SQL
  • Hadoop Ecosystem, HIVE, HDFS, KAFKA, Spark
  • API development GraphQL, Swagger
  • Data Science, ML, LLM, GenAI
  • Databases - MSSql, Postgres, MariaDB, HDFS, Google BigQuery, Azure SQL
  • Medallion Architecture
  • Data Lake
  • Data warehousing
  • Data curating
  • Virtualization - Docker, Kubernetes
  • Data analysis

Certification

  • Certified Software Quality Engineer – American Society of Quality
  • Applied Data Scientist – Massachusetts Institute of Technology
  • Lean Six Sigma Black Belt I.T. – Villanova University

Timeline

Sr. Cloud Data Engineer

Patterson Companies Inc.
07.2024 - Current

SR. DATA ENGINEER BIG DATA/CLOUD

Optum Insight
06.2018 - 07.2024

SR DATA ENGINEER

University of St. Thomas - Organizational Effectiveness
08.2017 - 06.2018

LEAD DATA ENGINEER

Target - Enterprise Data Management
06.2014 - 08.2017

SR. DATA ARCHITECT AND ENGINEER

Target
10.2005 - 06.2014

SR. TECHNICAL ARCHITECT

Target Corporation
06.2001 - 10.2005

SR. SYSTEMS ENGINEER

SuperValu - Cub Foods
01.1997 - 06.2001

Associate in Science (A.S.) - Computer Science and Technologies

Northwestern Electronics Institute

Bachelor of Science (B.S.) -

Metropolitan State University

Similar Profiles

  • Mariana Otero

    Mariana OteroMariana Otero

    Supply Chain Planner II at Patterson Companies Inc.Supply Chain Planner II at Patterson Companies Inc.

  • Maria Rogers

    Maria RogersMaria Rogers

    Western Regional Territory Sales Rep at Patterson Companies Inc.Western Regional Territory Sales Rep at Patterson Companies Inc.

  • Ashanti Boyd

    Ashanti BoydAshanti Boyd

    Veterinarian Technician at Patterson Companies Inc.Veterinarian Technician at Patterson Companies Inc.

  • Sarah McNamara

    Sarah McNamaraSarah McNamara

    Instructional Paraprofessional at ISD 12 Centennial School DistrictInstructional Paraprofessional at ISD 12 Centennial School District

  • Chloe Bastyr

    Chloe BastyrChloe Bastyr

    Infant Teacher at Primrose SchoolsInfant Teacher at Primrose Schools

CREATE PROFILE
James Dehler