Blog

SQL Server DWH Opportunity

Summary:
The Analyst is responsible for analyzing business procedures and problems to define data, data structures and algorithms for data saved to and extracted from the systems database.

Essential Duties:

• Analyzes, designs and implements accurate, secure, efficient, logical and physical databases and coordinates database development applying knowledge of database design standards and database management system.
• Identifies and resolves production and/or applications development problems related to the use of the
• Database management system and end-user application software or utilities.
• Reviews project request describing database user needs.
• Studies existing data handling systems to evaluate effectiveness and develops new systems to improve production or workflow as required.
• Specifies in detail logical and/or mathematical operations to be performed by various equipment units and/or comprehensive computer programs, and operations to be performed by personnel in system.
• Estimates time and cost required to accomplish project.
• Determines if project requires creating series of new programs or modifying existing programs that access data stored in databases.
• Attends specifications meeting with project team workers to determine scope and limitations of project.
• Reviews procedures in database management system manuals for making changes to database, such as defining, creating, revising, and controlling database.
• Revises company definition of data as defined in data dictionary (information about data, including name, description, source of data item, and key words for categorizing and searching for data item descriptions).
• Determines and enters changes to data dictionary descriptions, including type, structure, and intended use of data within system, or assigns data entry work to programmer.

Job Requirements:

• Strong inter-personal and communication skills; capable of mentoring staff, acting as a vendor liaison, making presentations/leading meetings, and working closely with management.
• Ability to solve problems quickly and completely.
• Ability to identify tasks which require automation and automate them.
• A solid understanding of computer technologies and the direction of new technologies.
• Ability to plan and organize effectively.
• A solid understanding of the reinsurance and how technology can be applied to improve the business process.
• Maintains confidentiality of company-sensitive data.
• Keeps the Director informed of activities and situations, which will impact the achievement of corporate, and department goals and objectives.
• Performs other related duties as required to achieve the goals and objectives of the company and department.

Technical/Experience Requirements:

• Must have strong development life-cycle experience
• Must have SQL development experience with large databases
• Must have experience with a high level programming language in the development and delivery of complex software projects.
• Must have the ability to communicate clearly, concisely to non technical audiences

Supervisory Responsibilities: This position may have Supervisory Responsibilities

Contact: Jen Perri

The Word on the Street (Teradata, Netezza, Vertica, ParAccel, Greenplum)

As I venture into my new skunk works “developing a sentiment based analysis platform”, I started investigating Google Insight to see what the search volumes are with regard to a few of the competing database technologies. My interest is

Investment Bank looking for Netezza Resource

Folks,

I just came in contact with a pretty good technical recruiter. He seems genuinely passionate about his career and asked me if I knew any hands-on Netezza resources. I thought

The V-Stick is Coming

What do you get when you combine

• A bootable USB Stick
• A full blown Linux OS with GUI
• Evaluation Version of the Vertica Analytics database Fully installed and configured
• Apache/Tomcat Web Server
• LogiXML Dashboard Reporting
• Sample Data and Dashboards

Introducing the V-Stick

Powered by Vertica and LogiXML

We are currently putting the final touches on a sample dash-board and then will begin testing the Stick on different configurations. We have setup a forum specifically to support the V-Stick, so feel free to post your questions there.

Best Regards,

Charlie

Join the forum discussion on this post - (1) Posts

Vertica on a Stick

Can you believe it? A bootable 16 Gb thumb-drive with Linux, GUI, Vertica AND room for data!?

Yes, I admit it. I am a geek. But how cool is this. Imagine developing, prototyping, and presenting a data warehouse without procuring a server, installing Linux, or commandeering your hard drive. Everything you need is on a small bootable USB thumb-drive.

•