Data Analyst

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 is building data-driven capabilities to support business operations and strategic decision-making, and they are hiring a Data Analyst in Chicago. In this onsite role, you will work with large datasets across internal and external sources, turn findings into dashboards and reports, and help stakeholders make clearer, evidence-based decisions.

What you’ll do

• Collect, clean, validate, and analyze large datasets from multiple internal and external data sources.
• Develop and maintain dashboards, reports, and visualizations for business operations and strategy.
• Analyze business performance, customer behavior, operational metrics, and product performance to surface trends, opportunities, and risks.
• Partner with business stakeholders, product managers, engineering, finance, marketing, and operations to translate business questions into data-driven insights.
• Run ad hoc analyses to support business initiatives and executive decision-making.
• Create recurring reports and automate reporting processes to improve operational efficiency.
• Write SQL queries to extract, transform, and analyze structured data from relational databases.
• Validate data accuracy, identify anomalies, and ensure reporting consistency across systems.
• Define, monitor, and maintain KPIs and business metrics.
• Build interactive dashboards using business intelligence tools to communicate insights effectively.
• Perform exploratory data analysis to identify patterns, correlations, and business opportunities.
• Support A/B testing, experimentation, and performance measurement initiatives.
• Collaborate with data engineering teams to improve data pipelines, data models, and reporting infrastructure.
• Document business definitions, reporting logic, metric calculations, and analytical methodologies.
• Present findings and recommendations to technical and non-technical stakeholders using clear visualizations and presentations.
• Identify opportunities to improve business processes using data and analytics.
• Support compliance with organizational data governance, security, and privacy standards.
• Stay current with emerging analytics tools, technologies, and industry best practices.

Requirements

• Bachelor’s or Master’s degree in a related quantitative field (Data Analytics, Computer Science, Information Systems, Statistics, Mathematics, Business Analytics, Economics, Engineering, or equivalent).
• 3–5 years of professional experience as a data analyst or in a similar analytical role.
• Advanced proficiency in SQL, including joins, window functions, common table expressions (CTEs), aggregations, and query optimization.
• Strong experience with Microsoft Excel, including advanced formulas, PivotTables, Power Query, and data analysis techniques.
• Hands-on experience with business intelligence and data visualization tools such as Tableau, Power BI, Looker, or similar platforms.
• Experience analyzing large datasets and transforming raw data into actionable business insights.
• Strong understanding of data modeling, relational databases, and data warehousing concepts.
• Experience writing complex analytical queries and developing automated reporting solutions.
• Proficiency in Python or R for data analysis, automation, and statistical analysis.
• Experience with data cleaning, validation, profiling, and quality assurance.
• Strong understanding of descriptive statistics, hypothesis testing, trend analysis, and business performance measurement.
• Ability to interpret business requirements and translate them into analytical solutions.
• Experience creating executive dashboards, scorecards, and KPI reporting.
• Strong analytical thinking and problem-solving abilities.
• Excellent communication and presentation skills, including translating technical findings for non-technical audiences.
• Experience working in Agile or cross-functional business environments.
• Ability to manage multiple priorities while meeting project deadlines.

Technologies

• SQL, Microsoft Excel, Tableau, Power BI, Looker
• Python, R, PivotTables, Power Query
• A/B testing, ETL/ELT
• Snowflake, Google BigQuery, Amazon Redshift, Azure Synapse Analytics, Databricks
• dbt, Apache Airflow, AWS, Microsoft Azure, Google Cloud Platform
• Git, Pandas, NumPy, Jupyter Notebooks

Benefits

• 401(k) and 401(k) 5% match
• Dental insurance
• Health insurance
• Visa sponsorship
• Flextime
• Paid time off
• Professional development assistance

Location and pay

• Work location: In person, Chicago, IL
• Compensation: USD 84,196 - 90,237 per year