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.

BA BI - Marlborough, MA

Position ID: NAL-14-13

Type: Full Time
Interview Type: F2F

SUMMARY:

The Business Analyst for Global Business Intelligence (BI BA) provides broad functional and technical expertise within multiple business areas in the review, analysis, development and implementation of business processes and applications with minimal supervision.  The incumbent will be responsible for designing, implementing and modifying reporting systems, specifically focusing on OBIEE, Cognos, TM1, and other tools that may be utilized in the future. The incumbent will work closely with business leaders worldwide to understand critical information needs and translate them into reporting solutions.  The BI BA provides guidance to business team members on the availability of data, the capability of systems to deliver information needs, and provides subject matter expertise regarding current systems.

 The BI BA is responsible for the gathering and analysis of business information needs, the preparation of system requirement documentation, testing, and transition to end users.   The incumbent may perform specified project management related activities as well.  The ideal candidate will have a solid background in business intelligence needs throughout business areas, data warehousing, ETL and modeling, reporting and dashboard development, strategic data analysis, and generating actionable business insights.

ESSENTIAL FUNCTIONS:

• Focuses on reporting needs for assigned area(s) within the organization
• Consultant to Business Analysts in troubleshooting complex user and reporting application or data validation problems
• Provide functional and technical expertise within multiple business areas, and provide strategic, forward-looking vision when configuring or customizing solutions to maintain flexibility and future integration opportunities
• Provide consulting support on cross-functional reporting processes, reporting system issues, and the review, acquisition and implementation of new products
• Collect, document and analyze business requirements and functional specifications for complex cross-functional projects to provide the best reporting solutions for business needs
• Identify operational inefficiencies, conflicting business practices and integration issues, suggesting alternative solutions to cross-functional problems
• Develop business relationships and integrate project activities with project team members, primarily Quality Assurance and Software Developers, to ensure successful implementation and support of projects
• Track all project work through the enterprise project administrative tools, such as Oracle timesheets, Project Server, ALM, ticketing system, etc.and keep the project manager informed of any issues
• Create or assist with the creation and execution of test scripts to ensure that reporting issues are minimal after implementation of new enhancements, changes or upgrades
• Maintains knowledge of software tools that effectively support the data warehouse environment

 OTHER:

• Other duties as assigned

SUPERVISORY RESPONSIBILITIES:

• None

QUALIFICATIONS:

• Solid knowledge of information technologies and methodologies, particularly with implementations of Oracle Business Intelligence Enterprise Edition, Cognos or TM1, leveraging several disparate data sources, including Oracle eBusiness Suite and custom applications
• Two  or more  years of recent BI experience with Cognos Business Intelligence products
• Possesses strong working knowledge of application systems providing source data as well as BI front end tools
• Understanding of the business and key performance indicators (KPIs), and their direct relationship/translation into business intelligence needs
• Proficient in project management techniques and experience on cross functional projects
• Excellent organizational skills
• Strong problem solving skills
• Excellent written and oral communication skills
• Strong computer skills including Microsoft Office, Microsoft Project and Visio
• Detail oriented, able to multitask and meet deadlines
• Self-directed, able to inspire a team and work independently with minimal direction
• Understanding of relational databases and query tools
• Ability to support multiple applications or modules and multiple business groups
• Ability to understand business concepts and determine the impact of business changes on systems
• If supporting Oracle applications,         
• Working knowledge of Oracle E-Business Suite
• Conceptual knowledge of Oracle methodologies
• 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’s degree or related experience  required
• Minimum of four years professional experience in business analysis, application design, implementation, and support in an online environment required
• Previous work experience supporting international teams 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

BI Designer - Marlborough ,MA

Position ID: NAL-14-12

Type: Full Time
Interview Type: F2F

SUMMARY:

The Business Intelligence (“BI”) Designer provides expertise in BI software development tools and modeling techniques. The incumbent understands physical data models and creates BI logical and presentation models to meet business reporting and analytics requirements. The incumbent must proficient in relational and dimensional modeling techniques in order to create optimal BI models that are easy to present in dashboards and reports. The incumbent is expected to be an expert in BI modeling tools such as Cognos Framework Manager and/or Oracle OBIEE repository design. The incumbent is responsible for BI software design, development, testing and documentation.

Qualifications

ESSENTIAL DUTIES:

