We are seeking an experienced BI Developer to be part of a transforming and growing IT department. Vitacost is "Business Intelligent" hungry. We are small but nimble. Smart intelligence helps drive the day-to-day business. You want to become the "right hand person" for our head of business intelligence. Together you will help architect robust cubes, build customer and item masters, and generally have an impact through-out all major departments of the business'you will be appreciated! |
Joining this team means you are technically oriented and business savvy. You like spending most of your days working on technical report building'through cubes and ad-hoc one-offs. You strive for data quality and integrity. We are process-oriented but entrepreneurial'so we operate processes and methodologies that improve outcome and impact.
Essential Duties and Responsibilities:
Perform database design for decision support systems Analyze, design, build, query and maintain cubes using Microsoft SQL SSAS and MDX query language.
Implement and support requested application database development changes in the Microsoft SQL Server and Windows Server 2008/R2 environments.
Evaluate and recommend database-related software products within technical architecture framework.
Work with business analysts, other team members and clients to review the business requirements and prepare technical design documents, including the documentation of extended use cases, class diagrams, collaboration diagrams, sequence diagrams and non-functional and functional prototypes, as needed.
Troubleshoot and recommend technical solutions for customer issues related to database configuration and performance.
As "2nd in command" of the BI department, help define duties and responsibilities of team members inside and outside the department to optimize outcomes.
Advanced knowledge and experience with MS SQL Server 2008/R2 is required.
Understanding of Relational and Dimensional Modeling.
3+ years' experience in most all of the following:
oSQL Server Analysis Services,
SQL Server Integration Services
Experience in enhancing/developing complex stored procedures.
Experience in enhancing/developing new/existing complex SSIS packages (ETL) is required.
Performance tuning stored procedures and ETL processes.
Experience with Master Data Services in SQL Server.
Development experience in Visual Basic .NET or C#
Understanding of Team Foundation Server
Familiarity with object-oriented programming methods is a plus.
Experience with SharePoint 2010 is a plus.
VLDB experience is a plus.
Complexity of Work: The ideal candidate will be deadline focused, detail oriented, well organized and self-motivated along with the ability to juggle multiple projects simultaneously and manage time efficiently.
Education: Bachelor's degree in Computer Science, mathematics or related subject required.
Experience: 5-7 years of work experience in a similarly focused BI environment.
Knowledge, Skills and Abilities:
Considerable knowledge of modern office practices and office management
Considerable knowledge of business English, spelling, grammar and math
Considerable knowledge of computer, media, phone, peripheral office equipment and word processing software such as MS Office, etc.
Skill in handling multiple tasks at one time and able to prioritize accordingly
Skill in dealing with difficult clients or customers.
Ability to communicate effectively, both verbal and written
Ability to work independently on complex and confidential tasks
Ability to handle stressful situations
Ability to establish and maintain effective working relationships with employees.
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
While performing the duties of this job, the employee is regularly required to sit, use hands to handle or feel objects, tools or controls, frequently talk or hear, reach with hands and arms occasionally required to stand, stoop, kneel, crouch or crawl. The employee must occasionally lift and/or move up to 10 pounds. Specific vision abilities required by this job include: close vision.
Vitacost.com - 2 years ago