Dakota Kimble
Lebanon,TN
Summary
Data Engineer with experience leading the design and implementation of scalable data platforms and pipelines across Azure and Microsoft Fabric. Strong background in SQL performance optimization, dimensional modeling, and integrating enterprise systems like Dynamics 365 into centralized data architectures. Proven track record of improving data performance, rebuilding failing data solutions, and enabling executive-level analytics.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Manager of Data & AI
CAF2CODE LLC
07.2025 - Current
- Led design and implementation of enterprise data architectures integrating Dynamics 365 (OData), Azure SQL, and Snowflake-based data warehouse environments
- Owned end-to-end data pipeline development (Azure Data Factory, SQL), from ingestion through transformation to analytics-ready datasets
- Designed and implemented dimensional data models (fact/dimension) using Snowflake as the central data warehouse to support scalable analytics and reporting
- Directed migration of on-prem SQL Server data warehouse to Microsoft Fabric (Lakehouse/Warehouse), improving scalability and centralized data access
- Established standardized “golden datasets” to ensure consistent and reliable reporting across finance and operational teams
- Optimized complex SQL workloads (joins, indexing, model design), reducing execution times by 90%+ across 30+ processes
- Designed and built a custom Node.js-based data service layer to orchestrate queries across Dynamics 365 and SQL, enabling controlled and efficient data access
- Implemented enterprise data security models (RLS, role alignment with Dynamics 365) across Power BI and data layers
- Partnered with executive stakeholders to define data strategy and deliver scalable data solutions
Technical Analyst
CAF2CODE LLC
10.2023 - 07.2025
- Architected and optimized ETL/ELT pipelines (Azure Data Factory, SQL) across multiple client environments
- Redesigned failing data pipelines by restructuring transformations and improving data model design, restoring reliability and performance
- Built dimensional data models (star schema) to support finance and operational analytics
- Automated data workflows and reporting pipelines, reducing manual effort and improving data delivery timelines
- Contributed to ~$750K in delivered data solutions through pipeline and reporting architecture improvements
Intern → Junior IT Analyst
CAF2CODE LLC
09.2021 - 10.2023
- Supported development of data pipelines and warehouse structures
- Built foundational datasets and models for reporting
- Assisted in SQL optimization and debugging
Education
Bachelor’s Degree - Business Information Systems
Liberty University
01-2024
Skills
- Data Engineering & Architecture: ETL/ELT, Data Warehousing, Dimensional Modeling, Data Integration
- Technologies: SQL, Azure Data Factory, Microsoft Fabric, Power BI, Snowflake
- Other: Data Governance, Security, Performance Optimization
Certification
- PL-300 (Power BI)
- Microsoft Excel & Access
- CompTIA A+
Timeline
Manager of Data & AI
CAF2CODE LLC
07.2025 - Current
Technical Analyst
CAF2CODE LLC
10.2023 - 07.2025
Intern → Junior IT Analyst
CAF2CODE LLC
09.2021 - 10.2023
Bachelor’s Degree - Business Information Systems
Liberty University