Business Intelligence Engineer

Concord; Kansas City (MO); Hybrid; USD 85,000 - 110,000; Full time

Job summary

Concord, a leading consulting firm, seeks a Business Intelligence Engineer to join their BI team in Kansas City. The role involves data preparation and dashboard development, requiring strong SQL and Python skills. Successful candidates will create custom queries, build database architectures, and implement ETL processes using tools like AWS and Databricks.

Qualifications

• 2+ years as a Business Intelligence Developer or similar roles.
• Strong SQL and Python scripting for automation required.
• Experience in database management systems and BI technologies.

Responsibilities

• Create and maintain customized SQL queries and reporting structures.
• Build and maintain database architecture and optimize queries.
• Develop and implement ETL processes using data transformation tools.

Skills

SQL

Python

Data transformation

Data visualization

Communications

Education

Bachelor’s degree in Analytics, Computer Science, Information Systems, Business, Marketing, or related discipline

Tools

Tableau

Power BI

Qlik

AWS

Snowflake

Azure

Google Cloud

Databricks

Alteryx

Job description

Get AI-powered advice on this job and more exclusive features.

This range is provided by Concord. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$85,000.00/yr - $110,000.00/yr

Concord isn't your typical consulting firm; we are an execution company with a passion for making things happen. Our mission is to help clients enhance customer experiences, optimize operations, and revolutionize their product offerings through seamless integration, optimization, and activation of technology and data.

We are looking for a Business Intelligence Engineer to join the BI team. In this role, you will focus on data preparation and dashboard development. Strong skills in SQL and Python are essential, along with experience in creating visually compelling dashboards. Our ideal candidate has a talent for transforming raw data into polished dashboards and actionable insights.

What You Will Be Doing

• Create and maintain customized SQL queries to build reporting data structures.
• Build and maintain database architecture, including fine tuning and optimizing queries, data pipelines, and automation workflows.
• Validate data to determine and document any gaps between available data and requirements for reporting outputs, dashboards, modeling use cases, and downstream analysis.
• Develop and implement data transformation processes (ETL) using tools like Databricks, Alteryx, or others.
• Leverage your expertise in cloud-based data solutions like AWS, Snowflake, Azure, or Google Cloud.

What We Are Looking For

• At least 2 years of experience as a Business Intelligence Developer or in similar roles.
• Experience in scripting for automation (e.g. Python) and advanced SQL skills.
• Strong technical skills in database management systems and BI technologies such as Tableau, PowerBI, and Qlik.
• Developing and implementing data transformation via ETL processes and data pipelines, including experience in ETL software such as Databricks and/or Alteryx.
• Working within AWS, Snowflake, Azure or Google Cloud cloud-based data solutions.
• Working with a leading analytics or relational database system, such as Redshift, Vertica, BigQuery, PostgreSQL, Microsoft SQL Server, or MySQL.
• Excellent interpersonal, communication, listening and presentation skills.
• The ability to work both as a team and independently.
• Minimum of a Bachelor’s degree in Analytics, Computer Science, Information Systems, Business, Marketing, or a related discipline.

Job Specifications

• Employment type: Full-time permanent employment at Concord.
• Location: Hybrid Flex (1-2 days on-site, but flexible) in the Kansas City area is preferred.
• Interview process: (1) introductory call, (2) take-home assessment, and (3) interview with the hiring manager.
• Consideration will be given to qualified candidates with varying levels of experience, with compensation commensurate with experience.
• Requirements: Must be legally authorized to work in the United States without company sponsorship now or in the future.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at Concord by 2x

Get notified about new Business Intelligence Engineer jobs in Kansas City Metropolitan Area.

Liberty, MO $74,200.00-$106,000.00 1 day ago

Kansas City, MO $100,000.00-$150,000.00 6 days ago

Overland Park, KS $100,000.00-$150,000.00 6 days ago

Business Intelligence Analyst - Qlik Sense

United States $80,000.00-$100,000.00 5 days ago

Kansas City Metropolitan Area $60,000.00-$65,000.00 4 days ago

Kansas City, KS $112,597.33-$152,810.66 1 month ago

Kansas City, MO $112,597.33-$152,810.66 1 month ago

Data Engineer, Intelligence & Operations

Liberty, MO $74,200.00-$106,000.00 18 hours ago

Kansas City, MO $144,768.00-$209,109.33 1 month ago

Kansas City, KS $144,768.00-$209,109.33 1 month ago

Junior Data Engineer, Intelligence & Operations

Sr. Business Data Analyst - Enterprise Data Warehouse

Lees Summit, MO $92,628.00-$130,572.00 20 hours ago

Senior Data Engineer, Intelligence & Operations

Kansas City, KS $116,480.00-$149,760.00 1 month ago

Kansas City, MO $116,480.00-$149,760.00 1 month ago

Kansas City, MO $90,000.00-$130,000.00 2 weeks ago

Kansas City, KS $116,480.00-$149,760.00 1 month ago

Kansas City, MO $120,000.00-$140,000.00 3 hours ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.