Architect (BI DW) - Marlborough ,MA

Position ID: NAL-14-13

Type: Full Time
Interview Type: F2F

SUMMARY:

The Business Intelligence (“BI”) & Data Warehouse (“DW”) Architect is responsible for providing architectural guidance and roadmaps for DW/BI products and solutions. The incumbent is responsible for creating architectural blueprints for enterprise data warehouse and BI and providing guidance to BI teams on architectural concepts and standards. The incumbent is responsible for leading the design of the technical solution, including key considerations such as business relevance, scalability, reliability, maintainability, performance, security and impact to existing and dependent systems. The incumbent is responsible for DW and BI software solution design, development and documentation.

ESSENTIAL DUTIES:

• Create architectural blueprints for enterprise data warehouse and BI
• Align DW/BI architecture to enterprise architecture initiatives
• Provide guidance and direction to DW/BI team regarding architectural direction and initiatives
• Effectively apply enterprise architecture standards when delivering enterprise BI solutions
• Provide subject matter expertise across technology/functions and drive implementation of technology strategy and roadmap direction.
• Lead improvement initiatives which address opportunities and upcoming challenges
• Provide direction and assessment of new technologies and their potential benefit in relation to BI solutions
• Advocate use of project frameworks, re-usable components, methodology and procedures in the proposed solution and solution delivery process
• Provide consistent data and business models across multiple BI projects and solutions
• Maintain awareness of emerging technology and software trends as well as infrastructure tool sets across technology or functional domains
• Serve as key contributor in requirement gathering for complex projects
• Conduct ongoing performance monitoring and tuning of BI applications
• Review solutions designed by other team members
• Participate in data warehouse and BI software design, development, documentation and testing based on user requirement specification
• Mentor and coach team members 

OTHER:

• Other duties as assigned.

SUPERVISORY RESPONSIBILITIES:

• None.

QUALIFICATIONS: 

• Knowledge of data warehouse and BI architecture concepts
• Experienced in designing and implementing end–to-end BI solutions
• Strong technical documentation skills
• Strong presentation skills
• Excellent verbal and written communication skills
• Strong interpersonal skills
• Excellent organizational, detail and prioritization skills
• Excellent analytical and problem-solving skills
• Self-motivated, ability to work in a team and independently
• Expertise in IBM Cognos and/or Oracle OBIEE BI Tools
• Familiar with database administration
• Expertise with relational databases such as SQL Server, Oracle and multidimensional databases such as Essbase
• Knowledgeable with database tuning and optimization
• Strong knowledge of project lifecycle
• Strong documentation, process, and organizational skills
• Strong knowledge of software development standards and best practices
• The incumbent must be flexible as there may be workweeks that require more than 40 hours, and/or international travel, to ensure the positions expectations and responsibilities are met 

EDUCATION AND EXPERIENCE:

• Bachelor of Science in Computer Science or related field required
• At least 10 years experience in database design and in a diverse technical environment required
• At least five years experience in architecting and designing DW/BI solutions required
• Experience with use of relational data, OLAP data is required
• Experience with Oracle OBIEE, ETL tools and IBM Cognos tools is preferred
• Experience with Oracle prepackaged BI application is preferred

Primary Location

North America-USA-MA-Marlborough

Other Locations

North America-USA-MA-Woburn

Interested candidates can send resumes to jobs@nallas.com with position ID in subject line.