Summary
Overview
Work History
Education
Skills
Clearance Level
Timeline
Generic

Daniel Dzacka

Columbia

Summary

Experienced data analyst with over 7 years of expertise in Data Analytics, Engineering and Business Intelligence. Adept at delivering impactful insights in the auto insurance, healthcare, and retail domains through a combination of technical proficiency and exceptional communication skills. Passionate about leveraging data to drive business growth and profitability. Skilled in collaborating with cross-functional teams to develop innovative solutions and strategies that exceed expectations.

Overview

8
8
years of professional experience

Work History

Data Architect /ETL Developer

Sabel Systems
Beavercreek
10.2024 - Current
  • Design and implement robust, scalable, and reusable ETL/ELT pipelines for ingesting and transforming data from multiple sources into cloud data platforms (e.g., Snowflake, Redshift, Azure SQL).
  • Write and maintain complex SQL queries and stored procedures to support business reporting and analytics needs.
  • Analyze large datasets to uncover actionable insights, trends, and anomalies, and present findings in a business-friendly format.
  • Build and maintain visually compelling dashboards and reports using tools like Power BI, Tableau, or Looker for executive and operational stakeholders.
  • Collaborate cross-functionally with product, engineering, and business teams to understand data needs, and deliver timely solutions.
  • Monitor and optimize data workflows for performance, cost-efficiency, and scalability in cloud environments.
  • Ensure data integrity and consistency through automated testing, validation scripts, and quality checks.
  • Develop and maintain data models and documentation that support accurate reporting and self-service analytics.
  • Automate manual data processes and reporting tasks using Python, Shell scripting, or cloud-native tools.
  • Support ad hoc data requests and custom reporting by delivering fast, accurate query results, with minimal turnaround.
  • Participate in code reviews, data design discussions, and agile ceremonies within a fully remote, distributed team.
  • Integrate external data sources and APIs into internal systems to enhance business intelligence capabilities.

Financial Management Analyst

US Department of Defense (Army Reservist)
Owings Mills
06.2023 - Current
  • Develop and manage budget plans, allocate resources, and ensure effective use of funds in accordance with Army financial policies and regulations.
  • Conduct financial analysis, forecasting, and reporting to support decision-making processes and improve financial performance.
  • Ensure compliance with financial regulations, conduct audits, and implement internal controls to safeguard financial assets and prevent fraud.
  • Prepare financial reports, statements, and presentations to communicate financial information to stakeholders and support strategic planning.
  • Estimate costs, analyze cost structures, and identify opportunities for cost savings and efficiency improvements in financial operations.
  • Manage and track funds, monitor expenditures, and reconcile financial transactions to maintain accurate financial records.
  • Assist in procurement processes, review contracts, and ensure compliance with financial guidelines and regulations for acquisitions.
  • Utilize financial management systems and software to track financial data, generate reports, and streamline financial processes.
  • Provide training and guidance to personnel on financial management practices, policies, and procedures to enhance financial literacy and compliance.
  • Offer financial advice, guidance, and recommendations to commanders and decision-makers on financial matters affecting Army operations and missions.

Senior Health Care Data Engineer / Analyst

Delta Dental
Massachusetts
04.2024 - 09.2024
  • Partnered with subject matter experts, clinical teams, and business stakeholders to drive data-informed decision-making across operations.
  • Accessed enterprise data warehouses and cloud-based data lakes (e.g., Snowflake, Azure Data Lake) to extract and analyze complex healthcare datasets.
  • Led end-to-end analytics projects, from problem scoping and data engineering to statistical analysis and stakeholder presentation, using tools like Jupyter Notebooks and PowerPoint.
  • Collaborated with cross-functional teams to ensure data integrity, consistency, and governance across systems and pipelines.
  • Developed advanced SQL scripts and stored procedures to extract, cleanse, and transform data related to dental insurance policies, claims, and provider networks.
  • Designed and deployed interactive dashboards using Power BI and Tableau, incorporating row-level security, drill-downs, and real-time metrics for both internal leadership and external partners.
  • Provided user training and technical support for data visualization platforms, enabling self-service analytics, and promoting data literacy.
  • Participated in the development and enforcement of data architecture standards, documentation practices, and metadata management protocols.
  • Contributed to special projects involving predictive modeling, operational analytics, and ad hoc executive reporting using Python (Pandas, NumPy), and DAX.
  • Implemented robust data validation frameworks to ensure the accuracy, reliability, and completeness of key performance indicators (KPIs).
  • Developed and maintained ETL/ELT pipelines using tools like Azure Data Factory, dbt (data build tool), and SSIS to streamline and automate data workflows.
  • Tuned query performance and optimized relational and columnar databases (SQL Server, Snowflake) to support scalable, high-performance analytics solutions.
  • Ensured compliance with HIPAA and enterprise data security policies through role-based access controls, data masking, and audit logging.
  • Utilized Git and Azure DevOps for version control, CI/CD integration, and collaboration on data-related projects.

