Business Intelligence Developer (Operations Business Intelligence)
Job Description
About Augment Professional Services (APS)
Augment Professional Services (APS) partners with leading organizations across the Energy, Technology, Utilities, and Engineering sectors to deliver specialized talent, consulting expertise, and project support. Our mission is to connect experienced professionals with organizations executing complex projects and critical infrastructure initiatives.
Position Overview
- Seeking a versatile BI Developer to join the Operations Business Intelligence team, focused on delivering high-impact Power BI reporting that transforms raw data into actionable executive insights across Collections, Fleet, Post Collections, and Dispatch.
- Own the full lifecycle of report development, including requirements gathering with leadership, data modeling, and delivering polished, production-ready dashboards.
- Design executive-grade dashboards that prioritize UX/UI, ensuring complex operational data is digestible and visually compelling.
- Author advanced DAX measures and utilize Power Query (M) for sophisticated data shaping and business logic implementation.
- Manage the full development lifecycle from prototype through UAT to production deployment, ensuring quality and accuracy.
- Administer Power BI workspaces and implement Row-Level Security (RLS) to ensure appropriate data access.
- Lead requirements discovery sessions with senior leadership across Collections, Fleet, Post Collections, and Dispatch to define KPIs and translate business objectives into technical specifications.
- Present and demo reports to executive stakeholders, focusing on data storytelling, insights, and recommendations.
- Collaborate within Agile environments using Azure DevOps to track stories, manage backlogs, and maintain transparency into the development roadmap.
- Build and optimize end-to-end data pipelines leveraging MS Fabric (Lakehouse/Warehouse) and Snowflake to support real-time and batch reporting.
- Design, implement, and maintain robust data models (Star Schema) to ensure performance and data integrity.
- Perform root-cause analysis on slow-running reports and optimize SQL queries in Snowflake and DAX expressions in Power BI to achieve high performance.
Required Technical Skills
- Power BI: Expert-level proficiency (DAX, Power Query, Service)
- SQL: Expert-level SQL for complex data transformation and validation
- Snowflake: Experience with SnowSQL, partitioning, and warehouse optimization
- MS Fabric: Familiarity with OneLake, Data Factory, and the Fabric environment
Required Soft Skills
- Executive Presence: Confidence in presenting to and taking feedback from C-suite leadership
- Curiosity: A proactive desire to understand the business operations behind the data — particularly the workflows driving Collections, Fleet, Post Collections, and Dispatch
- Clarity: Ability to explain complex technical concepts to non-technical audiences
Preferred Experience / Qualifications
- Experience with Azure DevOps for project tracking
- Certification in PL-300 (Microsoft Data Analyst) or Snowflake Pro Core
- Prior experience in a "client-facing" or "leadership-facing" internal consultancy role
- Familiarity with waste management, logistics, or field operations is a plus
APS Consulting Footer
Augment Professional Services (APS) delivers specialized talent, consulting expertise, and project support to organizations operating in complex technical environments. Our teams partner with clients across the Technology, Energy, Utilities, and EPC sectors to support critical initiatives in digital transformation, infrastructure modernization, engineering delivery, and industrial construction.
Through a flexible services model that includes managed services, project-based delivery, and embedded technical expertise, APS helps organizations accelerate innovation, scale capabilities, and execute high-impact initiatives with confidence.
Equal Opportunity Statement
Augment Professional Services is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status.