• Build and maintain Microsoft Fabric data pipelines supporting REST APIs, SQL Server sources, and file-based ingestion processes • Develop and orchestrate Spark notebooks within Microsoft Fabric • Implement Bronze, Silver, and Gold lakehouse patterns within OneLake environments • Build, test, and optimize ETL/ELT processes for performance, scalability, and maintainability • Design and develop reusable semantic models that support consistent enterprise reporting across multiple business domains • Migrate existing Tableau reports and dashboards into Microsoft Power BI while validating business logic and report accuracy • Develop and optimize DAX measures, calculations, and business logic to support executive and operational reporting • Optimize Power BI report performance, usability, and maintainability using Microsoft Fabric best practices • Participate in Azure DevOps CI/CD processes • Partner with business stakeholders to validate reporting requirements and ensure successful report modernization • Collaborate closely with client engineers through paired development and knowledge-sharing activities

Role Description Currently, we are looking for a Business Intelligence Developer (SQL, PowerBI) to take a key role in our data experts team and transform data into actionable insights that will shape the company's dynamic growth strategy. You will play a key role in every stage of the development of our reporting platform, taking end-to-end ownership from: - Gathering requirements - Data ingestion and warehousing - Robust data modelling and validation - Creation of meaningful insights and reporting This will enable informed strategic decisions and drive operational excellence across the business. We seek curious "doers" who are passionate about data analyses and thrive in a role that combines deep technical expertise with strategic business understanding. Qualifications - 3+ years of experience in Business Intelligence - Understanding of data warehousing architecture, data modeling concepts, and ETL/ELT best practices - Advanced proficiency in SQL for complex querying, performance tuning, and data manipulation - Expertise with business intelligence/data visualization tools (Microsoft PowerBI is a must!) - Proficiency with version control (Git) - Flexibility to quickly adapt to changing priorities within a very dynamic startup environment - Effective and flexible communication skills, including the ability to translate technical details into business and commercial objectives, and vice versa - A proactive communication style – you’re not afraid to challenge the status quo and articulate your vision to both technical and non-technical stakeholders - Self-driven and detail-oriented mindset while working with data - Nice-to-have: hands-on experience with AWS data components, like Iceberg, S3, Glue and Redshift for transformation, ingestion and storage of data - Nice-to-have: experience AI-driven data structures development Requirements - Own the full lifecycle of BI development: from gathering and challenging business requirements to solution design, deployment, and fostering end-user adoption - Act as a key partner for business stakeholders and data engineers, effectively translating business needs into robust technical solutions - Design, develop, and maintain scalable and robust Business Intelligence solutions using our modern tech stack (AWS Redshift, AWS RDS, Microsoft PowerBI, Git, AI tools) - Develop comprehensive data models and build interactive dashboards using Microsoft PowerBI - Perform both ad-hoc data analysis and build automated reporting solutions that empower business users - Pivotal role in an expert team where your contributions have an immediate and visible impact on the business - Chance to develop opportunities in the modern up-to-date cloud technologies environment - High level of ownership and a real impact on our data strategy - Growth opportunity in a place focused on long-term collaboration and your personal growth

