🕒 2 days ago
Partner with Product Owners to design experiments, analyze customer behavior, and turn complex data into actionable recommendations that shape product roadmaps and improve customer experience and business performance.
Mid-Level Data Analyst
📅 Sep 15
BI AnalyticsSQLT-SQLSpark SQL
📜 Description
- Build audience segments for email, SMS, and push campaigns, and coordinate transfers with the CRM team.
- Serve as an analytics and reporting subject matter expert for Convenience Retail, Major Oil, promotional services, and mobile payments.
- Gather customer needs and translate them into requirements for custom analytics solutions.
- Design, develop, test, and maintain BI reports, dashboards, and visualizations.
- Write and tune SQL to prepare, transform, and validate reporting and audience data.
- Investigate data discrepancies, create requested reports and extracts, and add insights to distributed reports.
🛠️ Requirements
- Strong self-starter with high learning agility
- Great professional attitude, people skills, strong drive, and passion
- Strong analytical skills
- Strong problem-solving skills, with a demonstrated ability to automate manual and repetitive processes
- 3–5 years of BI/Analytics experience
- 3–5 years' experience on a BI or analytics team with a good understanding of BI principles, architecture, best practices, processes, and standards
- Strong knowledge of SQL, including T-SQL (SQL Server / Synapse) and Spark SQL (Databricks)
- Working knowledge of the Azure data platform (Azure Synapse, Databricks, ADLS Gen2) and SQL Server
- Exposure to ETL/orchestration tools such as Azure Data Factory and Databricks Workflows (Jobs)
- Excellent oral and written communication skills
✨ Benefits
- Competitive salary
- Market-competitive benefits
- Quarterly perks program
- Ample time off
- Hybrid working arrangements where appropriate
- Continuous learning opportunities
- Professional certifications
- Leadership development opportunities
Full job description
At PDI Technologies, we empower some of the world's leading convenience retail and petroleum brands with cutting-edge technology solutions that drive growth and operational efficiency. By “Connecting Convenience” across the globe, we empower businesses to increase productivity, make more informed decisions, and engage faster with customers through loyalty programs, shopper insights, and unmatched real-time market intelligence via mobile applications, such as GasBuddy. We’re a global team committed to excellence, collaboration, and driving real impact. Explore our opportunities and become part of a company that values diversity, integrity, and growth.
The Data Analyst will work with analytics, marketing, and business leaders, other analysts, developers, architects, project managers, and stakeholders to design, develop, and deliver custom reporting and analytics solutions for customers in the Convenience Retail and Major Oil verticals, including the analytics that support mobile payments for fuel and convenience stores.
The Data Analyst will act as the SME for the Convenience Retail and Major Oil businesses and the analytics needs of these verticals. They will be responsible for interfacing with customers to understand their needs, designing and developing the technical solutions to meet these needs, overseeing external resources to ensure timely delivery of commitments, unit testing the analytics solutions, and documenting the developed solutions. They will also be responsible for keeping these BI solutions tuned for optimal performance on the Azure data platform on an ongoing basis. This role will also work closely with marketing and CRM teams to help build and supply audiences for campaigns that will subsequently be measured for effectiveness.
Responsibilities
• Build audience segments used for targeted communications/campaigns across Email, SMS, and push messaging campaigns
• Work with the CRM team to manage audience transfers to the consumer marketing platform (Salesforce Marketing Cloud)
• Function as the SME for the Convenience Retail and Major Oil verticals, the guided analytics and reporting solutions for these customers, and any custom analytics being built for customers
• Function as the SME for the reporting associated with promotional services
• Support the reporting and analytics for mobile payments across fuel and convenience, building the data assets, dashboards, and metrics that track adoption, transaction activity, and program performance
• Act as a general analytics and visualization SME
• Interface with customers to understand their needs and translate them into requirements
• Design, develop, test, and maintain BI reports, dashboards, and visualizations in Sigma Computing and Power BI
• Write and tune SQL (T-SQL and Spark SQL) to prepare, transform, and validate data supporting reporting and audience-building
• Work with other team members to ensure that reports, templates, and dashboards meet business requirements
• Assist the analytics leadership team and the operations analyst with service design, development, and delivery of new services as needed • Research and recognize data issues and discrepancies represented in reports; perform the necessary validation
• Create one-time reports and data extracts per request
• Understand the underlying data structures well enough to build new reports independently
• Add informative insight and analysis to distributed reports
Requirements
• Strong self-starter with high learning agility
• Great professional attitude, people skills, strong drive, and passion
• Strong analytical skills
• Strong problem-solving skills, with a demonstrated ability to automate manual and repetitive processes
• 3–5 years of BI/Analytics experience
• 3–5 years' experience on a BI or analytics team with a good understanding of BI principles, architecture, best practices, processes, and standards
• Strong knowledge of SQL, including T-SQL (SQL Server / Synapse) and Spark SQL (Databricks)
• Hands-on experience with Sigma Computing and Power BI (including DAX); exposure to Tableau a plus
• Working knowledge of the Azure data platform (Azure Synapse, Databricks, ADLS Gen2) and SQL Server
• Exposure to ETL/orchestration tools such as Azure Data Factory and Databricks Workflows (Jobs)
• Exposure to payments or mobile payments data (e.g., transaction and authorization data) a plus
• Excellent oral and written communication skills
Applicants must be legally authorized to work in the United States without employer sponsorship, now or in the future.
Similar jobs
Search more Data Analyst jobs
🕒 2 days ago
Atue como referência estratégica em performance, dados e IA, criando agentes conversacionais, automatizando processos e transformando análises em insights e dashboards para orientar pilotos e decisões de negócio.
🕒 2 days ago
Manage the Radio Observador schedule and podcast distribution, while analyzing audience performance to identify effective formats, timings, and ad placements and presenting actionable insights to editorial teams.
🕒 4 days ago
Analisa dados do canal de e-commerce omnichannel, desenvolve modelos de mensuração e dashboards, mantém a governança de dados e automatiza pipelines para apoiar decisões e melhorias de negócio.
ANALISTA DE GOVERNANÇA DE DADOS PL
🕒 4 days ago
Stefanini Group👥 5001 - 10,000 employees🏢 Management Consulting
🕒 4 days ago
Conecta Analytics e áreas de negócio para governar indicadores, validar dados em ambientes Data Lakehouse e desenvolver soluções com IA, garantindo métricas consistentes e relatórios confiáveis.