This job board retrieves part of its jobs from: Toronto Jobs | Emplois Montréal | IT Jobs Canada

Find jobs in New Jersey today!

To post a job, login or create an account |  Post a Job

  New Jersey Gigs  

Bringing you the best, highest paying job offers in the state of New Jersey

previous arrow
next arrow
Slider

New

SQL Reports Developer

KHOJ Information Technology, Inc.

This is a Full-time position in Paramus, NJ posted March 31, 2020.

Candidate will also document issues and defects, liaise with the Reporting Project Manager, Development teams, and Business Leads to keep all concerned parties informed.

bull Generate reports, large data extractions, and analysis based on a SQL back-end data store.

Design new reportsdata transformationflows and maintain existing report portfolio.

Utilize SQL scripting, SSIS and VB.Net develop code that presents information to Risk Management and engagement teams in support of the member firmrsquos ongoing operations and usage of the Global Risk systems.

bull Understand, interpret and challenge requirement specifications bull Develop reports and ETL with little, incomplete or no written specifications.

bull Upgrade existing ETL framework and packages from SQL Server 2008 to SQL Server 2016 bull Upgrade SSIS Script Tasks (written in VB.Net) from SQL Server 2008 to SQL Server 2016 bull Address complex issues by thoroughly understanding the business and its functions bull Design and maintain multifaceted SSIS and T-SQL based ETL processes bull Support, maintain and create new reports in one of three VB.NET reporting applications bull Troubleshoot complex issues as well as provide ongoing support to production Create, manage and troubleshoot SQL Server Agent Jobs.

Manage Logins and Security in SQL Server bull Automate existing ongoing reports via SQL server, SSIS and VB.NET while continuously looking for efficiencies.

Automateschedule ETL processes via the SQL Server Agent.

bull Provide development estimates and participate in project planning.

Learn and prototype new technologies, and recommend their use in future reporting solutions bull Maintain detailed commentary in all SQL scripts and diligently report all activity (requirements gathering, development time and implementation) in the Project Activity Application bull Document issues and defects, while liaising with the reporting manager, development teams, and business leads to keep all concerned parties informed bull Ask logical questions to ascertain requirements needs.

Communicate with teams the technical implications, including extractions of data, processing of data, and the delivery of reports.

bull Liaise with application end users and team members to define report requirements, participate in group projects and support the business process help desk teams.

Collaborate with team business leads and IT development teams to understand application and database structure changes and enhancements.

Participate in business design sessions bull Evaluate and propose solutions for business requirements that impact the application bull Participate in the Deployment and Implementation of Projects Skills bull 5-7 years of overall business experience with at least four years of reporting development and SQL development and at least 3 years working with SSIS, preferably within a professional services firm bull Demonstrated technical experience with designing, building, installing, configuring and supporting the RDBMS Microsoft SQL Server bull Strong experience in SQL development (T-SQL) including working with complex data structures and indexes bull Database management knowledge focusing on Microsoft SQL server technology, including writing SQL stored procedures, cursors, dynamic SQL and performance tuning bull Ability to reverse engineer existing ETL processes and VB.NET applications bull Strong programming experience with Visual Basic and .Net bull Strong understanding of database structures, theories, principles, and practices along with the capacity to stay abreast of current technologies and technological trends bull Familiarity with SQL Server Credentials and Proxy accounts as they relate to the SQL Server Agent bull Advanced knowledge of Microsoft Access Excel including but not limited to macros, pivot tables, power query and power pivot.

Proficient in all other Microsoft Office applications bull Light backup and restore experience bull Ability to support VB.Net desktop reporting applications bull Experience in analyzing reports and business data.

bull Strong quantitative and analytical skills bull Particularly adept at conveying complex technical information in an understandable manner to all levels bull Ability to act quickly on issues and requests associated with business needs bull Ability to work in a fast paced team environment and self-manage, work well under pressure meeting tight deadlines and possess excellent interpersonal skills to work well with employees at all levels.

bull Working knowledge of application implementation and support procedures bull Ability to handle multiple tasks and support special project needs simultaneously bull Solid experience with requirements gathering bull Strong written and oral communication skills bull Ability to determine appropriate escalation path bull Experience designing and modifying Crystal Reports bull SQL Server 2005, 2008, 2008 R2, 2012 bull BIDS SSIS, SQL Server Data Tools bull Visual Studio 2010, 2013 Education Bachelorrsquos degree from an accredited collegeuniversity or equivalent work experience CONTACT KHURRAM EXT 109 or khurramathoj-incDOTcomPandoLogic.

Keywords: Report Developer, Location: Paramus, NJ
– 07653