Role Description The Business Intelligence Developer III role works under minimal direction, coordinating the compilation of technical components of a project or program. This position has a strong focus on delivering high-level technical solutions and guidance to junior developers on the Joint Data Analytics Team (JDAT) and its customers. Responsibilities include: - Leading top priority projects and providing management with the technical capabilities of the group. - Overseeing junior analyst work and providing technical and substance-based direction for projects. - Handling multiple assignments with competing priorities. - Acting as a subject matter expert for multiple technologies and Epic data models. - Demonstrating mastery of database languages and technology. - Delivering on simultaneous projects with the highest quality of work. - Presenting work to all levels of the organization, including executives and industry colleagues. Responsibilities - Application & dashboard development. - Supports new application development including specification gathering, application programming, validation & analysis, user testing, and maintenance. - Works with data architects to design relational and dimensional data models to verify that the model meets the use cases. - Fosters an environment for department growth through education and knowledge transfer. - Leads groups of subject matter teams by overseeing subject area work requirements. - Provides feedback to management regarding the performance of Business Intelligence Developer I & II. - High-level understanding of workflow options, both Epic and departmental. - Follows system standards related to workflow analysis, system specs generation, proof of concept validation, sign off, system configuration, application, and integrated testing. - Oversight on potential system enhancements from Epic and enhancement requests from end users. - Participates in the development and documentation of internal procedures. - Coordinates and interacts with vendors, both on and off-site. - Performs all duties and responsibilities in accordance with the "I Am Yale-New Haven" service excellence program. Qualifications - Bachelor's degree required; B.S. in an IT-related field preferred or equivalent combination of education and experience. - In combination with a bachelor's degree, 8 years work experience in an IT-related role. - Work experience in a relevant clinical setting preferred with an emphasis on IT-related functions (e.g., "Super User" for a clinical or business area). - Epic Certification in a Clarity or application model required. Special Skills - High-level experience in database management and development, relational database querying as SQL. - Business intelligence experience required, including Tableau, SAP Web Intelligence, and SAP Crystal Reports. - Expert level understanding of Microsoft scripting languages and other object-oriented programming languages. - Knowledge of networking and web technologies, GitHub or other source control experience. - ETL skills using SSIS or scripted tasks to accomplish highly complex tasks. - Ability to work independently while overseeing others' work. - Strong written and verbal communication skills with a diverse range of individuals. - Comfortable speaking and managing up to large groups or audiences. - Highly engaged in teamwork and team growth activities. - High aptitude for understanding new concepts, technology, and academic theory. YNHHS Requisition ID 184124

Role Description The Power BI Developer supports PG&E’s business intelligence environment by designing, building, and maintaining dashboards, reports, and semantic models in Microsoft Power BI. This role turns fundraising and engagement data into clear, reliable reporting that provides actionable insights for fundraisers and PG&E leadership. - Design, build, and maintain Power BI dashboards, reports, and datasets using DAX and Power Query. - Create clear, user-friendly visualizations and reports for operational and executive audiences that support self-service analytics. - Explore and use Power BI features, including emerging AI-assisted capabilities, to improve the efficiency of dashboard and report development. - Partner with stakeholders to understand and prioritize reporting needs, translate business questions into reporting solutions, and validate outputs for accuracy and usability. - Communicate insights and reporting logic clearly to non-technical audiences to support informed decision-making. - Support the definition and implementation of KPIs for fundraising and engagement. - Design dashboards to monitor donor behavior, campaign performance, and operational metrics. - Collaborate with analytics colleagues to ensure consistent business logic and reporting standards. - Test and validate dashboards and reports to ensure accuracy, consistency, and performance. - Investigate reporting anomalies and partner with the Senior BI Developer and data teams to resolve reporting discrepancies. - Support self-service analytics by providing guidance on how to use dashboards and reports. - Actively learn about safeguarding and integrate it into their work, including safeguarding risks and mitigations related to their area of work. Qualifications - Bachelor's degree or equivalent professional experience. - 4+ years of experience in business intelligence, reporting, or analytics roles. - Experience within the humanitarian, NGO, nonprofit, or fundraising sectors is preferred. - Demonstrated experience building dashboards and reports in Microsoft Power BI, including strong working knowledge of DAX for developing measures and KPIs, and experience using Power Query to prepare and transform data. - Experience using SQL to query and manipulate data from relational databases. - Excellent written and verbal communication skills, with the ability to present complex data and insights clearly to both technical and non-technical audiences. - Fluency in English is required; working proficiency in French, Spanish, or Arabic is a plus. Requirements - Experience gathering business requirements and translating them into reporting solutions, including validating outputs and investigating data issues. - Familiarity with data warehousing concepts and reporting environments. - Demonstrated ability to handle sensitive and confidential information with a high level of integrity, discretion, and professionalism. Benefits - This is a remote position based in the selected candidate's country of permanent residence. - May require up to 5% international travel to support country programs. - Access to good medical services and high-standard living conditions. - Empowerment to dedicate 5% of time to learning activities for personal and professional growth.