Business Intelligence Engineer

Concord USA • Kansas City or Minneapolis, MO

7d • Hybrid

About The Position

Concord is looking for a Business Intelligence Engineer to join their Business Intelligence team. This role focuses on data preparation, data transformation, and analytics engineering. The engineer will work across the modern data stack to transform raw data into trusted, scalable data products, polished dashboards, and actionable insights. The ideal candidate will have strong SQL and Python skills, and experience with cloud data platforms like Databricks and Snowflake. Familiarity with AI-powered analytics and productivity tooling is also a plus.

Requirements

• At least 3 years of experience as a Business Intelligence Engineer, BI Developer, Analytics Engineer, Data Analyst, or in a similar technical role.
• Strong SQL skills, 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 with Python or another scripting language for automation, data transformation, analysis, or application development.
• Hands-on experience with Databricks and/or Snowflake, with a strong preference for candidates who have experience working across both platforms.
• Experience developing and implementing ETL/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, including Snowflake, Databricks, AWS, Azure, or Google Cloud.
• Strong technical understanding of relational and analytical database technologies such as Snowflake, Databricks, Redshift, Vertica, BigQuery, PostgreSQL, Microsoft SQL Server, or MySQL.
• Experience with BI and visualization technologies such as Tableau, Power BI, Qlik, or similar platforms.
• Ability to translate business requirements into effective data models, reporting structures, dashboards, and analytics solutions.
• Familiarity with AI 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 a Bachelor’s degree in Analytics, Computer Science, Information Systems, Business or a related discipline or equivalent experience.
• Must be legally authorized to work in the United States without company sponsorship, now or in the future.

Nice To Haves

• Familiarity with AI-powered analytics and productivity tooling is a plus.

Responsibilities

• 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.

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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level