• Design, develop, and deploy Power BI reports, dashboards, and executive scorecards. • Translate business requirements into actionable KPIs and visual analytics. • Build and maintain reusable Power BI datasets, semantic models, and dataflows. • Apply best practices in UX/UI design, storytelling, and accessibility for BI solutions. • Develop BI platforms in Azure Fabric, enabling self-service capabilities using Power BI and Copilot. • Create and optimize DAX measures, calculated columns, and KPIs. • Implement advanced modeling features, including: Time intelligence, Row-level security (RLS), and Calculation groups (preferred). • Optimize Power BI performance via query tuning, aggregation strategies, and model design. • Implement security best practices: RLS, object-level security, and data sensitivity labels. • Support Power BI Service administration, workspace management, and deployment pipelines. • Ensure solutions align with enterprise data governance and compliance standards.

• Design, develop, and maintain advanced interactive dashboards, reports, and KPIs using Power BI Desktop and Service. • Develop complex DAX queries and calculated measures for advanced analytics. • Build and optimize data models, relationships, and data transformations using Power Query. • Implement Row-Level Security (RLS) and Column-Level Security to ensure appropriate data access. • Integrate Power BI workspaces with Azure AD / Entra ID to manage permissions. • Develop audit reports to track access, usage, and permission changes for compliance (GDPR, SOX). • Collaborate with InfoSec to integrate Power BI access with IGA tools (SailPoint, Saviynt) for automated access certification. • Gather reporting requirements from business stakeholders and translate into technical specifications. • Optimize Data Gateways and report performance for scalability. • Provide training and documentation to end-users on data security within the BI environment.

