Supports the development of performance marketing projects in a flexible, collaborative environment at Northern Trust. Engages in cross - functional teamwork and utilizes analytics to enhance campaign performance.
About the role
- Technical Data Analyst ensuring quality of content data through SQL development and analytics reporting at GHX. Collaborating in an Agile/Scrum environment with cross-functional teams.
Responsibilities
- Write and optimize complex SQL queries including nested joins, temp tables, aggregations, window functions, and CTEs
- Identify patterns and relationships to evaluate, maintain, and enrich data quality across multiple systems and data sources
- Perform root cause analysis (RCA) and impact analysis to identify data quality issues and report findings to stakeholders
- Develop flexible, reusable, and efficient SQL code with minimal supervision while adhering to best practices
- Create and maintain analytics reports and dashboards for business stakeholders using modern BI tools
- Conduct data profiling and data quality validation to ensure high-quality data for downstream consumers
- Perform code reviews on SQL and data scripts, providing constructive feedback to ensure quality
- Collaborate with cross-functional teams including data engineering, product, and analytics teams in an Agile/Scrum environment
Requirements
- Bachelor’s degree in Computer Science, Data Science, Information Systems, or related degree
- 5+ years of experience writing complex SQL queries including nested joins, temporary tables, aggregations, subqueries, window functions, and CTEs
- 5+ years of experience with relational databases (PostgreSQL, SQL Server, MySQL) and SQL query performance optimization
- Experience with data profiling, data quality assessment, data validation techniques, and finding insights in large, complex data sets
- Strong analytical skills including data mining and evaluation, with demonstrated ability to perform code/query reviews in Agile/Scrum environments
Benefits
- health, vision, and dental insurance
- accident and life insurance
- 401k matching
- paid-time off
- education reimbursement
Job title
Job type
Experience level
Salary
Degree requirement
Tech skills
Location requirements
Data Analyst II focused on monitoring IoT - enabled products for Generac. Analyzing data to enhance performance and customer experience with cutting - edge energy technology solutions.
Data Analytics Intern at leading family fintech company building AI - powered reporting automation. Collaborating with Marketing Science team to deliver impactful projects for families.
Senior Revenue Analytics Analyst at Lytx transforming complex data into actionable insights. Driving go - to - market strategy across Sales, Marketing, and Customer Success to enhance revenue performance.
Data Analyst responsible for data treatment and dashboard creation for Hospital Care. Focused on utilizing data for informed decision - making in a hybrid work environment.
Data - driven Product Analytics Manager focusing on boosting customer retention and facilitating expansion. Collaborating across teams to enhance product integration and adoption metrics.
Lead Data Analyst in Internal Audit analyzing data to inform business decisions. Focusing on risk management and providing actionable insights through advanced analytics.
Data Analyst joining FINARTIX's Data Engineering Practice to conduct data analysis and develop dashboards for consulting projects in the Greek market.
Data Analyst at Devsu responsible for data collection, analysis, and generating actionable insights for strategic business decisions.
Data Analyst Intern supporting sales and business development team by analyzing data for actionable insights. Providing performance reports and collaborating with marketing to evaluate campaigns.