Business Intelligence Developer I - Power BI (CEMI)

Job description

Title: Business Intelligence Developer I - Power BI (CEMI) Location: Upper East Side Org Unit: Business Intelligence Work Days: Weekly Hours: 35.00 Exemption Status: Exempt Salary Range: $88,600.00 - $101,900.00 *As required under NYC Human Rights Law Int 1208-2018 - Salary range for this role when Hired for NYC Offices Position Summary Responsible for developing, maintaining, and supporting business intelligence, reporting, and data visualization solutions primarily using Microsoft Power BI. Works with data from enterprise systems including SAP, Amazon Redshift, SQL Server, and other operational databases to deliver actionable insights for business users. Partners with business stakeholders, analysts, and senior developers to gather requirements, create reports and dashboards, and support data-driven decision-making. Assists with data integration, data validation, and report optimization while adhering to business intelligence best practices. The ideal candidate will have hands-on experience with Power BI, SQL, and data visualization concepts, along with a strong desire to learn and grow within a collaborative analytics environment. This is a term position anticipated to be needed through Fall 2028 but may be ended or extended based on organizational needs, funding availability, and performance. Job Responsibilities Develop and maintain Power BI reports, dashboards, and visualizations to support business operations and strategic initiatives. Work with business stakeholders to gather requirements, understand reporting needs, and translate them into effective Power BI solutions. Create and maintain data models, relationships, measures, and calculations using DAX. Connect Power BI to multiple data sources including SQL databases, Amazon Redshift, SAP data sources, and other enterprise systems. Support data extraction, transformation, and loading (ETL) processes while ensuring data accuracy and quality. Perform report testing, validation, and troubleshooting to ensure data integrity and user satisfaction. Monitor and optimize Power BI report performance and usability. Document report designs, data definitions, business rules, and technical specifications. Provide end-user support, training, and guidance related to Power BI reports and dashboards. Collaborate with Business Analysts, Data Engineers, and senior BI developers to implement reporting solutions and resolve data issues. Support Power BI workspace administration, report publishing, and distribution processes. Stay current with Power BI features, data visualization best practices, and emerging analytics technologies including AI-enabled reporting capabilities. Education Bachelor's Degree in Computer Science, Information Systems, Data Analytics, Business Analytics or related field preferred Equivalent combination of education and relevant work experience will be considered. Experience 1-3 years of experience developing reports, dashboards, and visualizations using Microsoft Power BI. Experience creating Power BI data models, measures, and calculations using DAX. Experience working with relational databases and writing SQL queries. Experience connecting Power BI to multiple data sources including SQL Server, Redshift, SAP, or other enterprise applications. Basic understanding of ETL processes and data integration concepts. Experience publishing, managing, and distributing Power BI reports and dashboards. Familiarity with Power BI Service, workspaces, datasets, dataflows, and scheduled refreshes. Exposure to data warehousing and dimensional modeling concepts preferred. Basic knowledge of Python or R for data analysis is a plus. Experience working in an Agile or Scrum environment preferred. Healthcare, research administration, finance, or human resources reporting experience is a plus. Knowledge, Skills and Abilities Strong proficiency in Microsoft Power BI, including report development and dashboard design. Understanding of DAX, Power Query, and data modeling concepts. Knowledge of SQL and relational database fundamentals. Strong analytical and problem-solving skills Ability to communicate technical concepts effectively to business users Strong organizational skills and attention to detail. Ability to manage multiple priorities in a fast-paced environment. Desire to learn new technologies and expand technical skills. Ability to work collaboratively with cross-functional teams. Familiarity with data governance and data quality principles. Interest in AI, Generative AI, and analytics innovations as applied to reporting and business intelligence. Licenses and Certifications Microsoft Certified: Power BI Data Analyst Associate (PL-300) Microsoft Fabric Fundamentals (preferred) Working Conditions/Physical Demands Cornell welcomes students, faculty, and staff with diverse backgrounds from across the globe to pursue world-class education and career opportunities, to further the founding principle of “any person, any study.” No person shall be denied employment on the basis of any legally protected status or subjected to prohibited discrimination involving, but not limited to, such factors as race, ethnic or national origin, citizenship and immigration status, color, sex, pregnancy or pregnancy-related conditions, age, creed, religion, actual or perceived disability (including persons associated with such a person), arrest and/or conviction record, military or veteran status, sexual orientation, gender expression and/or identity, an individual’s genetic information, domestic violence victim status, familial status, marital status, or any other characteristic protected by applicable federal, state, or local law. Cornell University embraces diversity in its workforce and seeks job candidates who will contribute to a climate that supports students, faculty, and staff of all identities and backgrounds. We hire based on merit, and encourage people from historically underrepresented and/or marginalized identities to apply. Consistent with federal law, Cornell engages in affirmative action in employment for qualified protected veterans as defined in the Vietnam Era Veterans’ Readjustment Assistance Act (VEVRRA) and qualified individuals with disabilities under Section 503 of the Rehabilitation Act. We also recognize a lawful preference in employment practices for Native Americans living on or near Indian reservations in accordance with applicable law.