iVantage Group is looking for a Data Warehouse Engineer to join our client’s Data Operations team. The Data Warehouse Engineer (DWE) is responsible for the full life cycle of back-end development of the data warehouse. Responsibilities include the development of ETL processes, dimensional design of the table structure, cube development for performance, and database administration. The DWE will work closely with the Business Analyst to work through business requirements and develop processes necessary to provide visibility into the data via the centralized data warehouse and reporting platform. The DWE will also work closely with the front-end developers to ensure data that is being brought in and managed is clean, accurate, available, and complete. The DWE will help to ensure the data warehouse processes are running optimally.
If you're the type of person that keeps your skills sharp, is constantly reading about new technology and participates in online communities for database administrators then you're the type of person we are looking for.
Responsibilities:
- Design and support the database and table schemas for new and evolving sources of data being brought into the data warehouse.
- Create and support the ETL to facilitate bringing data into the data warehouse using SSIS.
- Create and support the Analysis Services 2008 cubes to help with query performance.
- Monitor and troubleshoot performance issues on the data warehouse servers.
- Follow the design principles and best practices defined by the team for data warehousing techniques and architecture.
- Participate in an on-call rotation.
- Participate in monthly production code pushes after regular business hours.
Requirements:
- B.S. degree in Computer Science, Information Technology, or equivalent experience.
- A passion for relational databases and dimensional modeling.
- Strong SQL development skills.
- Understanding of database de-normalization, star schema and snowflake schema.
- 2+ Years development with a relational database (SQL Server, Oracle or similar).
- Must be a self starter who enjoys solving challenging problems.
Additional Desired Skills:
- Experience working with the MDX query language.
Platforms & Tools We Use:
- Microsoft SQL Server 2008 (T-SQL).
- Microsoft SQL Server 2008 Analysis Services (MDX).
- Microsoft Business Intelligence Development Studio.
- SQL Server Reporting Services.
Please send resumes to Gina Maurino at gmaurino@theivantagegroup.com or apply online at www.theivantagegroup.com
