Benefits:
Competitive salary
Dental insurance
Flexible schedule
Health insurance
Opportunity for advancement
Vision insurance
Seasoned Data Analyst with a strong background track record in leveraging BigQuery to drive data-driven insights and inform strategic decision-making. The ideal candidate will have a strong foundation in data analytics, SQL, and a deep understanding of Google BigQuery's capabilities. This role will play a pivotal part in extracting meaningful insights from our vast datasets, enabling us to optimize operations, identify trends, and unlock new opportunities. This is a full time hybrid Chicago, IL, long-term position.
Data Analysis:
Experience working with large-scale datasets and complex data structures.
Experience working with data migrated from SAP applications with underlying Oracle databases.
Develop and execute complex SQL queries to extract, transform, and analyze large datasets in BigQuery.
Conduct in-depth data analysis to identify patterns, trends, and anomalies.
Create visualizations (e.g., dashboards, charts) to communicate findings effectively to stakeholders.
Proficiency in data visualization tools (e.g., Looker).
Data Modeling:
Strong understanding of data warehousing and data modeling concepts.
Design and implement data models that optimize query performance and data accessibility.
Collaborate with data engineers to ensure data quality and consistency.
Stakeholder Communication:
Clearly communicate findings and recommendations to both technical and non-technical audiences.
Build strong relationships with stakeholders to understand their needs and priorities
Candidate requirements
3+ years leveraging BigQuery to drive data-driven insights and inform strategic decision-making
Expertise in writing and optimizing complex SQL queries.
Familiarity with SAP application data
Familiarity with Oracle database
Strong analytical skills to identify trends and patterns in large datasets.
Deep familiarity with Google BigQuery's functions and data processing capabilities.
Ability to design efficient data models for performance optimization.
Proficiency with tools like Looker for creating dashboards and visual reports.
Effectively present findings to both technical and non-technical stakeholders.
Flexible work from home options available.