Business Intelligence (BI) Developer Growth, Engagements and Insight; IT and Product Development  Location: Nationwide US (Remote – Home Office)    Ready to make a difference?  We’re seeking a Business Intelligence (BI) Developer with a passion for collaboration and creating impactful data reporting solutions. In this role, you’ll work closely with a varied range of business owners to support their fast-evolving needs, delivering timely and insightful analytics while expertly juggling multiple priorities.   You’ll have the opportunity to tap into our team’s established best practices and proven development methodologies to streamline your efforts and ensure high-quality results. The team’s Data Analysts will provide initial requirements, but your insights and feedback will help evolve both the technical solution and the overall development process. Additionally, your expertise will be invaluable in continuing to modernize our team’s capabilities, as you provide architectural guidance for cloud-based solutions using industry-leading development and security practices. By applying your knowledge, you’ll help us efficiently design and deploy scalable analytics solutions structured to meet not only current client needs but also the efficient integration of new features and/or data sources to meet future client needs. Why you will love working here:   - Quality of life: Flexible workplace arrangements, work-life balance  - Investment in the community: Donation matching, volunteer opportunities  - Investment in you: Tuition reimbursement, access to professional development resources, 401k matching, Employee Stock Purchase Plan  - And many, many more (Ask your recruiter for more details!)  What you will be doing:  - Data analysts will share requirements and documentation so the BI Developer can provide feedback, suggesting alternative designs/solutions when appropriate. - Your work will be delivered on client specified timeframes (e.g., weekly, monthly, quarterly) but can also be quick turnaround support, especially when creating ad hoc tools. - Your daily tasks will be highly varied and could include helping maintain data integrity across a wide variety of energy efficiency programs, troubleshooting data quality issues and communicating their impacts, supporting ongoing custom report maintenance, etc. - You may also build data lakes, optimize ETL pipelines, and manage databases with SQL, all to provide actionable customer insights.   What we need you to have (minimum qualifications):    - Bachelor's degree in (Computer Science, IT, Data, Science, Math or related fields) (or applicants can substitute one year of related experience for one year of education) - 2+ years of experience working with SQL Server (e.g., query tuning, writing procedures/functions, building views) and SQL Server Reporting Services (SSRS). - 2+ years of experience in SQL querying and scripting, with experience optimizing complex queries for performance and scalability. - 2+ years of experience working with BI tools (e.g., Power BI). - Must be able to pass a Motor Vehicle Record (MVR) check and Background Check including a Drug Screening. What we would like you to have:  - Experience in rapidly maintaining, supporting, and producing regular reporting deliverables for a variety of audiences. - Exposure to the utility, energy, and/or energy efficiency sectors. - Strong understanding of database structures, normalization, and data modeling, including how to streamline and automate repetitive tasks. - Experience modernizing from legacy BI systems into cloud-based applications/platforms, including creating technical documentation and architectural diagrams. - Experience using Fabric, Azure, Python, PySpark, Hadoop, DataBricks. Working at ICF ICF is a global advisory and technology services provider, but we’re not your typical consultants. We combine unmatched expertise with cutting-edge technology to help clients solve their most complex challenges, navigate change, and shape the future. We can only solve the world's toughest challenges by building a workplace that allows everyone to thrive. We are an equal opportunity employer. Together, our employees are empowered to share their expertise and collaborate with others to achieve personal and professional goals. For more information, please read our EEO policy. We will consider for employment qualified applicants with arrest and conviction records. Reasonable Accommodations are available, including, but not limited to, for disabled veterans, individuals with disabilities, and individuals with sincerely held religious beliefs, in all phases of the application and employment process. To request an accommodation, please email Candidateaccommodation@icf.com and we will be happy to assist. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations.  Read more about workplace discrimination rights or our benefit offerings which are included in the Transparency in (Benefits) Coverage Act. Candidate AI Usage Policy At ICF, we are committed to ensuring a fair interview process for all candidates based on their own skills and knowledge. As part of this commitment, the use of artificial intelligence (AI) tools to generate or assist with responses during interviews (whether in-person or virtual) is not permitted. This policy is in place to maintain the integrity and authenticity of the interview process.  However, we understand that some candidates may require accommodation that involves the use of AI. If such an accommodation is needed, candidates are instructed to contact us in advance at candidateaccommodation@icf.com. We are dedicated to providing the necessary support to ensure that all candidates have an equal opportunity to succeed.   Pay Range - There are multiple factors that are considered in determining final pay for a position, including, but not limited to, relevant work experience, skills, certifications and competencies that align to the specified role, geographic location, education and certifications as well as contract provisions regarding labor categories that are specific to the position. The pay range for this position based on full-time employment is: $74,090.00 - $125,954.00 Nationwide Remote Office (US99)

• Collaborate with customers to lead the analysis, design, development, and support of complex computer applications and systems, as well as clinical and operational workflows related to Hospital Billing, Professional Billing, and Epic Integrated Reporting. • Gather requests for new reports and coordinate with customers to identify and document detailed requirements. • Design and develop reporting solutions that meet customer needs while adhering to OHSU Finance and BIAA standards. • Develop and monitor reporting using systems such as Power BI, Epic Reporting Workbench, SlicerDicer, and to a lesser extent, Business Objects Webi. • Analyze hospital & professional, along with clinical data to deliver robust data visualizations, dashboards, and reports to be leveraged by OHSU customers. • Ensure data integrity in current system and when creating and moving to new systems. • Provide recommendations for selection of systems for new programs and projects. • Meet with customers to translate complex requests for reporting, system, and data needs. • Identify and advise on technical limitations, alternatives, data extraction methods, and create data collection tools as needed. • Collaborate with analysts, developers, managers, and leadership to define requirements and inform priorities and needs. • Perform complex research in complicated data environments and front-end systems to ensure correct data selection and validity. • Research and recommend improvements in workflow, documentation, or alternative solutions. • Create data visualizations and self-service solutions using Microsoft PowerBI. • Write complex queries and run reports from the various OHSU data warehouses. • Optimize SQL code for efficient execution. • Distribute monthly, special quarterly, and annual reports as requested.