Data Warehouse (ETL) Solution Architect

Data Warehouse (ETL) Solution Architect

MarketSphere Consulting. What we do.

MarketSphere Consulting is a business consulting firm with services tailored to help companies achieve their desired strategic, financial and organizational goals. Through a broad complement of market, operations, and technology solutions. MarketSphere provides deep expertise in all stages of the project lifecycle, from strategy and design through implementation and support, for companies and industries in our local markets.

Local Offices. Where you'll find us.

MarketSphere has offices in Chicago, Kansas City, Omaha, Indianapolis, St. Louis and Pittsburgh. Because of our strong commitment to the markets we serve, the majority of our employees live in the communities in which they work.

People. Who we are.

MarketSphere consultants represent the best talent in the consulting business. By demonstrating leadership and project ownership-as well as a commitment to developing others-MarketSphere consultants utilize their competencies every day. Through a variety of opportunities and responsibilities, consultants are encouraged and supported in defining their career goals and objectives. The business casual environment supports a balanced lifestyle, meeting the needs of both clients and employees.

Job Summary. What we're looking for.

We are currently looking for a Solution Architect to join our BI/EPM Practice. This is a technical leadership position with our practice and a high growth opportunity as well. The candidate must have 4+ years of experience with Data Warehousing. It would be ideal if the candidate has DW experience in an Oracle environment. The candidate should have several years of experience with an ETL tool such as Informatica or Oracle Warehouse Builder. It would be extremely helpful if the individual has development experience in an Unix or Linux environment. It would also be very good if the candidate has ETL administration, source-to-target mappings, deployments, Oracle Workflow and Cron. It would be a plus if the candidate has experience with tools such as: Oracle Enterprise Manager (OEM) or Toad. Candidate should have strong technical knowledge in SQL, PL/SQL and be able to write complex business rules and transformation in ETL. Ability to develop unit, system and integration test plans, execute and document the results. It would also be a plus to have exposure to other BI tools including: Cognos, Hyperion, OBIEE(Siebel Analytics), Microsoft BI, and Outlooksoft. There will definitely be an opportunity to learn additional tools through MarketSphere training. It would be very helpful if the candidate has solid experience with Data Management. Any experience with ERP systems would be a plus as well. It would be ideal if the candidate has exposure to EBS Oracle 11i.

Please Apply with Ryan McKigney at ryan.mckigney@marketsphere.com