City of New York
Senior Microsoft Power Bi Developer
The Office of Performance Management & Data Analytics (OPMDA) reports critical statistics and data related to the Department of Homeless Services (DHS) as well as to Human Resources Administration's (HRA) operations and program services. OPMDA is requesting to hire one Computer Specialist Software IV to function as a Senior Microsoft Power Bi Developer who will: Lead and oversee the implementation, maintenance, and enhancement of our agency's Power Bi reporting and analytics solutions. As the Power Bi Systems Manager, he/she will play a crucial role in managing the entire lifecycle of Power Bi projects, from requirements gathering and design to development, testing, and deployment. Need expertise in Power Bi, data modeling, and system administration will be instrumental in ensuring the effective utilization of Power Bi to drive data insights and support data-driven decision-making across the agency. Manage data extraction, manipulation, transformation and aggregation; evaluate user requests for new or modified programs and development of related business models. Program and automate reports using SSRS on Oracle and MS SQL Server DB Platforms. In consultation with the business analysts, develop system modifications as needed for the production of new reports and current reports. Coordinate with agency ITS staff on development and modifications for interrelated source systems. Develop and implement a comprehensive Power Bi strategy aligned with the organization's goals and business needs. Also maintain OPMDA's current SSRS infrastructure to eventually convert to Power Bi. Collaborate with business stakeholders and IT teams to identify requirements for Power Bi solutions and prioritize projects. Design and develop data models to support efficient data retrieval and analysis in Power Bi. Implement data integration processes to bring data from various sources into Power Bi datasets. Lead the creation of interactive and visually compelling Power Bi reports and dashboards to meet business requirements. Ensure that reports are user-friendly, provide valuable insights, and adhere to data visualization best practices. Establish data governance processes to maintain data accuracy, consistency, and compliance with data privacy regulations. Implement security measures to safeguard sensitive data and control user access to Power Bi resources. Optimize Power Bi reports and queries for improved performance and faster response times. Provide training sessions and user support to help employees effectively utilize Power Bi for self-service reporting and analytics. Address and resolve any Power Bi-related issues raised by end-users. Manage the Power Bi environment, including user provisioning, licenses, and system configurations by working with ITS. Monitor and troubleshoot system issues to ensure smooth operation. Work Location: 4 WTC/150 Greenwich Street, New York, NY 10007 Hours/Schedule: 9-5 COMPUTER SPECIALIST (SOFTWARE) - 13632 The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.
The Office of Performance Management & Data Analytics (OPMDA) reports critical statistics and data related to the Department of Homeless Services (DHS) as well as to Human Resources Administration's (HRA) operations and program services. OPMDA is requesting to hire one Computer Specialist Software IV to function as a Senior Microsoft Power Bi Developer who will: Lead and oversee the implementation, maintenance, and enhancement of our agency's Power Bi reporting and analytics solutions. As the Power Bi Systems Manager, he/she will play a crucial role in managing the entire lifecycle of Power Bi projects, from requirements gathering and design to development, testing, and deployment. Need expertise in Power Bi, data modeling, and system administration will be instrumental in ensuring the effective utilization of Power Bi to drive data insights and support data-driven decision-making across the agency. Manage data extraction, manipulation, transformation and aggregation; evaluate user requests for new or modified programs and development of related business models. Program and automate reports using SSRS on Oracle and MS SQL Server DB Platforms. In consultation with the business analysts, develop system modifications as needed for the production of new reports and current reports. Coordinate with agency ITS staff on development and modifications for interrelated source systems. Develop and implement a comprehensive Power Bi strategy aligned with the organization's goals and business needs. Also maintain OPMDA's current SSRS infrastructure to eventually convert to Power Bi. Collaborate with business stakeholders and IT teams to identify requirements for Power Bi solutions and prioritize projects. Design and develop data models to support efficient data retrieval and analysis in Power Bi. Implement data integration processes to bring data from various sources into Power Bi datasets. Lead the creation of interactive and visually compelling Power Bi reports and dashboards to meet business requirements. Ensure that reports are user-friendly, provide valuable insights, and adhere to data visualization best practices. Establish data governance processes to maintain data accuracy, consistency, and compliance with data privacy regulations. Implement security measures to safeguard sensitive data and control user access to Power Bi resources. Optimize Power Bi reports and queries for improved performance and faster response times. Provide training sessions and user support to help employees effectively utilize Power Bi for self-service reporting and analytics. Address and resolve any Power Bi-related issues raised by end-users. Manage the Power Bi environment, including user provisioning, licenses, and system configurations by working with ITS. Monitor and troubleshoot system issues to ensure smooth operation. Work Location: 4 WTC/150 Greenwich Street, New York, NY 10007 Hours/Schedule: 9-5 COMPUTER SPECIALIST (SOFTWARE) - 13632 The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.