What are the responsibilities and job description for the Business Intelligence Developer- Operations position at Arnex Solutions LLC?
Houston TX - Onsite Overview
Our client is seeking a Business Intelligence Developer for a contract opportunity. This role is centered on delivering high-impact Power BI reporting that turns raw data into actionable executive insights across core operational areas. This individual will own the full lifecycle of report development—from requirements gathering with leadership through data modeling to the final presentation of polished, production-ready dashboards. The ideal candidate is a technical powerhouse who speaks the language of business and can navigate the nuances of day-to-day operations.
Responsibilities
Power BI Reporting & Development (Primary Focus)
Visualization Excellence
Data Engineering & Architecture
Required Qualifications:
Our client is seeking a Business Intelligence Developer for a contract opportunity. This role is centered on delivering high-impact Power BI reporting that turns raw data into actionable executive insights across core operational areas. This individual will own the full lifecycle of report development—from requirements gathering with leadership through data modeling to the final presentation of polished, production-ready dashboards. The ideal candidate is a technical powerhouse who speaks the language of business and can navigate the nuances of day-to-day operations.
Responsibilities
Power BI Reporting & Development (Primary Focus)
Visualization Excellence
- Design "Executive Grade" dashboards that prioritize UX/UI, ensuring that complex operational data across multiple lines of business which is digestible and visually compelling.
- DAX & Power Query: Author advanced DAX measures and utilize Power Query (M) for sophisticated data shaping and business logic implementation.
- Manage the full development cycle from prototype through UAT to production deployment, ensuring quality and accuracy at every stage.
- Security & Governance: Administer Power BI workspaces and implement Row-Level Security (RLS) to ensure data is accessible only to authorized stakeholders.
- Requirements Discovery: Lead collaborative sessions with senior leadership across Collections, Fleet, Post Collections, and Dispatch to define KPIs and translate business objectives into technical specifications.
- Data Storytelling: Present and demo reports to executive stakeholders, focusing on "the why" behind the data and providing recommendations based on findings.
Data Engineering & Architecture
- Fabric & Snowflake Ecosystem: Build and optimize end-to-end data pipelines leveraging MS Fabric (Lakehouse/Warehouse) and Snowflake to support real-time and batch reporting across all operational areas.
- Advanced Modeling: Design, implement, and maintain robust data models (Star Schema) that ensure high performance and data integrity across the organization.
- Optimization: Perform root-cause analysis on slow-running reports; optimize SQL queries in Snowflake and DAX expressions in Power BI to ensure sub-second response times.
Required Qualifications:
- 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.
- 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.