Business Intelligence Specialist

Ampirical Solutions LLC; Covington, Northern (KY, KY); Hybrid; USD 70,000 - 110,000; Full time

Benefits offered by this job

Salary: $39/hr + commensurate

Profit-Sharing Bonus

Medical, Dental, Vision

401(k) with 4% match

PTO: 80h vacation, 40h sick, 10 hols

Flexible Fridays off

Tuition reimbursement

Gym stipend

Wellness program

Fertility benefits

Pet insurance

Job summary

Ampirical is seeking a Business Intelligence Specialist to partner with Project Managers, Engineering Leads, and Project Controls to develop dashboards and KPI tools using Power BI, Deltek VantagePoint, and Excel. You will monitor planned vs.

actuals to maximize utilization, revenue, and ROI, while mining data for trends and delivering value-added analytics for decision-making. The role emphasizes data visualization, cross-functional collaboration, and strong SQL and Excel capabilities to

Qualifications

• Bachelor's degree in Computer Science, Business Analytics, Information Systems or Power BI certification or equivalent.
• Minimum 3 years of relevant experience providing actionable analysis and/or business intelligence.
• Power BI, Excel, Deltek VantagePoint and SQL experience preferred; strong communication and collaboration skills.

Responsibilities

• Develop and maintain reports, dashboards, and KPI tools using Power BI, Excel, and Deltek VantagePoint.
• Apply data visualization best practices to present data for technical and non-technical audiences.
• Collaborate with PMs, Engineering Leads, and Accounting to implement standard reporting; support ad-hoc requests with accurate outputs.
• Mine data to reveal trends and drive data-driven decision-making across the organization.

Skills

Data analysis

Data visualization

Communication

Collaboration

Education

Bachelor's in CS/Analytics/IS

Power BI certification

Tools

Power BI

Excel

Deltek VantagePoint

SQL

Job description

About Ampirical

At Ampirical, we're shaping the future of the power grid with precision, innovation, and purpose. Just as the ampere is the foundation of electric current, Ampirical is a core force driving the energy sector forward. We focus on quality, forward-thinking solutions, and empowering our team to grow and thrive.

At Ampirical, we're shaping the future of the power grid with precision, innovation, and purpose. Just as the ampere is the foundation of electric current, Ampirical is a core force driving the energy sector forward. We focus on quality, forward-thinking solutions, and empowering our team to grow and thrive.

Why Ampirical?

• Salary Range: $39.00 / HR + - Commensurate (dependent on experience, education, qualifications and location)
• Profit-Sharing Bonus: Semi-annual, performance-based (10% to 20% of salary)
• Day-One Benefits: Medical, Dental, Vision
• 401(k) with 4% match and immediate vesting
• PTO: Starting at 80 hours of vacation & 40 hours of sick time per year + 10 paid holidays
• Flexible Work Schedule: Every other Friday off
• Career Development: Advancement opportunities, tuition reimbursement
• Perks: Gym membership stipend, wellness program, fertility benefits, pet insurance, and more

Business Intelligence Specialist

The Business Intelligence Specialist works closely with Project Managers, Engineering Leads, and Project Controls to develop and maintain reports, dashboards, and KPI tools using Deltek VantagePoint, Power BI, and Excel. This role monitors planned vs. actuals to ensure best utilization, revenue, and ROI; mines data to reveal trends and limit non-billable time; and delivers value-added analytics that support data-driven decision-making across the organization.

What You’ll Do

• Develop and maintain reports, dashboards, and KPI tools using Power BI, Excel, and Deltek VantagePoint
• Apply effective data visualization best practices to represent complex data in accessible, actionable formats for both technical and non-technical audiences
• Collaborate with PMs, Engineering Leads, and Accounting to implement standard reporting; support ad-hoc requests with accurate, timely outputs in clear visual formats
• Apply data visualization best practices to present complex data in clear, actionable formats for both technical and non-technical audiences

Data Management & Integration

• Assist with ETL processes and support integration between BI tools and source systems including Deltek VantagePoint and financial platforms
• Validate and maintain accuracy of data used in dashboards and reports; identify and resolve quality issues before they impact deliverables
• Maintain up-to-date BI architecture documentation including data sources, transformation logic, and report lineage

Analytical & Problem-Solving Skills

• Mine data to reveal project and business trends that increase profits, reduce non-billable time, and drive continuous improvement; deliver value-added analytics on business performance
• Generate KPI reports and trend analyses for cost tracking, schedule variance, utilization, and operational performance; escalated discrepancies with clear documentation

BI Tools & Technical Proficiency

• Demonstrate proficient working knowledge of Power BI including dashboard development, DAX measures, and data model relationships
• Use Microsoft Excel at an advanced level (pivot tables, VLOOKUP/XLOOKUP, nested logic) and write simple to intermediate SQL queries against relational databases
• Navigate and extract data from Deltek VantagePoint for project cost, schedule, and resource reporting

Business & Industry Acumen

• Support project managers and engineering leads with cost tracking, schedule variance, and planned vs. actuals monitoring to ensure best utilization, revenue, and ROI
• Track KPIs relevant to engineering and project delivery; develop working knowledge of electric utility services operations and project lifecycle phases

Communication & Collaboration

• Collaborate with project managers, engineering teams, accounting, and project controls to gather requirements, validate outputs, and ensure BI deliverables meet business needs
• Present findings, dashboards, and analytical results in clear visual formats for non-technical audiences
• Assist users in interpreting dashboards and BI tools; participate in stakeholder meetings and design sessions; drive outcomes across cross-functional teams

What You Bring

Minimum Requirements

Education

Bachelors Degree in Computer Science, Business Analytics, Information Systems OR a Power BI certification or equivalent

Experience

Minimum 3 years of relevant experience providing actionable analysis and/or business intelligence for organizations

Preferred Skills

• Proficient in Power BI or similar data visualization tools (Tableau, SAS, MicroStrategy); Power BI certification or equivalent preferred; SQL experience a strong plus
• Advanced proficiency in Microsoft Excel including formulas, pivot tables, VLOOKUP/XLOOKUP, and nested logic; Deltek VantagePoint experience preferred
• Strong understanding of relational database structures; ability to analyze data and recommend solutions to reduce waste and improve efficiency
• Strong work ethic and ability to work autonomously; proven ability to collaborate and drive outcomes across teams spanning disciplines and locations
• Strong communication skills, with the ability to translate complex data into clear, organized insights for audiences at all levels

Ampirical is an Equal Opportunity Employer, meaning we do not discriminate based on the following characteristics in our hiring and employment practices: Age, sex, color, race, creed, national origin, religion or religious attire, marital status, pregnancy (child birth or related medical conditions), citizenship status or amnesty, ancestry, sexual orientation, gender, gender identity, gender expression, transgender status, physical or mental disability, military or veteran status, genetic information, sickle-cell trait, status as a tobacco user or non-user, or any other classification protected by federal, state, or local law.