BI & Analytics Specialist - SQL, Power BI & Marketing Insights

PDI Technologies; Alpharetta (GA); Hybrid; USD 90,000 - 120,000; Full time

Benefits offered by this job

Hybrid work arrangements

Quarterly perks program

Continuous learning & certifications

Job summary

The Data Analyst role at PDI Technologies will partner with analytics, marketing, and business leaders to design, develop, and deliver custom reporting for Convenience Retail and Major Oil clients.

You will act as SME for these verticals, translate customer needs into technical solutions, and maintain BI dashboards in Sigma Computing and Power BI on the Azure data platform, supporting campaigns and mobile payments analytics.

Qualifications

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

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.

Skills

BI analytics

SQL (T-SQL)

Spark SQL

Power BI

Sigma Computing

Azure data platform

Communication skills

Self-starter

Learning agility

Tools

Sigma Computing

Power BI

Databricks

Tableau

Azure Data Factory

Azure Synapse

Databricks Workflows

Job description

The Data Analyst role at PDI Technologies will partner with analytics, marketing, and business leaders to design, develop, and deliver custom reporting for Convenience Retail and Major Oil clients.

You will act as SME for these verticals, translate customer needs into technical solutions, and maintain BI dashboards in Sigma Computing and Power BI on the Azure data platform, supporting campaigns and mobile payments analytics.