Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

James McWain

Hoover,AL

Summary

PROFESSIONAL SUMMARY
Results-driven Data Architect with over 4 years of experience in SQL Server, Azure, Databricks, and Data Warehousing. Adept at designing scalable, secure, and high-performance data solutions that drive business intelligence and analytics. Expertise in ETL processes, cloud data storage, and data pipeline orchestration with a strong focus on security, compliance, and technical leadership.

Overview

10
10
years of professional experience
1
1
Certification

Work History

Data Analyst

LongLake Data
03.2020 - Current
  • Designed and implemented high-performance ETL pipelines using Azure Data Factory and Databricks to process large-scale datasets.
  • Optimized SQL Server databases and Data Warehouses by implementing indexing, partitioning, and query tuning techniques.
  • Built and managed Delta Lake storage solutions for data versioning and schema evolution in Azure Databricks.
  • Led the migration of on-prem SQL Server databases to Azure SQL Database and Azure Synapse Analytics, improving data accessibility and reducing costs.
  • Developed automated monitoring and alerting systems using Azure Monitor and Log Analytics to ensure data integrity and availability.
  • Collaborated with business stakeholders to define data models and reporting strategies, leveraging Power BI and Synapse SQL Pools.

Data Analyst

Vulcan Materials
04.2015 - 03.2020
  • Collected, cleaned, and analyzed large datasets to identify trends, patterns, and insights to support business decision-making.
  • Developed and maintained dashboards and reports using tools such as Power BI, Tableau, or Excel.
  • Conducted data mining and statistical analysis using SQL, Python, or R to extract actionable insights.
  • Collaborated with cross-functional teams to understand data needs and provide timely analytical support.
  • Presented findings and recommendations to stakeholders through visualizations and written reports.
  • Automated repetitive data processes, improving efficiency and reducing manual errors.
  • Ensured data integrity and accuracy by performing regular data validation and quality checks.
  • Supported A/B testing, forecasting, and predictive modeling for product and marketing teams.
  • Created and maintained documentation for data sources, processes, and analytical methodologies.
  • Provided ad-hoc analysis to support strategic initiatives and performance metrics tracking.

Education

Associate of Applied Science - CNS

ITT
Bessemer, AL
01-2012

Skills

  • Databases: SQL Server, Azure SQL Database, Azure Synapse Analytics, SQL Data Warehouses
  • Cloud Technologies: Azure Data Factory, Azure Storage (Blob, ADLS), Azure Databricks, Azure Functions, Azure Monitor
  • Big Data & Analytics: Databricks Notebooks, Apache Spark, Delta Lake, Power BI
  • ETL & Data Engineering: ADF Pipelines, SSIS, Databricks Workflows, PolyBase
  • Programming: SQL, Python (PySpark), T-SQL
  • Security & Compliance: Role-Based Access Control (RBAC), Data Encryption, GDPR, HIPAA Compliance

Certification

CERTIFICATIONS
Microsoft Certified: Azure Data Engineer Associate

Microsoft Certified: Azure Solutions Architect Expert (In Progress)

Databricks Certified Data Engineer Associate

Timeline

Data Analyst

LongLake Data
03.2020 - Current

Data Analyst

Vulcan Materials
04.2015 - 03.2020

Associate of Applied Science - CNS

ITT

Similar Profiles

CREATE PROFILE