Data Analyst

PPC Partners Inc.•Tucker, GA

About The Position

We are seeking a talented Data Analyst to join our BI & Analytics team. This role will be instrumental in building and managing Power BI reporting solutions on top of our Snowflake data Lakehouse platform. The ideal candidate will bridge the gap between business stakeholders and our technical data infrastructure, transforming complex datasets into actionable insights that drive strategic decisions across our organization. At PPC Partners we believe in the Power to Serve along with the Pursuit of Excellence. As such the following values guide our behaviors: A Servant’s Heart – Focus on the Needs of Others, Wisdom – Insightful, Integrity – Honesty and Trustworthy, Courage – Decisive and Confident in Others, Humility – Modest and Respectful, Passion – Unfailing Dedication

Requirements

Bachelor's degree in Finance, Economics, Management Information Systems, Statistics, Data Analytics, or equivalent quantitative field
2-5 years of experience in data analysis, business intelligence, or related analytical roles
Proven track record of delivering business-impacting analytical solutions and managing stakeholder relationships
Power BI: Strong proficiency in Power BI Desktop and Power BI Service including data modeling (star schema, relationships), DAX measures, interactive dashboard development, performance optimization, and report deployment
SQL & Python for Data Analysis: Extract and analyze data using SQL queries against Snowflake datasets and Python (Pandas, NumPy) for advanced data manipulation; develop automation scripts for repetitive data processing, perform data quality validation, and create reusable analytical workflows that support Power BI reporting and ad-hoc business analysis
Snowflake: Experience working with Snowflake data warehouse, understanding of cloud data platforms, and ability to query large-scale datasets efficiently
Excel: Advanced Excel capabilities including pivot tables, VLOOKUP/XLOOKUP, complex formulas, and data visualization
Data Analysis: Strong foundation in statistical analysis, data cleaning, data validation, and exploratory data analysis techniques
Positive safety attitude and personal integrity – both are non-negotiable
Analytical Thinking: Ability to break down complex business problems, identify root causes, and develop data-driven solutions
Communication Skills: Excellent written and verbal communication skills with ability to explain technical concepts to non-technical stakeholders and present insights clearly through visualizations and narratives
Problem Solving: Creative approach to overcoming data challenges, troubleshooting reporting issues, and finding solutions within technical constraints
Attention to Detail: High degree of accuracy in data analysis, quality validation, and documentation with commitment to delivering reliable insights
Stakeholder Management: Proven ability to manage multiple stakeholder relationships, balance competing priorities, and deliver results under deadlines
Self-Motivation: Ability to work independently, take ownership of projects, and drive initiatives to completion with minimal supervision
Strong team orientation with willingness to share knowledge, support colleagues, and contribute to collective success
Positive attitude and constructive approach to feedback, challenges, and change
Ability to build effective working relationships across technical and business teams
Genuine enthusiasm for working with data and turning complex information into clear business insights
Commitment to staying current with evolving BI tools, analytical techniques, and industry best practices
Curiosity to explore new technologies and methodologies that can enhance team capabilities and business value
Demonstrated commitment to delivering high-quality work that meets business objectives and exceeds stakeholder expectations
Ownership mindset with accountability for analytical accuracy, report performance, and solution reliability
Drive to make measurable impact on business outcomes through data-informed insights and recommendations

Nice To Haves

Experience with Oracle ERP systems (IFS or similar) and understanding of construction industry financial processes
Familiarity with dbt transformation frameworks and modern data stack technologies
Knowledge of Azure Data Factory, data pipeline concepts, or ETL/ELT processes
Experience working in Agile Scrum teams using tools like Jira or Azure DevOps
Understanding of construction project accounting, WIP reporting, revenue recognition, or similar domain expertise

Responsibilities

Partner with business stakeholders across business departments to gather requirements, define KPIs and metrics, and translate business needs into functional specifications
Facilitate alignment between technical teams and business objectives through clear communication, requirements documentation, and stakeholder expectation management
Conduct stakeholder meetings to prioritize analytical requests, manage timelines, and ensure deliverables meet business impact objectives
Own the full lifecycle of Power BI reporting from requirements gathering, data discovery, and semantic model design through DAX development, visualization creation, testing, deployment, and ongoing performance optimization
Build interactive dashboards with advanced features including slicers, drill-through, bookmarks, row-level security, and conditional formatting optimized for business user engagement
Incorporate stakeholder feedback and iterate on reporting solutions to continuously improve analytical value and user adoption
Conduct complex data analysis using SQL, Python, Power BI, and Excel to uncover trends, patterns, and actionable insights that inform business decisions across construction projects, financial performance, and operational efficiency
Develop enterprise-wide KPI frameworks and performance metrics that align with organizational strategic initiatives
Proactively identify analytical opportunities that drive operational improvements, cost optimization, and revenue growth
Ensure data accuracy, quality, and governance by implementing validation rules, performing gap analysis between Oracle ERP source systems and Snowflake datasets, and establishing data quality monitoring frameworks
Maintain compliance with enterprise data policies, role-based access controls (RBAC), and multi-company data security requirements
Collaborate with data engineering teams to define data refresh frequencies, transformation logic, and handling procedures for data anomalies
Drive continuous improvement through automation of reporting workflows, development of reusable analytical frameworks and data models, and implementation of best practices for Power BI governance
Create clear technical and business documentation including data dictionaries, report specifications, user guides, and process workflows
Mentor junior team members on analytical methodologies, Power BI best practices, stakeholder management, and data modeling techniques
Work collaboratively within a matrixed team structure with data engineers, business analysts, and IT professionals to deliver integrated analytics solutions
Participate actively in team planning sessions, sprint retrospectives, and knowledge-sharing activities to foster continuous learning and improvement
Contribute to the development of team standards, templates, and shared resources that enhance overall team productivity
Pre-plan and identify the methods to eliminate hazards daily by work task.
Execute skill in observing habits and hazards of others and bringing it to their attention.
Uphold safety as the most important goal of our company. Support goal of achieving zero accidents.
Promote and encourage open communication between field and office regarding all safety concerns, suggestions, improvements, and PPE needed.
Obtain safety training as expected by all company personnel.