Lead Business Intelligence Analyst

Caterpillar Inc.

Lead Business Intelligence Analyst driving analytics initiatives across product teams and business units at Caterpillar. Utilizing SQL and Snowflake for data-driven decision-making and strategic roadmapping.

Posted 7/24/2026full-timeChicago • Illinois, Texas • 🇺🇸 United StatesSenior💰 $128,470 - $192,710 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in leading business intelligence initiatives, leveraging SQL and Snowflake for data analysis, and developing scalable analytics solutions that align with organizational goals. Proven ability to communicate insights effectively and mentor teams in best practices for data governance and quality.

Highest-signal resume keywords

SQL ProficiencySnowflake ExperienceBusiness Intelligence MethodologiesProgram Management SkillsData Governance Best Practices

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data AnalysisData ModelingRoot Cause AnalysisData TransformationAnalytical TechniquesReporting FrameworksData Quality ManagementComplex SQL Query DesignScalable Dataset CreationPerformance Tuning

Soft Skills

Influencing DecisionsStakeholder EngagementEffective CommunicationRelationship BuildingStorytelling Skills

Tools & Technologies

Enterprise Data PlatformsData Visualization ToolsAnalytical DashboardsData Exploration ToolsReporting Tools

Industry Keywords

Business IntelligenceData AnalyticsData GovernanceOperational EfficiencyChange Management

Tech Stack

Tools & technologies

SQL

About the role

Key responsibilities & impact

Lead strategic business intelligence and data analytics initiatives across product teams, business units, and leadership stakeholders.
Partner with business leaders to understand priorities and translate complex business challenges into scalable data and analytics solutions.
Drive planning, prioritization, and execution of BI products, analytical datasets, dashboards, and data-driven initiatives.
Leverage SQL, Snowflake, and enterprise data platforms to analyze data, identify insights, and support business decision-making.
Collaborate with data engineering teams to develop, optimize, and maintain scalable data solutions, datasets, and reporting capabilities.
Establish and promote governance, data quality, and best practices that improve the consistency, reliability, and scalability of analytics solutions.
Develop strategic roadmaps that align business intelligence capabilities with organizational goals and future business needs.
Communicate insights, recommendations, and technical concepts effectively to executive, business, and technical audiences.
Mentor analysts and provide leadership in solution design, stakeholder engagement, and analytical best practices.
Lead process improvement, modernization, and change management efforts that enhance business intelligence capabilities and drive operational efficiency.

Requirements

What you’ll need

Experience leading multiple concurrent initiatives in a fast-paced, evolving environment.
Ability to align business intelligence strategies, roadmaps, and priorities with organizational objectives.
Strong program management skills with the ability to manage risks, dependencies, resource constraints, and stakeholder expectations.
Demonstrated ability to influence decisions, drive alignment, and execute across cross-functional teams.
Strong knowledge of business intelligence methodologies, reporting frameworks, and analytical techniques.
Ability to leverage data to identify trends, risks, opportunities, and strategic recommendations.
Experience translating complex business questions and requirements into scalable analytics solutions.
Advanced proficiency in SQL for data extraction, transformation, validation, and analysis.
Ability to perform complex data investigations and root cause analysis to support business decisions and operational improvements.
Advanced knowledge of relational databases, data modeling, and enterprise data architecture principles.
Extensive experience designing, optimizing, and troubleshooting SQL queries against large-scale datasets.
Experience developing analytical solutions using Snowflake, including data exploration, transformation, performance tuning, and data sharing.
Experience creating scalable, business-ready datasets, semantic models, and reusable data assets.
Strong understanding of data quality, governance, and best practices for managing structured and semi-structured data.
Ability to guide solution design and development efforts in partnership with analysts, developers, and data engineers.
Experience establishing standards, governance models, and best practices for reporting, analytics, and data solutions.
Ability to balance technical capabilities, business needs, and long-term scalability.
Expert ability to communicate effectively with executive leaders, business partners, and technical teams.
Strong presentation, facilitation, written communication, and storytelling skills.
Ability to distill complex technical and analytical concepts into clear, actionable recommendations.
Proven ability to build relationships, influence without authority, and align diverse stakeholder groups.

Benefits

Comp & perks

Medical, dental, and vision benefits*
Paid time off plan (Vacation, Holidays, Volunteer, etc.)*
401(k) savings plans*
Health Savings Account (HSA)*
Flexible Spending Accounts (FSAs)*
Health Lifestyle Programs*
Employee Assistance Program*
Voluntary Benefits and Employee Discounts*
Career Development*
Incentive bonus*
Disability benefits
Life Insurance
Parental leave
Adoption benefits
Tuition Reimbursement