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 Senior Data Analyst - SQL 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 as an embedded expert in the Customer Experience team at Salesforce supporting data query requests from various business unit leaders across the organization. You’ll help bring together feedback and operational data to uncover actionable insights and support the development of CX processes across the Salesforce ecosystem. This will include 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
• Crafting and executing SQL queries based on business requirements
• Query and analyze large datasets from multiple internal sources to understand customer sentiment, behaviors, and trends
• Build repeatable data workflows and reporting processes to support CX initiatives
• Partner with cross-functional teams to validate data sources and business logic
• Translate raw data into clear insights and recommendations for the Customer Experience team and broader stakeholders
• Build ad-hoc reports, dashboards and data visualizations to track key metrics
• Collaborate with the CX team and Salesforce platform owners to define how customer feedback is captured, stored, and routed
• Learn to leverage Salesforce-native tools (Reports & Dashboards, Flows, Automation) to deliver insights and improve CX visibility

Requirements:

• BA/BS in Computer or Information Science, Statistics, Math, or a related field. MA/MSc –An advantage
• 3-5 years proven experience writing advanced SQL scripts (stored procedures, joins, functions, views, etc.)
• Proven ability to work with large and complex datasets, and to distill insights for business use
• Comfortable with data visualization and reporting tools (e.g., Tableau, Power BI, Excel)- strong advantage
• Strong communication and collaboration skills
• Experience with any of the following platforms – An advantage:
• SQL Server, MySQL, Postgres, and MongoDB
• Strong attention to detail
• Exceptional documentation skills and practices
• Experience in implementing operational automation scripts – An advantage
• CX experience – An advantage
• Salesforce experience - An advantage