Database and Reporting Specialist
3 days ago
New York
Database And Reporting Specialist With Mandarin Experience This position is the Branch's Database and Reporting Specialist and is responsible for Database management, Data Integration and Report Development throughout the Branch. The candidate will be able to work independently and collaboratively with the team on the database management, development, testing, integration, maintenance, and support of the Branch on day-to-day operations. Skills and Knowledge Requirements: • Extensive experience writing advanced SQL queries and stored procedures and troubleshooting their performance., • Familiarity with Windows server operating systems, and an understanding of server hardware as it relates to MS SQL Server, as well as an understanding of basic networking and system concepts., • Professional knowledge and experience in large, relational databases and data structures, such as SQL Server or other database., • Experience in develop test plans, test scripts, validation procedures, and perform system integration testing., • Strong understanding of ETL concepts., • Familiarity with Business Intelligence tools including SSIS and SSRS, integration with SQL., • Proven Microsoft T-SQL skills., • Demonstrated experience with maintaining database security, access control and management., • Knowledge and experience to manage and monitor SQL Server infrastructure, tune performance and remediate any database., • Ability to develop reports development and maintenance policies, and draft the new product or report requirements., • Knowledge and experience in the Data Governance management and support., • Self-motivated and be able to work independently and collaboratively with others teams., • Proficient in standard business and database software including: MS Office, MS Access, Crystal Report, and SSMS., • Strong quantitative skills, attention to detail, and a high aptitude for problem solving., • Bachelor's degree in Computer Science or equivalent related field., • 5+ years of experience in designing, developing, implementing, maintaining and administering Microsoft SQL Server or other database applications (SSIS, SSRS) in an enterprise environment., • Design and develop database and applications with all phases of software development lifecycle., • Use SSIS, SSRS, and SQL to develop ETL packages and reports., • Maintain the exiting SSIS Packages, Data Flow logic designs and SSRS Reports., • Design and develop new features/functionalities of ETL Data Integration using SSIS, SQL, C#, Java, Python, etc., • Perform hands-on data-related tasks such as data analysis, data integration, data issue remediation, data reconciliation, data warehousing, and reporting automation., • Develop functions, views and stored procedures, complex SQL queries for reports that meet business requirements., • Conduct legacy report logic analysis and develop the report on the new reporting platform., • Perform end-to-end reports management including design, development, testing, configuration, deployment, and maintenance of the reports., • Proactively manage and monitor SQL Server infrastructure, tune performance and remediate any issues utilizing the Database infrastructure., • Design, implement and maintain data integrations between enterprise systems., • Maintain and enforce data consistency across those systems., • Design, implement and maintain solutions to assist in the analysis and delivery of data stored in enterprise systems through the use of SQL Server business intelligence tools, including SSIS, SSRS, etc., • Establish, maintain and follow group procedures and policies related to the SQL Server environment, including installations, configurations, backups, disaster recovery, and other such operations., • Write technical documents and testing reports., • Provide support for the internal and external audit and exam., • Be responsible for demonstrating risk awareness by following all policies, procedures, and internal control in their daily routine., • Execute ad hoc tasks assigned by Supervisors.