Data Analyst - Dashboards & Analytics (Onsite Chicago)

CredX; Chicago (IL); On-site; USD 84,000 - 90,000; Full time

Benefits offered by this job

401(k) matching

Dental insurance

Health insurance

Visa sponsorship

Flextime

Paid time off

Professional development support

Job summary

CredX in Chicago is hiring a Data Analyst to turn large, multi-source datasets into actionable dashboards and reports for informed decision-making. This onsite role centers on data-driven storytelling and stakeholder collaboration to support product, operations, and strategic initiatives.

You will write SQL, validate data quality, and build metrics and KPI reporting across BI tools, while partnering with engineering and business teams to improve data pipelines and governance.

Qualifications

• Bachelor’s or Master’s degree in a quantitative field.
• 3–5 years of professional experience as a data analyst or in a similar analytical role.
• Advanced proficiency in SQL, including joins, window functions, CTEs, aggregations, and query optimization.
• Strong experience with Microsoft Excel, including PivotTables, Power Query, and advanced formulas.
• Hands-on experience with BI and data visualization tools such as Tableau, Power BI, Looker, or similar platforms.
• Experience transforming raw data into actionable business insights.
• Strong understanding of data modeling, relational databases, and data warehousing concepts.
• Proficiency in Python or R for data analysis and scripting.

Responsibilities

• Collect, clean, validate, and analyze large datasets from multiple sources.
• Develop and maintain dashboards, reports, and visualizations for operations and strategy.
• Analyze performance, behavior, metrics, and product performance to surface trends, opportunities, and risks.
• Partner with stakeholders to translate questions into data-driven insights.
• Run ad hoc analyses to support initiatives and executive decisions.
• Create recurring reports and automate reporting processes for efficiency.
• Write SQL queries to extract, transform, and analyze data from relational databases.
• Validate data accuracy, identify anomalies, and ensure reporting consistency.
• Define, monitor, and maintain KPIs and business metrics.
• Build interactive dashboards to communicate insights effectively.
• Perform exploratory data analysis to identify patterns and opportunities.
• Support A/B testing, experimentation, and measurement initiatives.
• Collaborate with data engineering to improve pipelines and models.
• Document definitions, logic, and methods; present findings clearly to non-technical audiences.
• Identify opportunities to improve business processes using data.

Skills

SQL proficiency

Excel advanced

Tableau

Power BI

Looker

Python

R

Data cleaning

Statistical analysis

Data visualization

Education

Bachelor’s or Master’s degree in a quantitative field

Tools

Tableau

Power BI

Looker

Snowflake

BigQuery

Redshift

Azure Synapse

Databricks

dbt

Apache Airflow

Git

Job description

CredX in Chicago is hiring a Data Analyst to turn large, multi-source datasets into actionable dashboards and reports for informed decision-making. This onsite role centers on data-driven storytelling and stakeholder collaboration to support product, operations, and strategic initiatives.

You will write SQL, validate data quality, and build metrics and KPI reporting across BI tools, while partnering with engineering and business teams to improve data pipelines and governance.