[Close] 

SQL-BI developer

Company Name:
Open Systems Technologies
Seeking a SQL/BI Developer to join our client's development team.
You- are used to wearing many hats, good working in small environments, analyzing, developing SSIS projects, custom reports and work closely with the VP on any SQL Server issues. This is an excellent opportunity for an ambitious and agile person looking to be the GO TO for all things related to the MS BI Stack. You know SQL Server inside and out and can jump in and handle overflow of ASP.NET projects. You want to get your hands in and on all of the latest and greatest technologies...
Responsibilities:
Develop SSIS projects to handle ETL, transmission, encryption, and archiving of files received and generated.
Design, develop, and maintain database tables, stored procedures, and supporting objects.
Build and support operational reports for company and clients.
Work with data team to provide operational support, resolve recurring problems.
Document database topology, architecture, processes and procedures.
Develop SQL queries and support ad hoc requests for data.
Assist with capacity planning and resource expansion through data aggregation and analysis.
Work with management and clients to ensure that reports and metrics identify business needs and opportunities for process improvement.
Identify inefficiencies in the database platform and provide solutions to the management.
Develop time estimates for assigned tasks.
Handle performance and latency related issues.
Use problem-solving skills to assist in resolution of business problems.
Develop analytical skills to resolve technical problems.
Identify root causes for problems and propose solutions to prevent recurring.
Requirements:
7+ years MS SQL experience.
Thorough understanding of database structures, theories, principles, & practices.
Ability to write & troubleshoot SQL code & design stored procedures, functions, tables, views, triggers, indexes, & constraints.
Extensive knowledge of MS SQL Server 2005/2008/2012.
Extensive knowledge of SSIS/SSRS.
Experience with C#/ASP.NET
Technical knowledge of MS SQL Server internals with emphasis on query performance.
US Citizens and those authorized to work in the US are encouraged to apply.
We are unable to sponsor any candidates at this time.
What will make us hire you right away? (including the above)
Pharmaceutical marketing or general marketing experience
MVC experience
Excel experience
We need someone flexible, but focused on data... is this you?

Don't Be Fooled

The fraudster will send a check to the victim who has accepted a job. The check can be for multiple reasons such as signing bonus, supplies, etc. The victim will be instructed to deposit the check and use the money for any of these reasons and then instructed to send the remaining funds to the fraudster. The check will bounce and the victim is left responsible.

More Jobs

Java Full Stack Developer-Whippany
Whippany, NJ Apex Systems Inc
C++ Developer
Edison, NJ Mitchell/Martin, Inc.
Client Development: Become a Retention Special...
West Orange, NJ DISH
Sr Scientist II - Treat Platform Product Devel...
East Hanover, NJ Mondelez International-
Specialist V-software development specialist
Iselin, NJ Mott MacDonald