Software Engineer I (OLAP Development)
2009090
Job Description
This is a key database development position in MSA’s largest division. For the right candidate it offers a tremendous opportunity for career growth in an IT-based organization, the chance to work closely with advanced database technologies and systems, and the potential to be involved in the building of custom database and software application platforms.
The primary responsibilities for this position include, but are not limited to:
- Design and development of Analysis Services OLAP cubes for multiple production environments
- Troubleshoot multiple production environments
- Perform R&D on new functionality
- Serve as an in-house expert with this technology
- Assist with developing customized functionality for MSA’s proprietary reporting application that relies on Analysis Services datasets
Required Skills
- Four-year degree in Computer Science/Information Technology, Computer/Electrical Engineering or related discipline, or equivalent experience
- Minimum three years of experience in software and/or OLAP DB programming, addressing unique issues of architecture and data management
- Minimum two years of experience with Microsoft’s SQL Server Analysis Services OLAP engine, including: designing cubes, optimizing for build efficiency, optimizing for query efficiency, working directly within the BIDS interface, and working with it programmatically
- Strong MDX querying skills and SQL querying skills, preferably in an Oracle environment
- Clear understanding of, and experience in, data warehouse modeling. Including star-schema and snow-flake schema designs and dimensional and fact table modeling concepts
- Experience in development and performance tuning related to large data volume
- Knowledge of relational databases, Structured Query Language (SQL), and Unix operating system
- Knowledge and experience of all aspects of the software development process
- Experience working in integrated product development team environment
- Ability to work independently on multiple tasks
- Excellent organizational and communication skills, both oral and written, with a focus on the ability to write functional and technical specification
- Experience in relational databases (particularly Oracle and PL/SQL), UNIX and LINUX environments, and OLAP reporting tools desired
- .Net, C#, and MS Reporting Services desired
- Ability to work independently, but also in other situations closely with other peer developers, QA team members, and production support members on complex development tasks is essential
- Ideal candidate will have a strong technical background with Microsoft’s Analysis Services engine; be familiar with advanced tuning techniques for cube builds and querying; have expertise with both the MDX query language and SQL querying
As an international industry leader, we can offer you an exceptional working environment, salary commensurate with experience and an incredible benefits package including:
- Flexible working hours
- Casual dress
- Profit Sharing & Savings Plan (401K with matching funds)
- On-site massages
- A Floating Holiday in addition to Vacation and Eight Paid Holidays
- Free Parking
- Cash Bonuses paid for employee referrals
- Health, Dental, and Vision Plans, and Short and Long Term Disability
MSA requests that you apply for this position through our web site to ensures efficient processing of your application. Submitting a resume by email, mail, fax or through the apply button on a resume web site will cause relevant information to be missed. Please use the following link to apply:
APPLY NOW
Your interest in our company is appreciated however, only candidates considered for interview selection will be notified.
Must Provide Base Salary Requirements Or Salary History For Further Consideration
EOE M/F/D/V
