Business Intelligence Analyst

Prime Capital Financial

Overland Park (KS)

On-site

USD 90,000 - 120,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Prime Capital Financial seeks a hands-on BI Analyst to advance their data integration, reporting, and AI-enabled initiatives. You will transform diverse data into reliable datasets, build automation, and enable scalable analytics across the organization.

You'll work with Python, SQL, Alteryx, Snowflake, Redshift, PostgreSQL, and Tableau to deliver actionable insights, monitor data quality, and partner with BI leadership on continuous improvement and innovation.

Qualifications

  • Experience building and maintaining data pipelines and automated workflows.
  • Familiarity with data quality checks and documenting data sources and rules.

Responsibilities

  • Build, maintain, and improve data ingestion, transformation, and automation workflows using Python, SQL, Alteryx, and related tools.
  • Integrate data from internal applications and external APIs and file feeds.
  • Query and manage datasets in Snowflake, Redshift, and PostgreSQL for downstream use.
  • Monitor production jobs, diagnose failures, and document business rules and metrics definitions.

Skills

Python
SQL
Data visualization
Problem-solving

Tools

Alteryx
Snowflake
Amazon Redshift
PostgreSQL
Tableau

Job description

Overview:

The Business Intelligence Analyst supports the development, reliability, and continuous improvement of Prime Capital Financial’s business intelligence, data integration, and automation environment. Working alongside other BI analysts as a peer and under BI leadership, this person turns information from across the business into trusted datasets, efficient workflows, and actionable insights. Our team works across the full data lifecycle, from source-system integrations and production data pipelines to reporting, analytics, and emerging AI-enabled applications. We seek a hands‑on, resourceful problem‑solver who brings practical Python and visualization skills, intellectual curiosity, and a willingness to learn. Expertise in every platform is not expected on day one.

KEY RESPONSIBILITIES:
Data Engineering, Integration, and Quality
  • Build, maintain, and improve data ingestion, transformation, and automation workflows using Python, SQL, Alteryx, and related tools.
  • Integrate data from internal applications, partner/vendor APIs, and file‑based feeds, including CRM, portfolio management, and other financial services systems.
  • Query and work with datasets in Snowflake, Amazon Redshift, and PostgreSQL while maintaining reliable, well‑structured data for downstream use.
  • Monitor production jobs and refreshes, diagnose failures and anomalies, implement data quality checks, and document business rules, metric definitions, and procedures.
Analytics, Reporting, and Business Insights
  • Build and maintain clear, accurate visualizations and recurring reports in Tableau, which serves as our firm’s primary reporting and visualization layer.
  • Analyze business and operational performance, including assets, revenue, growth, retention, and advisor or client activity. The ability to glean new insights is always desirable.
  • Translate stakeholder questions into analytical requirements, explain findings, and communicate limitations and recommendations.
Automation, Cloud Technologies, and Emerging AI
  • Identify repetitive work and develop maintainable automations that improve efficiency, consistency, and data accuracy.
  • Support cloud‑based integrations, workflows, and processing systems as team priorities require.
  • Help prepare and validate trusted data for internal AI‑enabled applications, including content extraction and connections to business systems.
Creative Problem Solving, Innovation, and Continuous Improvement
  • Approach ambiguous technical and business challenges with curiosity, persistence, and original thinking. Investigate root causes rather than applying temporary fixes.
  • Propose, prototype, and evaluate better approaches to data pipelines, analytics, reporting, and operational processes while weighing reliability, maintainability, and business impact.
  • Challenge inefficient processes constructively, seek feedback, stay current with new technologies, and turn lessons learned into practical improvements.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Insights & Data Automation Specialist
Insights & Data Automation Specialist

Prime Capital Financial • Overland Park (KS)

On-site
USD 90,000 - 120,000
Business Intelligence Analyst
Business Intelligence Analyst

Tiger Lilies Consulting LLC • Phoenix (AZ)

On-site
USD 75,000 - 105,000
Competitive salary
Ownership stake in the company
Medical insurance
+6
Associate
Associate

Search Services LLC • Austin (TX)

On-site
USD 90,000 - 130,000
Data Analytics & BI Analyst
Data Analytics & BI Analyst

Signature IT World • Hanover Township (NJ)

On-site
USD 80,000 - 120,000
Financial & Business Analyst
Financial & Business Analyst

IC System • Saint Paul (MN)

On-site
USD 75,000 - 110,000
Business Intelligence Analyst & Data Engineer- Remote
Business Intelligence Analyst & Data Engineer- Remote

DeepSource Technologies • United States

Hybrid
USD 90,000 - 130,000
Business Intelligence Analyst
Business Intelligence Analyst

Knack Solutions • Cleveland (OH)

Remote
USD 70,000 - 100,000
Competitive medical, dental, and vision benefits
Business Analyst
Business Analyst

Idi Insulation • Chanhassen (MN)

On-site
USD 90,000 - 120,000
Health coverage
401(k) with company match
Paid time off for vacation and hols
+2
Business Intelligence Analyst
Business Intelligence Analyst

No Limit Staffing, Inc. • Florida

On-site
USD 70,000 - 95,000
Business Intelligence Analyst
Business Intelligence Analyst

InfiJobs LLC • United States

Hybrid
USD 60,000 - 90,000