Senior Data Engineer / Analyst

Farmers Insurance
Los Angeles
01.2022 - 04.2024
  • Designed and deployed scalable data pipelines on AWS, leveraging services such as S3, Glue, Lambda, and Redshift for efficient ingestion, transformation, and storage of structured and semi-structured data.
  • Built robust ETL/ELT workflows using dbt (data build tool) and AWS Glue to integrate data from multiple source systems into a centralized Snowflake data warehouse.
  • Tuned and optimized data processing workflows, applying partitioning, clustering, and compression techniques to enhance query performance and reduce compute costs.
  • Utilized advanced SQL (CTEs, window functions, pivot/unpivot, temp tables) to cleanse, join, and manipulate complex datasets related to auto insurance policies, claims, and premium calculations.
  • Developed parameterized SQL scripts, stored procedures, and views to automate recurring data processes, improving consistency, maintainability, and execution time.
  • Partnered closely with actuarial, underwriting, product, and claims teams to translate business requirements into scalable, data-driven solutions.
  • Conducted exploratory and statistical analysis on large datasets using SQL, Python (pandas, matplotlib), and Excel Power Query, uncovering actionable insights to support pricing, risk, and claims strategy.
  • Built real-time and scheduled data visualizations in Power BI and Tableau, enabling dynamic monitoring of key KPIs such as loss ratios, claim frequency, and policy lapse rates.
  • Implemented monitoring solutions using CloudWatch, dbt tests, and data validation scripts to proactively detect anomalies and data drift across environments.
  • Maintained comprehensive documentation for datasets, data lineage, and pipeline architecture using Confluence and Lucidchart, supporting cross-team collaboration and audit-readiness.
  • Adhered to data governance standards and security protocols, ensuring compliance with regulatory frameworks (e.g., SOC 2, HIPAA, PCI-DSS).
  • Managed code versions and deployments using Git, GitHub, and AWS CodePipeline, supporting a CI/CD approach to data infrastructure updates.

Database Developer/ Analyst

Humana Insurance
Louisville
05.2020 - 12.2021
  • Designed and implemented conceptual, logical, and physical data models using Erwin Data Modeler and dbt (data build tool) to structure and standardize enterprise data across multiple business domains.
  • Created and maintained normalized and denormalized database schemas optimized for both transactional systems and analytics workloads, leveraging Snowflake, SQL Server, and PostgreSQL.
  • Defined comprehensive source-to-target mapping documents to guide accurate data transformations from operational systems to cloud data warehouses (e.g., Azure Synapse, Redshift, Snowflake).
  • Applied data normalization techniques to reduce redundancy and enforce data integrity, while also building flattened models for performance-optimized reporting and BI tools.
  • Implemented advanced indexing strategies, materialized views, and query optimization techniques to enhance performance and reduce database latency.
  • Enforced data quality by embedding validation rules, foreign key constraints, and check constraints within schema definitions and ELT frameworks.
  • Engaged with data analysts, data scientists, and business SMEs to translate analytical requirements into scalable, performant data models.
  • Designed and developed high-availability, fault-tolerant cloud-based databases using Amazon RDS, Azure SQL, and Snowflake, ensuring high performance and cost-efficiency.
  • Created and scheduled ETL packages using SQL Server Integration Services (SSIS) and Azure Data Factory for daily ingestion and transformation of structured and semi-structured data.
  • Conducted rigorous unit testing, data reconciliation, and pipeline monitoring using tool like dbt to ensure data integrity across environments.
  • Supported infrastructure enhancements by deploying product updates, schema modifications, and integrations through CI/CD pipelines using Git and Azure.
  • Developed complex SQL scripts, stored procedures, triggers, and user-defined functions to support business logic, batch processing, and report automation.
  • Documented end-to-end data workflows, ETL processes, and architecture diagrams.

