Looking for a job

James McCoy

@jamesmccoy

Data Architect at Apex Companies leading a Microsoft Fabric implementation and company-wide data modernization.

At Apex Companies, I’m leading a Microsoft Fabric implementation and designing an enterprise lakehouse to support company-wide analytics. I’m also moving legacy data sources and reporting onto a governed Fabric platform.

At Woolpert, Inc. – Corporate Analytics, I was the sole architect for a greenfield Snowflake environment and led data integration for acquired companies, consolidating financial data for executives and the board. I also partnered with executive leadership on financial analytics, reporting, and strategic KPI frameworks.

Earlier at Woolpert, Inc., I architected an enterprise analytics platform and designed data models for Power BI semantic layers, dashboards, and operational analytics. At Peerless Products, I designed the organization’s first enterprise data warehouse and replaced manual reporting with Power BI dashboards.

Experience

Work history, roles, and key accomplishments

Current

Data and Analytics Manager

Current

Apex Companies

Apr 2026 - Present (6 months)

Leading the company's Microsoft Fabric implementation, designing the enterprise lakehouse architecture and driving data modernization. Defining architecture standards, governance, and security models while partnering with business and executive stakeholders.

Microsoft Fabric OneLake Lakehouse Medallion Architecture Data Governance Data Security Data Modeling Power BI DAX DirectLake Stakeholder Management Data Strategy

Data Architecture Manager

Woolpert, Inc.

Jan 2026 - Mar 2026 (2 months)

Sole architect for a greenfield enterprise Snowflake environment, designing the data warehouse, data models, and platform standards. Led data integration for acquired companies and partnered with the CFO on financial analytics and board-level reporting.

Snowflake Data Warehouse Design Data Modeling M&A Data Consolidation Financial Reporting KPI Frameworks Team Leadership Data Architecture Executive Communication

Senior Data Engineer

Woolpert, Inc.

Apr 2022 - Dec 2025 (3 years 8 months)

Architected and led the enterprise analytics platform on lakehouse principles, designing and maintaining enterprise data models for Power BI. Led and mentored a cross-functional team, implemented data governance and CI/CD pipelines.

Lakehouse Architecture Data Modeling Power BI DAX Data Governance Data Quality CI CD Python SQL Spark ETL ELT Team Leadership Mentorship

Data Analyst

Woolpert, Inc.

Mar 2021 - Mar 2022 (1 year)

Built Power BI dashboards, analytical models, and foundational data schemas that became core leadership reporting assets. Defined metrics, KPIs, and reporting standards with stakeholders across departments.

Power BI Data Modeling KPI Definition Stakeholder Management Data Analysis Reporting

Business Analyst

Peerless Products

Jan 2020 - Mar 2021 (1 year 2 months)

Designed and built the organization's first enterprise data warehouse, replacing Excel-based reporting with governed analytics. Developed SQL Server and SSIS ETL processes and delivered Power BI dashboards for operations and executive leadership.

Data Warehouse Design SQL Server SSIS ETL Power BI PowerApps Power Automate Data Governance

Project Coordinator (Sales)

Peerless Products

Mar 2017 - Jan 2020 (2 years 10 months)

Replaced manual Excel and whiteboard tracking with Power BI dashboards showing company-wide sales output and shop-floor efficiency. Worked with shop-floor teams to identify process inefficiencies and turn operational insight into actionable data.

Power BI Data Visualization Process Improvement Operational Analysis