Offer summary

Qualifications:

Proficiency in SQL and experience with data manipulation and reporting., Strong analytical skills with the ability to interpret complex data sets., Experience in communicating with stakeholders to gather requirements., Familiarity with various data environments and technologies..

Key responsabilities:

Communicate with business stakeholders to collect data requirements.

Write and execute SQL queries to retrieve and manipulate data.

Pull, combine, and clean data from multiple sources for reporting.

Maintain and develop queries to ensure data integrity and performance.

Job description

OGC is a boutique research and consulting agency specializing in data-driven strategy, market research and analytics, and Customer Experience (CX) program design and optimization. We work with some of the world’s largest organizations across a variety of industries, including Telecommunications, Financial Services, Specialty Retail, Hospitality and Software, helping them to gain a deep understanding of their customers, develop actionable insights, and improve business processes.

We are seeking a full-time SQL Data Analyst to join our team. This role provides a great opportunity for a curious, self-starter to become part of a high-performing team, and implement a hands-on approach to data exploration, manipulation, and reporting.

About the role

You will work closely with one of our key clients, supporting data query requests from various business unit leaders across the organization. This includes identifying available data sources, understanding where and how the data is stored, writing SQL queries to retrieve the necessary information, and exporting and refining datasets to meet specific business needs. This is a full-time, remote role.

Responsibilities:

Communicating with different business stakeholders to collect requirements
Communication with different technical leads and gathering existing data
Handling multiple data environments
Maintaining and developing queries and procedures to ensure the integrity and performance of projects
Pulling, combining, and cleaning data from multiple sources
Creating ad-hoc reports utilizing various data sources
Maintaining current knowledge of relevant technologies
Manipulating and curating different data formats and structures
Crafting and executing SQL queries based on business requirements