> Markdown version of [/jobs/ext/2866982-lead-business-intelligence-data-engineer](https://www.wearedevelopers.com/jobs/ext/2866982-lead-business-intelligence-data-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Lead Business Intelligence Data Engineer

- **Company:** Property Insurance Company Of America
- **Location:** League City, TX, United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Amazon Web Services, Data Analysis, Microsoft Azure, Data Architecture, Information Engineering, Data Infrastructure, Extract Transform Load (ETL), Data Systems, Data Warehousing, Dimensional Modeling, Job Control Language (JCL), Python (Programming Language), Mainframes, Object-Oriented Software Development, Standard Sql, Reverse Engineering, Software Engineering, SQL Databases, Z/OS, Enterprise Data Management, Scripting, Cloud Platform System, Data Ingestion, Azure Data Factory, Snowflake, Software Troubleshooting, Data Lakes, Data Delivery, Databricks
- **Published:** September 12, 2026
- **Apply:** https://www.dice.com/job-detail/63856211-2038-4b28-8dcc-6ea16e0e7eb9

## About the Role

* Six + years of relevant data engineering or business intelligence experience
 * A bachelor's degree or an equivalent combination of relevant experience and professional credentials
 * Expert-level SQL programming skills
 * Hands-on experience with Python or another enterprise scripting or object-oriented language
 * Experience with data ingestion, integration, ETL, and the software development lifecycle
 * Ability to reverse engineer existing code and translate legacy processes into modern solutions
 * Strong troubleshooting, analytical, collaboration, and technical mentoring skills

Preferred Experience

 * Azure or AWS cloud engineering experience
 * Experience with Databricks, Snowflake, Azure Data Factory, or comparable platforms
 * Knowledge of dimensional modeling, data architecture, and full-stack data delivery
 * Mainframe or z/OS experience, including JCL, Zeke, or navigating mainframe applications
 * Experience in insurance or financial services

Ready to modernize enterprise data at scale? Apply to bring your SQL expertise, engineering mindset, and collaborative guidance to a team who are building reliable data solutions across the organization.

## Description

Join our Data Platform team as a Lead Business Intelligence Data Engineer and help modernize the pipelines that power enterprise reporting, analytics, and actuarial models. You will lead complex data engineering efforts across mainframe, data warehouse, data lake, and cloud environments while serving as a trusted technical adviser.

What You Will Do

 * Build, monitor, and enhance pipelines that ingest data from core enterprise systems
 * Prepare, transform, govern, and validate data for reporting, analytics, and downstream models
 * Reverse engineer legacy SQL and mainframe processes and modernize them using Python notebooks, Databricks, or similar cloud tools
 * Own complex enterprise projects and data-domain initiatives from design through production
 * Develop standards, best practices, and workflows that improve data quality and delivery
 * Troubleshoot complex data issues and provide advanced technical analysis
 * Mentor developers and collaborate with Actuarial, Life, Annuity, Pension Risk Transfer, and Enterprise Data Analytics teams


## Related Videos

- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [JavaScript? No. Java Scripts! - Scripting with Java](https://www.wearedevelopers.com/videos/2094-javascript-no-java-scripts-scripting-with-java)
- [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team)
- [Intermediate Bitcoin Script](https://www.wearedevelopers.com/videos/25-intermediate-bitcoin-script)
- [Hacking AI at the Edge of the Indian Ocean](https://www.wearedevelopers.com/videos/100177-hacking-ai-at-the-edge-of-the-indian-ocean)
- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)

## Related Articles

- [How to Become an AI Engineer](https://www.wearedevelopers.com/magazine/331-how-to-become-an-ai-engineer)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)