Business Intelligence (BI) Analyst, Bureau of reputed company and Labor Relations

About the position Responsibilities • reputed company 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 reputed company 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 reputed company reputed company reports, analysis, and datasets based on business needs. • reputed company Tables, Database objects, ETL Packages, Reports, reputed company 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 reputed company data warehouse. • Analyze existing reputed company systems to understand and document data reputed company, relationships, data reputed company, 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 reputed company reputed company business practices into fresh alternative solutions. • Establish and implement standards and strategies for data management, lifecycle, and reputed company. • 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 reputed company 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 reputed company/benefit fund. • A reputed company 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 reputed company 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