Business Intelligence (BI) Analyst, Bureau of Human Resources and Labor Relations
About the position
Responsibilities
- Gather and analyze business requirements and translate business needs into long-term business intelligence solutions leveraging the Microsoft SQL Server platform (SQL Server, SSIS, SSAS, and SSRS).
- Contribute to the development lifecycle including gathering and understanding of requirements, database and report development using SQL Server 2008 R2/2012.
- Develop prototype views and reports of the data, and work with business users both internal and external to refine their requirements.
- Build solutions for Management Dashboards, KPI's Reporting and Operational Business Intelligence.
- Design and monitor construction of user-facing presentation tools, such as Microsoft SQL Server Reporting Services (SSRS) reports.
- Develop stored procedures and complex functions and views for use in analysis and reporting.
- Develop queries in SQL to provide ad hoc reports, analysis, and datasets based on business needs.
- Develop Tables, Database objects, ETL Packages, Reports, Cube Models and support the existing components.
- Develop database views to extract data via a consistent means for daily ETL processes routines using SSIS.
- Troubleshoot data issues, validate result sets, recommend and implement process improvements.
- Create and maintain the logical and physical data models for the production and Business Intelligence data warehouse and data marts.
- Define best practices and standards for the data modeling process.
- Perform maintenance and administration of the database platforms and data protection needs as they relate to the database platforms and solutions.
- Conduct performance tuning of existing data structures.
- Identify critical integration issues and develop corrective solutions.
- Perform Unit testing and resolve defects.
- Lead the design and construction of an enterprise data warehouse.
- Analyze existing complex systems to understand and document data elements, relationships, data flow, dependencies and their related interfaces.
- Communicate with team members to assess progress of deliverables.
- Explain and teach business intelligence and data warehouse concepts throughout the bureau.
- Demonstrate self-reliance in researching technical solutions and product functionality.
- Continuously improve upon existing approaches by seeking opportunity to creatively transform current business practices into fresh alternative solutions.
- Establish and implement standards and strategies for data management, lifecycle, and quality.
- Perform other duties as assigned.
Requirements
- A baccalaureate degree from an accredited college in computer science, engineering or a related field and four years of satisfactory full-time experience related to information technology service management, process management, operations.
- A baccalaureate degree from an accredited college and eight years of satisfactory full-time experience related to information technology service management, process management, operations.
- Education and/or experience which is equivalent to '1' or '2' above.
Benefits
- Loan Forgiveness: As a prospective employee of the City of New York, you may be eligible for federal/state loan forgiveness and repayment assistance programs that lessen your payments or even fully forgive your full balance.
- A premium-free health insurance plan that saves employees over $10K annually, per a 2024 assessment.
- Additional health, fitness, and financial benefits may be available based on the position's associated union/benefit fund.
- A public sector defined benefit pension plan with steady monthly payments in retirement.
- A tax-deferred savings program.
- A robust Worksite Wellness Program that offers resources and opportunities to keep you healthy while serving New Yorkers.
- Depending on your position, you may be able to work up to two days during the week from home.
- Job security compared to private sector employment.
Apply tot his job Apply To this Job