What are the responsibilities and job description for the Business Intelligence Developer- Operations position at Delphi-US, LLC - Peacemakers in the Talent War?
Business Intelligence Developer - Operations | Location: Houston, TX | Contract
We are seeking a Business Intelligence Developer to lead the design and development of Power BI reports and dashboards focused on operational data across core areas such as Collections, Fleet, Post Collections, and Dispatch. This role involves transforming raw data into actionable insights through advanced data modeling, visualization, and data pipeline management within a fast-paced, data-driven environment.
Key Responsibilities
Delphi-US is a national IT Services firm based in Newport, Rhode Island. Delphi attracts our nation's best and brightest Technical & Professional Talent and positions our nation's finest employers to further their competitive advantages. Delphi's core technical focus includes Data Intelligence Engineering & Analytics, AI/ML Operational Excellence, DevOps & Cloud Computing, Health IT & Life Sciences, and Energy Management/Power Systems; serving domains from sensitive national energy sectors to critical financial services, biomed, life sciences & pharma, major government & municipal institutions, and much of the USA's Fortune 500 corporations. Delphi Associates are deployed on critical IT Projects where their consultative business acumen, comprehensive technical expertise, and committed service mission drives our client's success. Our proprietary skill-based and cultural matching process results in higher qualified project teams, custom curated for our client's specific technical & functional goals. We are supremely experienced, friendly, professional, and ready to advocate on your behalf. Delphi has an indelible understanding of employer expectations, a track record of project success and we deliver lasting results.
6079
We are seeking a Business Intelligence Developer to lead the design and development of Power BI reports and dashboards focused on operational data across core areas such as Collections, Fleet, Post Collections, and Dispatch. This role involves transforming raw data into actionable insights through advanced data modeling, visualization, and data pipeline management within a fast-paced, data-driven environment.
Key Responsibilities
- Design "Executive Grade" Power BI dashboards that deliver clear, visually compelling insights tailored for senior leadership, emphasizing user experience and UI/UX best practices.
- Author advanced DAX measures and utilize Power Query (M) to implement complex business logic and sophisticated data shaping techniques.
- Manage the entire report lifecycle from initial prototype and requirements gathering through user acceptance testing (UAT) to final deployment, ensuring accuracy and quality at each stage.
- Administer Power BI workspaces, implement Row-Level Security (RLS), and enforce data governance policies to restrict data access to authorized stakeholders.
- Lead collaborative sessions with senior leadership across operational areas to define KPIs, translate business needs into technical specifications, and ensure alignment with strategic goals.
- Present and demo reports to executive stakeholders, providing insights, storytelling, and actionable recommendations based on data findings.
- Utilize Azure DevOps to track development stories, manage backlogs, and maintain transparency into project progress.
- Build and optimize end-to-end data pipelines leveraging MS Fabric (Lakehouse/Warehouse) and Snowflake, supporting both real-time and batch reporting needs.
- Design, implement, and maintain high-performance data models (Star Schema) to ensure data integrity and efficient querying.
- Perform root-cause analysis on slow-running reports, optimize SQL queries in Snowflake, and refine DAX expressions in Power BI to achieve sub-second response times.
- Expert-level proficiency in Power BI, including DAX, Power Query, and Power BI Service.
- Expert-level SQL skills for complex data transformation, validation, and querying.
- Experience with Snowflake, including SnowSQL, partitioning, and warehouse optimization.
- Familiarity with MS Fabric environment, including OneLake and Data Factory.
- Ability to work on-site in Houston, TX.
- Experience with Azure DevOps for project management.
- Certification in PL-300 (Microsoft Data Analyst) or Snowflake Pro Core.
- Prior experience in a client-facing or internal consultancy role.
- Familiarity with waste management, logistics, or field operations is a plus.
Delphi-US is a national IT Services firm based in Newport, Rhode Island. Delphi attracts our nation's best and brightest Technical & Professional Talent and positions our nation's finest employers to further their competitive advantages. Delphi's core technical focus includes Data Intelligence Engineering & Analytics, AI/ML Operational Excellence, DevOps & Cloud Computing, Health IT & Life Sciences, and Energy Management/Power Systems; serving domains from sensitive national energy sectors to critical financial services, biomed, life sciences & pharma, major government & municipal institutions, and much of the USA's Fortune 500 corporations. Delphi Associates are deployed on critical IT Projects where their consultative business acumen, comprehensive technical expertise, and committed service mission drives our client's success. Our proprietary skill-based and cultural matching process results in higher qualified project teams, custom curated for our client's specific technical & functional goals. We are supremely experienced, friendly, professional, and ready to advocate on your behalf. Delphi has an indelible understanding of employer expectations, a track record of project success and we deliver lasting results.
6079