Sr Business Intelligence Reporting Developer

The Senior Business Intelligence Reporting Developer is responsible for designing, developing, and maintaining business intelligence (BI) solutions using Vestis approved enterprise solutions. This role involves working with stakeholders to gather business requirements, creating data models, and developing insightful reports and dashboards that support data-driven decision-making. The developer must have strong experience in data visualization, SQL, and ETL processes, ensuring optimal performance and scalability of reporting solutions. This position is expected to show team and vendor leadership; work with little supervision; assist others in their area; and work with others to prepare accurate estimates of work. This position is expected to provide support in multiple projects of high scope and complexity. This role is highly cross-functional, and works closely with our internal Rental Operation, Direct Sales, IT, Marketing teams and external third-party vendors. The candidate must be able to work autonomously and have a solid understanding of process analysis, requirements gathering, systems design, Agile, DevOps and web-based solutions.

Responsibilities/Essential Functions:

• Design, develop, and maintain interactive dashboards, reports, and paginated reports that meet business needs.
• Develop visually compelling data representations, ensuring reports are user-friendly and insightful.
• Optimize reports for performance, including handling large datasets efficiently.
• Work with Power BI Service (cloud and on-premises) to manage report deployment, security, and sharing.
• Build and maintain data models that support accurate and efficient reporting.
• Connect reporting to various data sources (SQL Server, Azure Synapse, Data Lakes, APIs, Excel, SharePoint, etc.).
• Develop ETL (Extract, Transform, Load) processes using Power Query (M language) or other data integration tools.
• Ensure data integrity, governance, and security within reports and datasets.
• Work closely with business analysts, data engineers, and IT teams to translate business needs into technical solutions.
• Gather and document requirements from stakeholders, ensuring clear understanding before development.
• Train and support end-users on Power BI report functionality and other reporting toolsets and best practices.
• Collaborate with cross-functional teams to ensure alignment with data architecture and business intelligence strategies.
• Improve report efficiency through best practices in data modeling and optimization.
• Implement row-level security (RLS) and user access control within Power BI.
• Monitor Power BI Service performance and troubleshoot issues related to report rendering and data refreshes.
• Stay up to date with reporting toolsets and new features, incorporating them into solutions as appropriate.
• Perform special assignments and attend meetings as appointed to improve process efficiency and performance in job duties.
• Consistently seek improvement and excellence in job skills.
• Complete other duties and activities as assigned by manager.
• Maintain good standing and completion on all compliance related matters (i.e., assigned mandatory trainings, actions required from audits, corporate policies, etc.).
• Perform all additional duties and responsibilities based on the direction and guidance of supervisor.

Knowledge/Skills/Abilities:

• Deep understanding of user experience (UX), design and customer service principles
• Excellent communicator - can articulate the pros and cons of various technologies, platforms and architectural options
• Expertise in Power BI Desktop and Power BI Service for report development and publishing.
• Strong proficiency in calculations, aggregations, and custom measures.
• Experience in data modeling (normalization, denormalization).
• Proficiency in SQL for querying databases and data manipulation.
• Hands-on experience with Power Query for data transformation.
• Knowledge of ETL concepts and tools.
• Experience implementing Row-Level Security (RLS) in Power BI.
• Understanding of pipelines for Power BI deployments using DevOps tools.
• Strong problem-solving and analytical skills to develop insightful reports.
• Ability to translate business needs into technical solutions effectively.
• Excellent communication skills for collaborating with stakeholders and presenting insights.
• Strong attention to detail and commitment to data accuracy.
• Ability to work independently and manage multiple priorities.
• Skilled and proficient in MS Office O365 suite (i.e. Word, PowerPoint, Excel, SharePoint, Teams, Communications Tools, etc.)
• Ability to operate with a customer-centric service approach
• Ability to establish performance-based relationships with 3rd party vendors and technology providers and versed in setting standards and measurements for IT processes
• Ability to effectively define a business case, determine return on investment, and measure achievement of the case over time
• Ability to manage and work on multiple concurrent deliverables at various stages of development and completion
• Strong collaboration and team-building skills with the ability to create consensus around decisions and mitigate conflicts among teams
• Willingness to seek out and implement coaching, suggestions, and guidance from others

Working Environment/Safety Requirements:

• Ensure necessary working environment and capabilities to effectively carry out responsibilities if working from a non-AUS location (remote work)
• Ability and willingness to handle work related issues during all hours of the day, every day of the week, understanding the responsibility of our organization's requirement for 24/7 production support
• Ability, willingness, and flexibility to travel as needed for approved work purposes in accordance with project and management schedules

Experience/Qualifications:

• Bachelor's degree
• 5+ years of working experience with Power BI
• Experience working directly and consulting with business clients to design a solution
• Experience with tools and concepts related to data and analytics, such as dimensional modeling, ETL, reporting tools, data governance, data warehousing, structured and unstructured data
• Experience with design and implementation of ETL/ELT/Streaming processes
• Database development experience using Oracle, SQL Server, Azure Synapse
• Ability to research, plan, organize, lead, and implement new processes or technology
• Experience creating dashboards using Power BI or other similar visualization tools
• Experience with the use of Project Management methodologies and tools
• Bachelor and/or Master's degree preferred but not required
• Be legally able to work in the United States: U.S. Citizen or Legal Resident

License Requirements/Certifications:

• Valid U.S. driver's license (for rental cars when applicable)

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)