Data Analyst SQL

Summary

Join OGC, a research and consulting agency specializing in data-driven strategy, market research, and customer experience (CX), as a full-time Data Analyst - SQL. You will work closely with a key client, supporting data query requests from various business unit leaders. This role involves identifying data sources, understanding data storage, writing SQL queries, and exporting refined datasets to meet specific business needs. This is a remote position.

Requirements

• BA/BS from a top university with outstanding grades, preferably in Computer or Information Science, Statistics, Math, or a related field
• 2 years of experience writing complex SQL scripts (stored procedures, functions, views, etc.)
• Must have demonstrated experience working with Teradata SQL
• Strong attention to detail
• Flexibility working with different data formats
• Exceptional documentation skills and practices

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

Preferred Qualifications

• MA/MSc –An advantage
• Experience with the following platforms – An advantage
• Trino SQL platform
• AWS S3 Cloud Storage platform
• MinIO/Kubernetes
• SQL Server, MySQL, Postgres, and MongoDB
• Experience in implementing operational automation scripts – An advantage
• Tableau or any BI tools (Power BI, Qlik, etc.)- An advantage
• Exposure to different types of data e.g market research, telecommunications - An advantage
• CX experience – An advantage
• Salesforce experience - An advantage