Data Doghouse - performance management, business intelligence, and data warehousing

Data Warehousing Jobs: BI Architect

Business Intelligence Architect (SAP BusinessObjects) - Consulting Assignment, Boston MA area

Athena IT Solutions is looking for a BI architect. Please feel free to forward this job listing to your friends and colleagues.

BI Architect Job Description:

Join a high performance consulting team designing, developing and deploying a business intelligence and data warehousing project. Provide leadership and direction on BI portion of project.

BI Architect Job Details:

• Create dashboard design patterns, standards, and templates
• Design and implement caching and performance architecture for BI tools
• Hands-on development using WebIntelligence & Dashboard Builder to create initial dashboards & reports and use as standard templates
• Define overall universe design and standards
• Define and implement universe management procedures
• Design and implement universe subject areas
• Design and implement BI metadata and data dictionary design and standards
• Knowledge of dimensional modeling design and principles
• Experience in supervising and/or managing a staff is preferred; the staff includes both on-site and global virtual team members.
• Strong leadership skills with the ability to adapt to challenges and to mentor team members.
• Strong communications skills both orally and written. Ability to write reports, documentation and. Ability to speak effectively before groups of business and IT personnel.

BI Architect Skills & Experience:

• 5+ years of BI implementations at Fortune 1000 companies
• 3+ years experience with SAP BusinessObjects BI toolset with at least their Universe and two of the following tools: WebIntelligence, Dashboard Builder or Xcelsius
• Need to have worked with Microsoft SQL Server, flat files and other databases

BI Architect Job Location: Greater Boston vicinity

BI Architect Job Duration: Consulting assignment. Potentially up to a year.

Please send your resume and cover letter to jobs@athena-solutions.com.

Data Warehousing Jobs: ETL Architect

ETL Architect (Informatica PowerCenter 9) - Consulting Assignment, Boston MA area

Athena IT Solutions is looking for an ETL architect. Please feel free to forward this job listing to your friends and colleagues.

ETL Architect Job description:

Join a high performance consulting team designing, developing and deploying a business intelligence and data warehousing project. Provide leadership and direction on ETL portion of project using Informatica PowerCenter 9, data services and potentially Informatica Cloud. SQL Server 2008 is being used as data warehouse with a variety of databases, applications and flat files as data sources.

ETL Architect Job Details:

• Hands-on development using Informatica PowerCenter to create initial ETL load routines and establish standard and templates
• Create design pattern templates for deliverable objects
• Define and implement ETL development standards and procedures
• Define and implement ETL tool configuration
• Ensure effective ETL functional decomposition into deliverable objects
• Ensure ETL quality through inspections and knowledge sharing
• Strong analysis and design skill
• Strong experience with business intelligence and data warehousing design principles and industry best practices.
• Deep understanding of relational database design concepts and SQL programming.

ETL Architect Skills & Experience:

• 7+ years of ETL implementations at Fortune 1000 companies
• 5+ years experience with Informatica PowerCenter

ETL Architect Job Location: Greater Boston vicinity

ETL Architect Job Duration: Consulting assignment. Potentially up to a year.

Please send your resume and cover letter to jobs@athena-solutions.com.

Podcast: New technologies, techniques for on-premise and SaaS data integration

My latest podcast: New technologies, techniques for on-premise and SaaS data integration

Software as a Service (SaaS) data integration is an emerging technology some companies are turning to for solving their data integration challenges and problems. But is SaaS data integration right for your business or is traditional, on-premise data integration software a better fit?

To get you on the right track with SaaS data integration technology, this podcast discusses the current and future state of SaaS integration, how it compares to on-premise data integration technology in more. Learn about the pros and cons of different approaches to SaaS and on-premise data integration, including on-premise vs. hosted middleware and internal integration vs. hiring a services provider. Also, get an expert take on the types of SaaS integration tools that are available and the key questions you should ask vendors.

In this twelve-minute podcast listeners will:

• Learn about the current state of SaaS data integration technology, it's current maturity level and how it compares to on-premise integration products (1:06)
• Find out if SaaS data integration is still geared to small and midsize businesses or if enterprises can also benefit from the technology (3:25)
• Hear about pros and cons of using SaaS integration tools as opposed to on-premise software and some key items to consider when deciding on which to go with (5:18)
• Learn if their data integration work should be conducted by an internal team or outsources to an integration services provider (6:36)
• Hear key questions to ask SaaS data integration vendors during the software evaluation phase of the implementation (7:47)
• Other SaaS data integration concepts and things to consider (9:14)

Download: New technologies, techniques for on-premise and SaaS data integration