• Function as a technical expert on large and/or complex information requests or projects for SAP • Act as a liaison and expert to business partners and clients on information solutions, such as, reporting, OLAP, Dashboards/scorecards, data stores and data access and analysis methods • Translate business needs for projects and broad scale initiatives into data analysis and reporting solutions for SAP • Follow Data Management processes and procedures and provide input to the creation of data definitions, business rules and data access methods • Analyze trends and make recommendations to business partners • Design, develop, code, implement and troubleshoot reporting applications including designing and interfacing with back-end databases and data marts • Contribute to the development and modification of coding standards for the team to ensure consistency, efficiency and accuracy in reporting and data analysis • Collaborate with IT on database design, data mart structure and the technical architecture of the data delivery environment • Participate in and/or lead the evaluation of future data delivery and analysis methods and tools

Role Description Are you looking for a highly rewarding opportunity that provides extensive career growth opportunity? Gilbane is seeking a BI Developer II to design, develop, and maintain business intelligence solutions that enable data driven decision-making across the organization. This role can sit in any of Gilbane's offices or work remotely. Responsibilities - Designs, develops, and maintains Power BI dashboards, reports, and semantic models that support operational, financial, and strategic decision-making. - Translates business requirements into clear analytical designs, metrics, and visualizations. - Ensures reports are performant, intuitive, and aligned to established data definitions. - Partners with data engineers to leverage curated data sets in Databricks. - Implements and maintains business logic, calculations, and metrics in a consistent and reusable manner. - Applies data quality checks, validation rules, and testing within Databricks and Power BI. - Supports metric definitions, documentation, and lineage to ensure trust and transparency (Atlan experience a plus). - Follows established data governance, security, and access control standards. - Works closely with business partners to understand reporting needs and prioritizes enhancements. - Collaborates with data engineering and business teams to deliver end to end BI solutions. - Provides guidance to business users on report usage and interpretation. - Troubleshoots and resolves data, model, or reporting issues in a timely manner. - Optimizes Power BI models and queries for performance and scalability. - Contributes to BI development standards, documentation, and reusable assets. - Coaches and mentors less experienced team members. - Supports a positive and inclusive work environment. Qualifications - Salary to be determined based on factors such as geographic location, skills, education, and/or experience of the applicant, as well as the internal equity and alignment with the team. - The pay ranges from $100,000-$140,000 plus benefits and retirement program. - Gilbane offers an excellent total compensation package which includes competitive health and welfare benefits and a generous profit-sharing/401k plan. - We invest in our employees’ education and have built Gilbane University into a top training organization in the construction industry. - Qualified applicants who are offered a position must pass a pre-employment substance abuse test. Company Description As a Top-10 ENR Contractor, Gilbane is a family-owned business with 45 offices that has been shaping communities since 1870. Consistently recognized as one of the most reputable construction management firms in the country, Gilbane is committed to delivering projects safely and on-time.

• Define the testing strategy for validating dashboards and indicators • Develop test scenarios covering indicators, filters, dimensions, business rules, access profiles, and dashboard behaviors • Execute validations between legacy reports and migrated dashboards, ensuring consistency of information • Create and maintain comparative queries to identify and analyze discrepancies • Investigate data inconsistencies together with the involved technical teams • Validate filters, drill-down functionality, data access security rules (Row-Level Security), and masking of sensitive information when applicable • Record test results, evidence, discovered discrepancies, and acceptance criteria • Support the homologation and validation phases of deliveries • Track defect fixes, perform regression testing, and support delivery approval • Contribute to documentation of processes, test scenarios, and quality evidence.

• Develop, maintain, and deploy dashboards, reports, and self-service BI solutions. • Partner with business users to translate requirements into KPIs, metrics, and data models. • Design and implement semantic data models to support scalability and extensibility. • Perform data profiling, validation, and exploratory analysis. • Support ad-hoc analysis and data-driven decision-making. • Monitor report usage and performance, optimizing for query speed and usability. • Ensure data governance, security, and compliance practices are embedded. • Contribute to documentation, training, and user enablement.