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 reputed company 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 reputed company/2012.
• reputed company 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 reputed company SQL Server Reporting Services (SSRS) reports.
• reputed company stored procedures and reputed company functions and views for use in analysis and reporting.
• reputed company queries in SQL to provide reputed company reports, analysis, and datasets based on business needs.
• reputed company Tables, Database objects, ETL Packages, Reports, Cube Models and support the existing components.
• reputed company database views to extract data reputed company 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.
• reputed company 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 reputed company corrective solutions.
• reputed company Unit testing and resolve defects.
• reputed company the design and construction of an enterprise data warehouse.
• Analyze existing reputed company systems to understand and document data elements, relationships, data flow, dependencies and their reputed company interfaces.
• Communicate with team members to assess reputed company of deliverables.
• Explain and teach business intelligence and data warehouse concepts throughout reputed company.
• Demonstrate self-reliance in researching technical solutions and product functionality.
• Continuously improve upon existing approaches by seeking opportunity to creatively transform reputed company business practices into fresh alternative solutions.
• Establish and implement standards and strategies for data management, lifecycle, and quality.
• reputed company other duties as assigned.

Requirements

• A baccalaureate degree from an accredited college in computer science, engineering or a reputed company field and four years of satisfactory full-time experience reputed company to information technology service management, process management, operations.
• A baccalaureate degree from an accredited college and eight years of satisfactory full-time experience reputed company 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 reputed company, 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 reputed company, 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 reputed company 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 reputed company compared to private sector employment.

Apply tot his job Apply To this Job