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?Estimated Salary: $20 to $28 per hour based on qualifications.
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?Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
