Senior Data Analyst

OAKS OF BASTROP, LP
Chicago, IL, United States
25 days ago
Apply on www.indeed.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Compensation
$115,000.0 - $119,051.0
Working hours
Regular working hours
Job source

Tech stack

Microsoft Excel A/B Testing Agile Methodology Amazon Web Services Data Analysis Confluence JIRA Microsoft Azure Collaborative Software Information Systems Data Validation Data Cleansing
+34 more
Data Governance Extract Transform Load (ETL) Data Transformation Data Normalization Data Profiling Data Visualization Data Warehousing Relational Databases Database Queries Executive Information Systems Statistical Hypothesis Testing Python (Programming Language) Meta-Data Management NumPy Pivot Tables Query Optimization Power BI Cloud Services SQL Databases Tableau (Software) Freeform SQL Snowflake Git Powerquery Pandas Scikit Learn Information Technology Data Lineage Data Analytics Google Bigquery Data Management Data Pipelines Amazon Redshift Databricks

Job description

We are seeking an experienced Senior Data Analyst to transform complex business data into actionable insights that support strategic planning, operational performance, and informed decision-making. This role will partner with business leaders, product teams, finance, operations, technology, and other stakeholders to define analytical requirements, develop meaningful performance measures, and identify trends, risks, and opportunities. The Senior Data Analyst will take ownership of analytical projects from requirements gathering and data validation through analysis, visualization, and presentation of findings. The position requires strong technical expertise in SQL, data visualization, statistical analysis, and business intelligence tools, combined with the ability to communicate findings clearly to technical and non-technical audiences. The successful candidate will contribute to reporting standards, data quality initiatives, process automation, forecasting, and continuous improvement of analytical capabilities. This is an opportunity to influence business outcomes through rigorous analysis while working across teams on high-impact initiatives., * Analyze large and complex datasets using SQL, Python, statistical methods, and analytical techniques to identify trends, patterns, risks, and business opportunities.

  • Partner with stakeholders to define business questions, analytical requirements, success measures, reporting needs, and data-driven recommendations.
  • Develop and maintain executive dashboards, operational reports, KPI scorecards, and interactive visualizations using Power BI, Tableau, or comparable business intelligence platforms.
  • Write advanced SQL queries using joins, common table expressions, window functions, aggregations, subqueries, and data transformation techniques.
  • Perform data profiling, cleansing, validation, reconciliation, and quality assessments to ensure analytical outputs are accurate and reliable.
  • Develop statistical analyses, forecasts, segmentation models, cohort analyses, and other analytical solutions supporting business planning and performance management.
  • Translate analytical findings into clear presentations, recommendations, reports, and business narratives for senior leaders and cross-functional stakeholders.
  • Monitor key performance indicators and investigate significant variances, anomalies, changes, and emerging business trends.
  • Collaborate with data engineers and technology teams to define data requirements, improve analytical datasets, and support data pipeline enhancements.
  • Support experimentation, A/B testing, customer segmentation, process analysis, and quantitative evaluations of business initiatives.
  • Identify opportunities to automate recurring reports, manual analysis, and data preparation processes using SQL, Python, Power BI, Tableau, or workflow automation tools.
  • Establish standardized reporting definitions, analytical methodologies, documentation, business rules, and data interpretation guidelines.
  • Contribute to data governance and quality initiatives by documenting data sources, definitions, lineage, assumptions, and analytical processes.
  • Lead analytical projects independently, manage competing priorities, communicate project status, and deliver high-quality insights within established timelines.

Requirements

  • Bachelor’s degree in Data Analytics, Statistics, Mathematics, Computer Science, Economics, Business Analytics, Information Systems, or a related quantitative discipline; master’s degree preferred.
  • 5 or more years of professional experience in data analytics, business intelligence, quantitative analysis, reporting, or a related analytical role.
  • Advanced proficiency in SQL, including complex queries, data aggregation, common table expressions, window functions, query optimization, and data transformation.
  • Strong Python skills with practical experience using pandas, NumPy, scikit-learn, or comparable data analysis libraries.
  • Demonstrated experience developing business intelligence dashboards and reports using Power BI, Tableau, or comparable data visualization platforms.
  • Experience working with relational databases, cloud data platforms, and data warehouses such as Snowflake, Microsoft Azure, Amazon Redshift, Google BigQuery, Databricks, or comparable technologies.
  • Knowledge of statistical analysis, forecasting, regression, hypothesis testing, experimentation, segmentation, and quantitative modeling techniques.
  • Experience with data preparation, ETL/ELT concepts, data validation, data quality processes, and analytical data pipelines.
  • Advanced Microsoft Excel skills, including formulas, pivot tables, Power Query, data modeling, and analytical reporting.
  • Understanding of data governance, metadata management, data lineage, master data concepts, data quality, and business intelligence reporting standards.
  • Familiarity with Agile methodologies and collaboration tools such as Jira, Confluence, Git, Microsoft Teams, or comparable platforms.
  • Strong business acumen with the ability to connect analytical findings to operational performance, financial outcomes, customer metrics, and strategic objectives.
  • Excellent written and verbal communication skills with the ability to present complex analytical findings clearly to senior leadership and cross-functional stakeholders.
  • Preferred certifications include Microsoft Certified: Power BI Data Analyst Associate, Tableau certifications, Google Professional Data Engineer, AWS Certified Data Analytics, Databricks certifications, or comparable credentials. Candidates must be legally authorized to work in the United States.

Benefits & conditions

Pulled from the full job description

  • Professional development assistance
  • Health insurance

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.indeed.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:09 min

Balancing data science skillings alongside systems engineering rigor

Nico Schmidt · LIVE

6:21 min

Investigating push inefficiencies with upstream Git experts

Jonathan Creamer · Coffee With Developers

3:05 min

Integrating an assistant application with Jira software

Felix Augenstein · LIVE

2:34 min

Maximizing execution memory effectively via python numpy broadcasting

Jodie Burchell · LIVE

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

56 sec

Favorite git commands and the importance of patch commits

Eileen Uchitelle Eileen Uchitelle +1 · Coffee With Developers

Videos

See all

Related articles

See all