Senior Data Analyst

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 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 working with a client in the US and therefore, work schedule will follow US holidays.

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
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