Open to opportunities

Jacob Palmer

@jacobpalmer1

Message

I build production Power BI, SQL, and ERP integrations that automate complex business operations.

United States

Message

What I'm looking for

I'm looking to build and deliver production analytics, data engineering, and business-system integrations that automate complex operations and create measurable value for users.

At Humana, I support 35–40 production Power BI reports serving 1,000+ users, including a 6-million-row model visible to the CTO. I write and optimize SparkSQL and Databricks SQL, build semantic models and automated dataflows, and release version-controlled BI solutions through deployment pipelines.

At Syscon, I deliver construction technology consulting across Sage 100 Contractor and Sage Intacct, covering ERP integrations, migrations, payroll automation, and analytics. My work has reduced payroll processing labor by roughly 90%, saved clients 10–15 hours per week through dynamic SQL automation, and eliminated 30–40 weekly hours of dual entry through a Monday.com-to-Sage integration.

I've also built Power Apps, Excel/VBA applications, PostgreSQL/AWS data pipelines, and an LLM-based natural-language SQL tool for secured ERP reporting. I bring hands-on experience from operating a residential construction company and managing manufacturing operations.

Experience

Work history, roles, and key accomplishments

Current

SQL & Power BI Data Analyst

Current

Humana

Nov 2025 - Present (9 months)

Support 35-40 production Power BI reports serving 1,000+ users across consumer-facing operations. Develop and release within Power BI Premium workspaces using deployment pipelines and Git integration.

SQL SparkSQL Power BI DAX Power Query Git DirectQuery Import Data Modeling

Current

Business Applications Consultant

Current

Syscon Inc.

Feb 2024 - Present (2 years 6 months)

Consult on Sage 100 Contractor and Sage Intacct environments, delivering reporting, integrations, automation, and data work. Built a payroll transformation tool and led integration design for a bidirectional sync between BuildOps and Sage 100 Contractor.

Sage 100 Contractor Sage Intacct SQL Power BI Power Automate REST APIs Webhooks Data Migration ETL Data Modeling DAX Power Query Excel VBA Git Bitbucket LLM MCP

Owner / Builder

Atlas Solutions

Jan 2020 - Dec 2024 (4 years 11 months)

Owned and operated a residential building/contracting company, managing estimating, AP/AR, budgeting, inventory, scheduling, QA, and customer relations. Ran the business on self-built tooling including a PostgreSQL/AWS data pipeline and Power BI analytics.

PostgreSQL AWS Power BI Data Pipelines Project Management Budgeting Inventory Management

Project Engineer

Wavelock Advanced Technologies

Mar 2022 - Jun 2023 (1 year 3 months)

Oversaw transfer of a $10M manufacturing program and ran day-to-day plant operations across three shifts. Installed and programmed robotic cells and built a SharePoint-based validation system.

Manufacturing Robotics SharePoint Microsoft Forms Power Automate CAD Quality Control Staffing Production Management

Independent Residential Subcontractor

Self Employed

Jan 2015 - Dec 2019 (4 years 11 months)

Performed full-scope residential trade work from rough framing through finish carpentry as an independent 1099 subcontractor while self-funding two degrees.

Carpentry Frame Finish Carpentry Construction Trades