Business Intelligence Developer

Concord Agency - Parkville, MO

Full-time - Entry Level

Remote - Parkville, MO

Credit Intermediation and Related Activities

About the position

The Business Intelligence Developer at Concord will play a crucial role in enhancing customer experiences and optimizing operations through data-driven insights. This position focuses on data preparation and dashboard development, requiring strong SQL and Python skills to transform raw data into actionable insights and visually compelling dashboards.

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 a leading analytics or relational database system, 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.