Business Intelligence Engineer

About Us

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.

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

• 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 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 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, including
  
  Snowflake, Databricks, AWS, Azure, or Google Cloud.
• Strong technical understanding of relational and analytical database technologies such as Snowflake, Databricks, Redshift, Vertica, Big Query, 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 withAI tools and AI-assisted development/analytics workflows, such as using generative AI to support SQL development, Python,…