Business Intelligence Engineer

Business Intelligence Engineer 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. 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. What you will be doing: 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. What we are looking for: 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. What we offer (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. Additional information: 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! Concord