• Design, development, document and test BI software based on user requirement specification
• Design and develop BI models (star schemas, cubes, subject areas) using tools such as Cognos Framework Manager and OBIEE RPD (repository) designer
• Work closely with data modelers, reports and analytics developers and bridges the gap between the two disciplines
• Structure data for optimal presentation, access, performance, and integration
• Implement and maintain object level and data level security
• Document the metadata and data dictionary in collaboration with Business Analysts
• Document all processes and support source code control using standard tools and processes
• Maintain current knowledge of the technology industry, including leading tools and best practices
• Set standards for technical documentation
• Maintain BI objects, catalog, and folder
• Work closely with BI administrators in production support and maintenance 

OTHER:

• Other duties as assigned. 

SUPERVISORY RESPONSIBILITIES:

• None 

QUALIFICATIONS:

• Strong Knowledge of BI concepts     
• Excellent data analysis skills
• Strong knowledge of ETL best practices with hands-on experience.
• Development and programming experience in Data Warehouse technologies
• Excellent verbal and written communication skills
• Strong interpersonal skills
• Excellent organizational, detail and prioritization skills
• Excellent analytical and problem-solving skills
• Ability to multi-task while meeting deadlines
• Self-motivated, ability to work in a team and independently
• Familiar with database administration
• Strong knowledge of project lifecycle
• Strong presentation skills
• Strong documentation, process, and organizational skills
• Strong knowledge of software development standards and best practicesThe 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 BI design and in a diverse technical environment preferred
• At least five years of BI Design and development experience required
• Experience with Cognos Framework Manager and/or OBIEE repository design required
• Experience with Oracle Prepackaged BI Application preferred 

ENVIRONMENT:

• Approximately 100% performed in climate-controlled internal office environment working under normal office conditions.  0-10% domestic travel, and 10-20% of international travel in support of relationship building and collaboration with business teams. 
• While performing the duties of this job, the employee is regularly required to sit, stand, walk, use hands and fingers to feel and handle, reach with arms and hands, talk, and hear. While performing the duties of this job, the employee frequently is required to stoop, kneel and crouch, lift weight or exert a force up to a maximum of 25 pounds. 

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

ETL Developer - Marlborough, MA

Position ID: NAL-14-11

Type: Full Time
Interview Type: F2F

  

ETL Developer 

SUMMARY:

The ETL Developer provides expertise in data mapping from transactional application to data warehouse and creation of Extract, Transform and Load (“ETL”) software programs.  The incumbent will be responsible for designing, developing, testing and documenting ETL programs. The incumbent will be responsible for creating and maintaining logical and physical data models using established enterprise tools and best practices. The incumbent is expected to have solid understanding of database design principles as well as database administration methods and techniques.

Qualifications

ESSENTIAL DUTIES:

• Develop and maintain ETL processes that meet project-specific business and technical requirements and those of the overall enterprise data warehouse data integration portfolio
• Document all processes and support source code control using standard tools and processes
• Perform transactional applications (source) to data warehouse (target) data mapping
• Maintain current knowledge of the technology industry, including leading tools and best practices
• Perform data integrity checks and data validations
• Assist with ensuring the integrity and performance of data structures
• Set standards for technical documentation

OTHER:

• Other duties as assigned. 

SUPERVISORY RESPONSIBILITIES:

• None 

QUALIFICATIONS:

• Strong database management skills
• Excellent data analysis skills
• Strong knowledge of ETL best practices with hands-on experience
• Development and programming experience in Data Warehouse technologies
• Excellent verbal and written communication skills
• Strong interpersonal skills
• Excellent organizational, detail and prioritization skills
• Excellent analytical and problem-solving skills
• Ability to multi-task while meeting deadlines
• Self-motivated, ability to work in a team and independently
• Familiar with database administration
• Strong knowledge of project lifecycle
• Strong presentation skills
• 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 preferred.
• At least five years of ETL and database development experience required
• Experience with Informatica, ODI, SSIS or other equivalent ETL tools preferred
• Experience with Oracle Prepackaged BI Application preferred

ENVIRONMENT:

• Approximately 100% performed in climate-controlled internal office environment working under normal office conditions.  0-10% domestic travel, and 10-20% of international travel in support of relationship building and collaboration with business teams
• While performing the duties of this job, the employee is regularly required to sit, stand, walk, use hands and fingers to feel and handle, reach with arms and hands, talk, and hear. While performing the duties of this job, the employee frequently is required to stoop, kneel and crouch; lift weight or exert a force up to a maximum of 25 pounds. 

Primary Location

North America-USA-MA-Marlborough

Other Locations

North America-USA-MA-Woburn

Travel

Yes, 25 % of the Time

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