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
Senior Product Analyst supporting Qonto in data - informed decision making for SMEs growth. Collaborating with Product Managers to drive product strategy and experimentation.
Data Analytics Associate reviewing and approving analytics on large data sets to inform business initiatives at TIAA. Ensuring data quality and developing reports to enhance decision - making.
Junior Network Data Analyst assisting with network support for IT consulting company. Monitoring network performance and troubleshooting connectivity issues while collaborating with teams in diverse projects.
Data Analyst in Network squad focusing on demand forecasts and model performance analysis at Relay. Investigating errors and building dashboards to enhance operational efficiency.
Senior Customer Insights Expert at Smile, bridging data and human experience for an international financial institution. Conduct thorough analysis and convey customer insights effectively.
Consumer Data Analyst at Bulk analyzing customer insights and behavior across sports nutrition landscape. Collaborating with marketing teams to drive consumer - centric decisions with data.
Junior Data Analyst managing data pipelines for operations, finance, and customer experience teams at Tails.com. Aiding in data quality, availability, and identifying opportunities for improvements.
Quantitative Analyst developing stock selection models for systematic and fundamental investment strategies at Columbia Threadneedle Investments. Collaborating with analysts and portfolio managers to enhance research and analytics platforms.
Financial Analyst managing project budgets and financial tracking at Ameriprise India LLP. Supporting accurate reporting and insights using SQL, Power BI, and Jira.
Manager, Data Analytics & Reporting overseeing enterprise - wide data strategy and analytics functions at the Condominium Authority of Ontario. Leading a high - performing team to enhance business performance with data - driven insights.