Data Analyst

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 #J-18808-Ljbffr CredX