Business Intelligence Engineer

Concord; Kansas City, Northern (MO, KY); Hybrid; USD 80,000 - 110,000; Full time

Benefits offered by this job

Health, Dental, and Vision Insurance

HSA contributions

FSA options with $200 LSA

Disability insurance

Life and AD&D Insurance

EAP

Career growth opportunities

Team engagement activities

PTO and holidays

Job summary

Concord is looking for a Business Intelligence Engineer to join our BI team. You will focus on data preparation, transformation, and analytics engineering to deliver trusted data products and actionable insights.

The role requires strong SQL and Python skills and experience with Databricks and Snowflake. You’ll collaborate with stakeholders to translate requirements into scalable data models and dashboards, enabling data-driven decision making.

Qualifications

• 5+ years in BI/Analytics engineering or similar roles.
• Experience with SQL, data modeling, and data warehousing concepts.
• Experience integrating data from multiple source systems.
• Experience with Databricks and Snowflake is preferred.
• Knowledge of AI-assisted analytics and governance considerations.

Responsibilities

• Create and maintain SQL queries, data models, and reporting structures.
• Develop data pipelines and ETL/ELT processes across cloud platforms.
• Transform raw data into trusted data products and dashboards.
• Collaborate with stakeholders to translate requirements into data solutions.
• Profile and validate data, identify gaps, and improve data quality.

Skills

Strong SQL skills

Python

Databricks

Snowflake

ETL/ELT

Data modeling

Cloud data platforms

Tableau/Power BI/Qlik

AI-enabled analytics

Education

Bachelor's degree in Analytics

Bachelor's degree in Computer Science

Bachelor's degree in Information Systems

Bachelor's degree in Business

Tools

Databricks

Snowflake

Tableau

Power BI

Job description

AboutUs

Concord isn't your typical consulting firm; we're an execution company. We help organizations move technology and AI initiatives from concept to measurable capability, working alongside our clients from the initial definition of success through full implementation and adoption.
Our team brings expertise across artificial intelligence and data, digital experience, and platform engineering, enabling the organizations we serve to build lasting internal capability. We operate as a global team, with a presence across the United States, Latin America, Europe, and India, giving our clients access to specialized talent and continuous coverage across time zones.

AboutTheRole

We are looking for a Business Intelligence Engineer to join our Business Intelligence team. In this role, you will focus on data preparation, data transformation, and analytics engineering. You’ll work across the modern data stack to transform raw data into trusted, scalable data products, polished dashboards, and actionable insights.

The ideal candidate has strong SQL and Python skills, and experience working with cloud data platforms such as Databricks and Snowflake. Additionally, familiarity with AI-powered analytics and productivity tooling is a plus, as we continue to explore how AI can improve data development, reporting, analysis, and business decision-making.

WhatYouWillBeDoing

• Create and maintain customized SQL queries, data models, and reporting data structures to support dashboards, reporting, analytics, and downstream use cases.
• Build, maintain, and optimize data pipelines and database architecture, including query performance tuning, automation workflows, and data processing.
• Develop and implement data transformation and ETL/ELT processes using modern data engineering and analytics platforms such as Databricks, Snowflake, Microsoft Azure, Google Cloud Platform and AWS.
• Partner with stakeholders to understand business requirements and translate them into data models and analytics use cases.
• Validate and profile data to identify, document, and resolve gaps between available data and requirements for reporting outputs, dashboards, modeling use cases, and downstream analysis.
• Develop automation using Python, SQL, and other scripting technologies to improve data workflows and reduce manual processes.
• Collaborate with data engineers, BI developers, analysts, and business stakeholders to ensure data solutions are scalable, reliable, and aligned to business needs.
• Stay current with AI-enabled data and analytics tooling, including emerging capabilities that can accelerate data product development.
• Evaluate and apply AI tooling appropriately, with an understanding of the importance of data security, governance, access controls, accuracy, and human validation when using AI in analytics environments.
• Contribute to the development of reusable analytics engineering patterns, best practices, and accelerators across the organization.

WhatWeAreLookingFor

• At least3years of experience as a Business Intelligence Engineer, BI Developer, Analytics Engineer, Data Analyst, or in a similar technical role.
• StrongSQLskills, including experience writing complex queries, optimizing query performance, and working with large datasets.
• Experience integrating data from multiple source systems and working with complex enterprise data environments.
• Experience withPython or another scripting languagefor automation, data transformation, analysis, or application development.
• Hands-on experience withDatabricks and/or Snowflake, with a strong preference for candidates who have experience working across both platforms.
• Experience developing and implementingETL/ELT processes, data pipelines, and data transformation workflows.
• Experience with data modeling concepts including medallion, data vault, and relational architectures.
• Experience with modern cloud-based data solutions, includingSnowflake, Databricks, AWS, Azure, or Google Cloud.
• Strong technical understanding of relational and analytical database technologies such asSnowflake, Databricks, Redshift, Vertica, BigQuery, PostgreSQL, Microsoft SQL Server, or MySQL.
• Experience with BI and visualization technologies such asTableau, Power BI, Qlik, or similar platforms.
• Ability to translate business requirements into effectivedata models, reporting structures, dashboards, and analytics solutions.
• Familiarity withAI tools and AI-assisted development/analytics workflows, such as using generative AI to support SQL development, Python, data analysis, documentation, or other data and BI activities.
• Understanding of data quality, governance, security, and access considerations when developing analytics solutions.
• Strong analytical and problem-solving skills with the ability to investigate data issues and determine root causes.
• Excellent interpersonal, communication, listening, and presentation skills.
• Ability to work effectively both independently and as part of a collaborative team.
• Minimum of aBachelor’sdegreeinAnalytics, Computer Science, Information Systems,Businessor a related disciplineor equivalent experience.

WhatWeOffer (W2 Benefits)

• Health, Dental, and Vision Insurance: Comprehensive coverage to support your well-being.
• Employer Contributions to Health Savings Accounts (HSA): Helping you save for medical expenses.
• Flexible Spending Accounts (FSA): Options for healthcare and dependent care expenses, plus a $200 Lifestyle Spending Account (LSA).
• Disability Insurance: Short- and long-term coverage, fully paid by the employer.
• Life and AD&D Insurance: Employer-provided coverage, with options for additional voluntary coverage.
• Employee Assistance Program (EAP): Access to personal and professional support resources.
• Career Growth Opportunities: Pathways for advancement and skill development.
• Team Engagement Activities: Regular team-building events and company-sponsored activities to foster collaboration and connection.
• Paid Time Off and Holidays (Only W2 Salary*): PTO policy and paid company holidays.

AdditionalInformation

• Employment Type: Full-time employment with Concord
• Salary: $80,000–$110,000 annually
• Work Arrangement: Hybrid-flex; 1–2 days on-site, with flexibility
• Preferred Locations: Kansas City or Minneapolis
• Interview Process: (1) Introductory call, (2) Coding assessment, (3) Panel interview with the hiring team, and (4) Final round with the hiring manager
• Requirements: Must be legally authorized to work in the United States without company sponsorship, now or in the future.

***

Concord is an execution partner helping organizations drive digital transformation, modernization, and scalable technology solutions. We deliver results that solve real business challenges. We operate globally and are growing fast, shaping the future of technology. Join a team trusted by top companies to drive strategic growth and operational excellence!