| C2C/W2 :: Database Reporting Services Consultant :: New York, NY-10004 (HYBRID) :: Long Term Contract :: Telephonic & Zoom/Skype at New York, New York, USA |
| Email: [email protected] |
| Need min. 15 yrs. of working experience. Happy Friday, Hope you are doing Great!! We got a requirement for you as Database Reporting Services Consultant in New York, NY-10004 (HYBRID) . Please go through the below job description and if you are comfortable then please share us your updated resume with expected pay rate/salary. Job Title: Database Reporting Services Consultant Job Location: New York, NY- 10004 (HYBRID) Duration: Long Term Contract Interview: Telephonic & Zoom/Skype Background: The TLC is currently in the process of transitioning from its older, decentralized systems to a more efficient centralized cloud-based system. This shift necessitates an expansion of responsibilities and skills within the Database (DB) team. As part of this transition, the team will be required to validate and rebuild up to 40 reports once the new system is implemented. Another significant initiative for TLC involves the real-time upload of trip data. To support this, we are seeking services to assist in establishing and maintaining the new Azure infrastructure. Additionally, there is a need for expertise in creating additional reports using Power BI. Furthermore, the TLC is actively working on enhancing its systems to accommodate the rule changes set to take effect in the Taxi Improvement Fund in 2024. This involves developing and implementing updates to ensure compliance with the revised regulations. Required Skills: Experience writing SQL Server Integration Services (SSIS) packages for ETL. Experience in data modeling, database design and well versed with DBMS best practices. Experience optimizing and tuning queries. Experience with SQL Server Reporting Services (SSRS) and Power BI. Experience with Informatica is a plus. Ability to see tasks through to completion without significant guidance. Strong issue resolution and investigation skills. Ability to articulate and document the steps taken to resolve an issue. Strong oral and written communication skills and the ability to clearly articulate to all project members and stakeholders. Preferred Skills Informatica Microsoft DevOps Conceptual knowledge of CRM Systems (Salesforce, MS Dynamics etc.) Preferred Certifications CRM SQL Services Desired: TLC seeks a Vendor to provide an experienced Consultant that will be expected to: Identify/resolve/prioritize mission critical production issues. Provide technical documentation as needed. Prepare data migration plans including migration risk, milestones, and quality details. Develop and maintain technical documentation such as design documents, specifications, software/stored proc/DB Jobs documents and instructions. Develop scripts and solutions to automate data aging process to move data that meets the aging criteria out of production. Perform data cleanup by performing data merges, deactivation/deletion of duplicate records using logic for exact matches as well as high probability fuzzy matches. Be creative in providing new ideas and potential technical solutions including reviewing new features asthey are planned for release. Have thorough understanding and experience of development, deployment, and maintenance of SSIS packages. Have thorough understanding and experience of development, deployment, and maintenance of reports in SSRS. Design advanced SQL queries, stored procedures, triggers, and scripts. Create SQL Server databases and database components utilized TLC applications. Collaborate with applications developers and other key team members (Business Leads, Vendors, and Stakeholders) on data modeling and E-R diagrams. Manage database performance, capacity, replication, backup, and security. Develop, implement, and maintain data backup strategy and data retention policies. Perform database migrations from unsupported OS/database servers to supported versions including cloud-based solutions. Assist business analysts and end-users with reporting needs. Develop reports, views, charts, and dashboards to assist program staff with monitoring the outcomes of Agency initiatives. Work with external entitiesto facilitate secure data transfers. Have exceptional communication skills, including effectively communicating with and possibly interpreting between technical and non-technical team members. Qualified vendor must have experience with all the activities listed above Regards, Shubham Gupta Team-Lead|Ana-Data Consulting, Inc. F: 551-236-1014 515-517, Jefferson St, Hoboken, NJ 07030 [email protected] | www.ana-data.com https://www.linkedin.com/in/sshubhguptas/ This message may contain confidential information and is intended only for the individual/entity to which it is addressed. If you receive this message in error, you should not distribute or copy this e-mail. Please notify the sender immediately and delete it from your system. E-mail transmission cannot be guaranteed to be secure as information could be intercepted, corrupted, lost, destroyed, incomplete or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. -- Keywords: business intelligence database rlang information technology golang microsoft New Jersey New York C2C/W2 :: Database Reporting Services Consultant :: New York, NY-10004 (HYBRID) :: Long Term Contract :: Telephonic & Zoom/Skype [email protected] |
| [email protected] View all |
| Fri Mar 29 20:16:00 UTC 2024 |