Senior Business Intelligence & Analytics Engineer
Summary
Senior BI & Analytics Engineer at a Dallas-based specialty property/casualty insurer, owning the data platform end-to-end — ingestion, dbt transformations, semantic models, and BI reporting that drive underwriting, claims, and executive decisions. Core stack: SQL, dbt, Snowflake, Sigma, Azure, Python.
Senior Business Intelligence & Analytics Engineer
Upland Capital Group, Inc. is an AM Best rated “A-” VIII specialty property/casualty insurer headquartered in Dallas, Texas. Through its wholly owned insurance carrier, Upland Specialty Insurance Company, the company markets, underwrites and services specialty insurance products in select markets to include excess transportation, construction casualty, excess casualty, primary general liability, excess public entity, professional liability errors and omissions as well as excess cyber liability.
We focus on “old school” underwriting as a craft, add “new school” analytics and technology, and encourage a gritty, growth mindset among people called “we entrepreneurs.”
As an Excess and Surplus (E&S) carrier, we face unique and interesting challenges every day. We are seeking a Senior Business Intelligence & Analytics Engineer to join our amazing team.
Primary Function:
Upland Capital Group is seeking a Senior Business Intelligence & Analytics Engineer to be a technical expert within our growing Data organization. This is a high-impact, hands-on role responsible for continued building and maintaining of our data platform, architecting scalable, well-governed data models, and delivering analytics solutions that directly influence underwriting, claims, and executive decision-making.
You will provide technical mentorship, guide best practices across SQL, dbt, and BI development, and act as a key partner to cross-functional leaders. Senior Engineers at Upland are expected to operate with significant autonomy-owning complex projects end-to-end, elevating data quality standards, and contributing to the long-term design of our data platform.
The ideal candidate:
- Operates with mature technical judgment and strong business acumen
- Leads others through influence, mentorship, and exceptional communication
- Thrives in a fast-paced, evolving environment
- Thinks in systems - comfortable owning platform architecture, not just individual models
- Drives innovation, standardization, and continuous improvement
- Sets a high bar for accuracy, documentation, and data governance
Duties and Responsibilities:
- Design, develop, and maintain core layers of the data platform, including ingestion, transformation, and semantic layers.
- Support the reliability and timeliness of recurring reporting cycles that depend on the data platform
- Design, build, and optimize scalable dbt models, data marts, and analytics layers
- Write, optimize, and review complex SQL with a focus on performance, reliability, and maintainability
- Build and maintain Sigma data models, workbooks, and self-service analytics solutions
- Apply engineering rigor - testing, CI/CD, version control - to analytics development
- Translate complex business requirements into well-designed analytical solutions
- Lead code reviews, enforce modeling and naming standards, and mentor engineers and analysts on the team
- Proactively identify and resolve data quality, modeling, and pipeline performance issues
- Contribute to analytics engineering standards, documentation, and long-term architecture decisions
- Additional responsibilities as needed
Other Essential Duties include but not limited:
- Troubleshoot and resolve platform and pipeline issues affecting downstream consumers
- Follow internal data governance, documentation, and security standards
- Represent the team in strategic discussions related to process improvements
- Participate in team retrospectives and process improvements
- Keep documentation current as dashboards and pipelines evolve
- Drive cross-functional initiatives to expand the company’s data maturity
- Stay updated on tools used by the team (e.g., dbt, Sigma, Snowflake, Azure)
- Contribute to a team culture that values clarity, curiosity, and follow-through
Experience, Education, Special Skills Required:
- 5+ years of professional experience in analytics engineering, data engineering, data platform development, or a related field
- Bachelor's degree in related field
- Insurance industry experience preferred but not required
- Advanced proficiency in SQL and data modeling
- Strong expertise with dbt and Snowflake; working knowledge of Python
- Advanced experience with a modern BI platform; hands-on Sigma Computing experience strongly preferred
- Demonstrated experience leading complex analytics initiatives with solid problem-solving skills
- Strong communication skills with both technical and non-technical teammates
- Bachelor’s degree in a technical or quantitative field (or equivalent experience)
Disclosures:
Pay Estimate: $120,000 - $135,000
Other compensation: annual incentive program
Benefits: health insurance including FSA and HSA options and free access to Teladoc, vision, dental, disability and life insurance, parental leave, responsible time off (unlimited vacation days without an accrual system), paid sick time as required by law, 401(k), tuition reimbursement and employee assistance program.