Data Analyst

CPA Connections; Chicago (IL); On-site; USD 70,000 - 90,000; Full time

Job summary

CPA Connections in Chicago, Illinois, is seeking a Data Analyst with over 2 years of experience. The ideal candidate will have strong skills in Python, SQL, BigQuery, and data visualization tools such as Tableau and Grafana. Responsibilities include data cleaning, modeling, and optimizing reporting accuracy.

Qualified applicants should possess a M.S. in Computer Science and demonstrate a proven ability to reduce ad campaign costs and improve data accuracy through effective ETL processes.

Qualifications

• 2+ years of experience in data analysis.
• Skilled in ETL, data cleaning, and pipeline monitoring.
• Proven track record of optimizing ad campaigns.

Skills

Python

SQL

BigQuery

Tableau

Grafana

Education

M.S., Computer Science, Illinois Institute of Technology

Job description

Data analyst with 2+ years of experience in Python, SQL, BigQuery, Tableau, and Grafana. Skilled in ETL, data cleaning, modeling, visualization, and pipeline monitoring. Key achievements include improving reporting accuracy by 25% through data cleaning and deduplication, reducing ad campaign costs by 15% via SQL-driven optimization, and identifying drugs with up to 75% deviation in adverse event spikes for early safety intervention.

Education

• M.S., Computer Science, Illinois Institute of Technology

Core Expertise

• Python, SQL, BigQuery, Tableau, Grafana
• ETL, Data cleaning, Modeling, Visualization, Pipeline monitoring