Business Intelligence Developer

$37,000 - $101,000/Yr

Evolytics - Kansas City, MO

Full-time - Entry Level

Remote - Kansas City, MO

Professional, Scientific, and Technical Services

About the position

The Business Intelligence Developer at Concord is responsible for data preparation and dashboard development, focusing on transforming raw data into actionable insights. This role requires strong SQL and Python skills, along with experience in creating visually compelling dashboards. The developer will work within a hybrid model, contributing to the BI team to enhance customer experiences and optimize operations through effective data solutions.

Responsibilities

• 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.
• Develop and implement data transformation processes (ETL) using tools like Databricks or Alteryx.
• Leverage expertise in cloud-based data solutions like AWS, Snowflake, Azure, or Google Cloud.

Requirements

• At least 2 years of experience as a Business Intelligence Developer or in similar roles.
• Experience in scripting for automation (e.g. Python) and advanced SQL skills.
• Strong technical skills in database management systems and BI technologies such as Tableau, PowerBI, and Qlik.
• Experience in developing and implementing data transformation via ETL processes and data pipelines, including experience in ETL software such as Databricks and/or Alteryx.
• Experience working within AWS, Snowflake, Azure or Google Cloud cloud-based data solutions.
• Experience with leading analytics or relational database systems, such as Redshift, Vertica, BigQuery, PostgreSQL, Microsoft SQL Server, or MySQL.
• Excellent interpersonal, communication, listening and presentation skills.
• 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.