• Anforderungsaufnahme und -analyse sowie Projektkonzeption und technische Umsetzung auf Basis der neuesten SAP BI-Technologien. • Entwicklung von individuellen Lösungen mit SAP BW on HANA, BW/4HANA und der SAP Analytics Cloud. • Projektsteuerung und Projektmanagement. • Interne sowie externe Coachings und Trainings. • Mentor für Young Professionals. • Kundenworkshops, Reviews und Analysen sowie Pre-Sales-Aktivitäten zur Kundengewinnung und Kundenbindung.

• 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