Job Description
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