Business Intelligence Developer - Power BI

Who We Are: Neighborhood Health Center is a non-profit organization local to Portland, OR serving underserved patients in the areas of primary care, internal medicine, dental services and more. Our patient-centered approach to care honors the unique needs and circumstances of each individual patient. NHC sees people, not problems, and recognizes that the time spent as a patient in a doctors office is only one factor in a persons overall health.

Our leading edge, integrated clinical teams work in partnership with patients, their families, and the communities we serve to provide whole-person care, prevention, and ongoing support. NHC is an Equal Opportunity Employer. We celebrate differences in the workplace and do not discriminate in employment opportunities or practices on the basis of race, color, religion, gender (sex), national origin, age, veteran status, sexual orientation, gender identity, disability, genetic information or any other characteristic protected by law.

Why work with us? We are a non-profit organization, passionate about providing the underserved population with medical and dental services across the greater Portland area, committed to making a difference daily. We offer our employees a competitive compensation and benefits package which includes 20 days of PTO (based on full time employment), 9 paid holidays, health/dental/vision insurance, quarterly wellness reimbursements, generous 401k retirement plan with employer match, employer paid disability insurance, EAP and life insurance.

Our employees voted NHC a Top Workplace in 2020, 2021, 2022, 2023, 2024 and 2025! Job Title: Business Intelligence Developer - Power BI Department: IT Reports To: Data Analytics Manager Work Type: Hybrid Classification: Exempt Language Differential: Ineligible SUMMARY The Business Intelligence Developer - Po wer BI designs, develops, and maintains scalable business intelligence solutions and data visualizations. This role focuses on transforming raw data into actionable insights through robust data modeling, DAX calculations, and intuitive dashboard design.

The ideal candidate will bridge the gap between complex data infrastructure and business decision-making, leveraging experience with Power BI, SQL Server, and data warehousing concepts. You will collaborate closely with the Data Analytics Manager, data team members and business stakeholders to deliver secure, efficient, and high-impact analytics. Key Responsibilities and Core Competencies Data Visualization & Design: Design, build, and deploy high-performance dashboards and reports in Power BI that meet business requirements and follow UI/UX best practices.

Data Modeling: Build and manage complex data models using Star and Snowflake schemas; implement Tabular modeling and optimize DAX queries for performance. ETL & Integration: Develop and maintain ETL/ELT pipelines using Power Query (M language) and SQL to ingest data from various sources, including APIs, flat files, and SQL databases. Advanced Analytics: Develop and optimize complex SQL queries and stored procedures to support reporting layers and data mart structures.

Stakeholder Liaison: Act as a technical liaison with business units to elicit requirements, translate business needs into technical specifications, and define agile delivery plans. Administration: Manage Power BI Service environments, including workspaces, capacities, app publishing, and gateway configurations. Governance & Security: Ensure secure data access by implementing Row-Level Security (RLS) and supporting compliance with HIPAA and internal data governance standards.

Documentation: Author and maintain technical documentation for data lineage, metric definitions, and dashboard architecture. Essential Job Duties Assist the delivery of data into Power BI and Tableau platform for analytics and visualization. Work with data team and organization to prioritize and understand data requests in the scheme of operational tasks using JIRA.

Manage workspaces, datasets, and reports within the Power BI service. Implement and manage security settings, data governance policies, and compliance standards. Ensure efficient performance of Power BI reports and dashboards by refining data models and queries.

Proactively monitor and tune report performance, optimizing underlying data models and SQL views to reduce load times. Collaborate with the data team on advanced report writing and deep-dive data analytics. Work with the organization to prioritize data requests within the framework of operational tasks and long-term strategy.

Manage the end-to-end delivery of data into the Power BI platform, ensuring data accuracy and refresh reliability. Expertly manage workspaces, datasets, and report sharing permissions. Maintain expertise in connecting to diverse data sources including SQL Server, Excel and Epic Clarity/Caboodle.

Education and/or Experience Bachelor's degree in computer science or a related field is required; equivalent combination of education, experience, and training may be considered. 5 years of relevant experience in data warehouse development/maintenance is required. Healthcare industry experience is preferred. Advanced SQL Programming is preferred.

Proficiency in DAX is required. License and/or Certification Microsoft Certification: (e.g., PL-300: Microsoft Data Analyst Associate) is highly preferred. EPIC Certification: Electronic Health Record certificate in Clarity or Caboodle is preferred.

Knowledge, Technical Skills, Abilities & Behaviors Technical Stack: Expert knowledge of Power BI Desktop/Service, SQL Server Management Studio (SSMS), and SQL Server Integration Services (SSIS). Data Architecture: Deep understanding of relational and non-relational database structures, theories, and dimensional modeling. Compliance: Working knowledge of data privacy laws, specifically HIPAA.

Analytical Ability: Exceptional conceptual and problem-solving abilities; able to interpret complex requirements into elegant reporting solutions. Communication: Excellent verbal and written communication skills; ability to explain complex technical concepts to non-technical stakeholders. Agility: Ability to prioritize and execute tasks in a high-pressure environment while maintaining commitment to data accuracy.

Analytical ability to gather and interpret requirements and then utilize those requirements to develop, recommend and implement reporting solutions. Must display good verbal and written communication skills. Ability to work directly with business users and software vendors on problems and projects.

Ability to communicate complex technical issues clearly and effectively to any audience. Excellent analytical and problem-solving skills. Strong communication and collaboration abilities.

Attention to detail and a commitment to data accuracy. Working knowledge of applicable data privacy practices and laws, including HIPAA. Excellent written and oral communication skills and the ability to effectively communicate with personnel at all levels.

Exceptional analytical, conceptual, and problem-solving abilities. Ability to prioritize and execute tasks in a high-pressure environment. Proven experience working in a team-oriented and collaborative environment.

Expert working knowledge of interface design and build. Expert working knowledge of IT standards and quality methods and metrics. Knowledge of user business practices, concepts, and terminology sufficient to support data mapping and translations.

Ability to monitor and track highly detailed and multiple complex projects, systems, and data. Strong organizational skills. The ability to communicate effectively with leadership and subject matter experts.

The ability and interest to learn new software and increase their knowledge over time. Must be proficient in reading, writing, and speaking English. WORKING CONDITIONS Regularly sit while working on the computer; use hands and fingers to handle, control or feel objects tools or controls; repeat the same movements when entering data; ability to differentiate between colors, shades, and brightness; read from a computer screen for extended periods of time.

Frequently stand and walk around the office to gather supplies, required to do filing, use office equipment, or collaborate with employees. Occasionally stand, stoop and lift or move objects, equipment and supplies weighing approximately 20-25 pounds up to 40-50 pounds. The noise level in the work environment is usually moderate.

Neighborhood Health Center Employment Offers are contingent on successful completion of reference checks, background checks, drug screening for illegal substances, Tuberculosis, and any position specific credentialing or licensure requirements.