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 Analyst to join the Business Intelligence Team. This position will work to create end to end solutions, helping clients organize, structure and visualize their marketing data in a way that delivers value and actionable insights. Key responsibilities will include:

• Create, prepare, and maintain databases and tables to power reports, dashboards, and downstream analysis.
• Design and build dashboards that enable actionable insight.
• Plan, design and develop a dashboard project end-to-end including data preparation and dashboard development.
• Interpret results and make recommendations for data-driven marketing decisions

What you will be doing

• Build and maintain dashboards to support analysis, reporting, and performance
• optimization.
• 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.
• Analyze and interpret marketing performance via dashboards and ad hoc analysis.
• Manage multiple client requests and detailed project activities at any one time to ensure accurate, timely and efficient reporting and analysis deliverables.

Data visualization and SQL skills are critical for this Business Intelligence role. Consideration will be given to qualified candidates with varying levels of experience, with compensation commensurate with experience.

What we are looking for

• Advanced SQL knowledge
• Deep experience with business intelligence and visualization tools such as Tableau, PowerBI, Quicksight, Qlik, Datorama, Domo and/or Looker
• Working with 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
• Developing and implementing data transformation via ETL processes and data pipelines
• Understanding of marketing analytics or CRM analytics
• 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

Other experience that is helpful, but not required

• Working with enterprise ETL software such as Databricks, Alteryx, Tableau Prep
• Working knowledge in at least one of the following scripting languages: Python or R
• Working in big data solutions such as Hadoop, Hive, Spark
• Experience using MailChimp or other CRM platforms
• Using change release processes and tools such as Git
• Working with clickstream web analytics tools such as Adobe Analytics, Google Analytics, or working knowledge of the field of web analytics
• Knowledge of commonly-used digital metrics, analytic concepts, and online

Job specifications

• Employment type: Full-time permanent employment with Concord.
• Location: Hybrid (1-2 days on-site) in the Kansas City area is preferred. Open to remote in other US cities.
• Interview process: (1) introductory call, (2) take-home assessment, and (3) interview with the hiring manager.
• Requirements: Must be legally authorized to work in the United States without company sponsorship now or in the future.