Data Analyst at Atwellgroup

Who We Are Atwell, LLC is a bold leader in the consulting, engineering, and construction services industry, delivering a broad range of creative solutions to clients in the real estate & land development, and energy markets. We have a strong national presence and a diverse, award-winning project portfolio. Atwell is a privately owned company, with 2,000+ passionate team members across 70+ locations and growing! Atwell, LLC is a proud recipient of the following 2025 awards: • Ten consecutive years in a row as a “Best Place to Work” by Zweig Group (#11) • Recognized as #70 in the ENR Top 500 Design Firms, ranked in every region • Recognized in Crain's “Fast 50” as one of the fastest-growing companies (#14) • Recognized as the 2025 ENR Design Firm of the year for the Southeastern US JOB SUMMARY The Data Analyst is responsible for analyzing, modeling, and interpreting complex datasets to support decision-making across the civil engineering organization. This role focuses on leveraging data from Deltek Vision/Vantagepoint, the Microsoft technology stack, and Power BI to develop predictive models, dashboards, and analytical insights that enhance project performance, financial forecasting, resource planning, and operational efficiency. In addition to supporting project, financial, and operational analytics, this role also provides analytical support for Human Resources initiatives, including workforce reporting, talent metrics, and HR data insights that inform organizational planning and employee experience strategies. In this role, an employee will be expected to develop and demonstrate proficiency regarding the essential functions of the job listed below. ESSENTIAL FUNCTIONS • Extract, analyze, and model data from Deltek Vision/Vantagepoint, Microsoft SQL Server, and other enterprise systems. • Design, build, and maintain Power BI dashboards and data visualizations that deliver actionable insights to project managers, financial teams, and leadership. • Develop predictive models and statistical analyses to support forecasting, project risk identification, and operational decision-making. • Create and maintain scalable data pipelines and ETL processes using Microsoft tools such as Power Query, SQL, Dataverse, and SharePoint integrations. • Ensure data accuracy, integrity, and consistency through rigorous validation and quality assurance processes. • Collaborate cross-functionally with engineering, project management, finance, Human Resources, and IT teams to understand business needs and develop tailored analytical solutions. • Communicate complex analytical results clearly to non-technical audiences through visualizations, summaries, and presentations. • Support data governance, security best practices, and standardization of KPIs and reporting frameworks. • Research and recommend emerging technologies or analytical techniques to advance the firm’s data capabilities. • Document analytical methods, data structures, dashboards, and models following internal documentation standards. • Partner with the Human Resources team to develop HR dashboards and metrics, recurring reporting and analytics related to workforce trends, headcount, turnover, retention, compensation insights, and talent planning, ensuring data quality and actionable interpretation of HR data. • Serve as a subject-matter expert for HRIS data structure, reporting, and integrations. KEY COMPETENCIES AND SKILLS • Proficient in Power BI, including DAX, Power Query, data modeling, and advanced visualization design. • Strong experience with SQL, including queries, stored procedures, and data modeling techniques. • Understanding of Deltek Vision/Vantagepoint data structures, reporting tables, and integration patterns. • Proficiency in statistical analysis, predictive modeling, or machine learning techniques. • Experience with Python or R for data analysis is preferred. • Familiarity with the Microsoft ecosystem: Excel, SharePoint, Teams, Power Automate, Azure-based tools. • Strong analytical and problem-solving skills with the ability to approach technical and business challenges methodically. • Ability to translate business requirements into technical solutions and data-driven recommendations. • Excellent communication skills (verbal and written), including the ability to present findings to varied audiences. • Ability to work independently and collaboratively in a team-oriented environment. EDUCATION • Bachelor’s Degree in Data Science, Statistics, Computer Science, Engineering, Information Systems, or related field required. • Master’s Degree preferred. EXPERIENCE • 3–7 years of experience in data analytics or data science, preferably within the AEC (Architecture, Engineering & Construction) industry. • Experience supporting enterprise analytics using Deltek Vision/Vantagepoint strongly preferred. • Demonstrated experience with Power BI dashboard development and data modeling. • Experience working with SQL databases and building data pipelines or ETL processes. • Familiarity with predictive analytics, forecasting, or machine learning models is a plus. • Experience using the Microsoft suite, including Excel, SharePoint, and Power Automate. Pay Range $1—$1 USDAtwell Benefits: To attract and retain the best professionals in the industry, we aim to provide an excellent working environment and a progressive benefits program designed to support your personal and professional needs. Work/Life: • Generous Paid Time Off • Paid Parental Leave • Flexible work schedules are available for some positions • Tenure Awards — Travel Vouchers to see the world based on your travel preferences Compensation: • Competitive Compensation packages • Annual bonuses, spot bonuses and peer recognition awards • 401K match - 1:1 up to 4% of compensation • Tuition Assistance • Student Loan Repayment • Paid Licensing / Certification Fees and Renewals • Financial Rewards for Obtaining Licensure • Employee Referrals • Annual Wellness Reimbursement for anything wellness related (Gym memberships, fitness tracker, home gym equipment, etc.) • Dependent Care Match ‘Atwell’ness: • Medical (BC/BS), Dental (Delta), and Vision (VSP) • Family Planning & IVF Benefits • Pet Insurance • Health Savings Account & Flex Spending Account options • Employer paid LTD, STD, and life insurance • Metlife Supplemental Benefits covering accident, hospitalization, and critical illness • Member Assistance Program (MAP) with complimentary counseling sessions, legal benefits, financial consultations, and work/life referral services