Data Analyst

Kroger
Atlanta
04.2017 - 05.2020
  • Conducted in-depth data analysis and generated reports using SQL (T-SQL/PostgreSQL) and advanced Excel functions (e.g., Power Query, pivot tables, VLOOKUP, XLOOKUP) to support operations across sales, marketing, and merchandising departments.
  • Supported the implementation, configuration, and end-user training of the company’s CRM/sales software ecosystem, ensuring seamless integration with existing data workflows.
  • Cleaned, transformed, and prepped data using SQL and Python (pandas, NumPy) for seamless integration into interactive dashboards in Tableau Desktop and Power BI.
  • Documented and streamlined the end-to-end Tableau dashboard development lifecycle, from gathering and evaluating business requirements to building performance metrics and validating visual outputs.
  • Built and maintained interactive Excel dashboards and visual analytics tools using Power Pivot, Power Query, and Power BI Embedded to communicate actionable insights.
  • Partnered with cross-functional teams, including marketing, sales, and merchandising, to develop scalable, data-driven solutions for retail analytics and campaign effectiveness.
  • Conducted ad-hoc analyses using SQL, Excel, and Tableau, answering business-critical questions around inventory, sales trends, customer segmentation, and ROI.
  • Presented analytical findings and dashboard insights to stakeholders through executive-ready data storytelling, leveraging PowerPoint, Loom, and Tableau Public to drive business decisions.
  • Ensured data consistency and reliability by establishing validation processes and automated checks within SQL queries and Excel logic.
  • Leveraged tools like JIRA and Confluence to manage project tasks, document data sources, and ensure collaboration across product and analytics teams.

Education

B.Sc. - Accounting

Central University
Ghana

Associate Chartered Accountant -

Chartered Institutes of Accountants
UK

Skills

Technical Skills & Tools 🔐 Certification
  • CompTIA Security
🧱 Data Modeling, Architecture & Governance
  • Data Modeling (ERwin Data Modeler, dbt, MS Visio)
  • Data Architecture & Schema Design (Star/Snowflake, OLTP/OLAP)
  • Metadata Management & Data Lineage
📊 Data Analytics & Visualization
  • SQL (T-SQL, PL/SQL, ANSI SQL)
  • Python (pandas, NumPy, matplotlib)
  • SAS for Statistical Analysis
  • Tableau, Power BI, Sigma Computing, Looker
  • Excel (Power Query, Power Pivot, VBA)
🛠 ETL/ELT & Data Integration
  • ETL Tools: SSIS, Azure Data Factory, dbt, Talend
  • Data Migration & Transformation
  • Batch & Stream Processing (Kafka, Apache Spark, Azure Stream Analytics)
🌐 Cloud Platforms & Data Warehousing
  • Azure (Data Lake, Synapse, Azure SQL DB, Blob Storage)
  • AWS (S3, RDS, Redshift, Glue, Lambda)
  • Snowflake (Data Sharing, Virtual Warehouses, Time Travel)
  • Google Cloud Platform (BigQuery, Cloud Functions)
🗃️ Databases & Storage
  • Relational DBs: SQL Server, Oracle, PostgreSQL, MySQL
  • NoSQL: MongoDB, Cassandra, DynamoDB, Redis
  • Data Lakes: AWS S3, Azure Data Lake Gen2
🧪 Testing, DevOps & Collaboration
  • Version Control: Git, GitHub, Bitbucket
  • DevOps: Azure DevOps (ADO), GitLab CI/CD
  • Testing: Great Expectations, dbt tests
  • Project Tools: JIRA, Confluence, Slack, MS Teams

Clearance Level

Secret

Timeline

Data Architect /ETL Developer

Sabel Systems
10.2024 - Current

Senior Health Care Data Engineer / Analyst

Delta Dental
04.2024 - 09.2024

Financial Management Analyst

US Department of Defense (Army Reservist)
06.2023 - Current

Senior Data Engineer / Analyst

Farmers Insurance
01.2022 - 04.2024

Database Developer/ Analyst

Humana Insurance
05.2020 - 12.2021

Data Analyst

Kroger
04.2017 - 05.2020

B.Sc. - Accounting

Central University

Associate Chartered Accountant -

Chartered Institutes of Accountants

Similar Profiles

CREATE PROFILE
Daniel Dzacka