Filter these job results to find a perfect match.
  • Keywords can include skills or a job number. If using multiple keywords, insert ‘or’ or ‘and’ between for best results (e.g. Java or Oracle)
  • Advanced Options...
  • X

Sr BI Data Warehouse Architect

  • Location: Billerica, MA
  • Start Date: 8/15/2019
  • Job ID: 19-00515
  • Posting Date: 8/15/2019
  • Job Type: Direct Placement
Continue to apply for this job >
Job Summary:
The BI/Data Warehouse Architect is responsible for providing advanced technical skill in the design, development, control and use of enterprise data. Perform analysis, design, data model, architecture definition, development/coding, testing, system application support, documentation and direct dba support in the Business Intelligence area. This position will be responsible for the end to end implementation and support of Reporting, Dashboard development and Data Warehouse. The position will require all the skills required to work independently and with team members on each task.
Essential Duties and Responsibilities:
  • Designs, builds and maintains data warehouse solutions to support Business Intelligence (BI) and Reporting projects using Oracle BI, SAP BO and any other middleware requested
  • Provides expertise and architectural leadership in the areas of Data Governance, Meta Data Management, Analytics, Data Warehousing, Scorecards, Dashboards, Business Performance Monitoring and Data Mining
  • Defines policies, procedures, and governance for the data warehouse/platform that is aligned with the overall BI strategy. Ensures consistent use of data architecture standards.
  • Supports new data development, ensuring consistency and integration with existing data warehouse structure. Develops processes for capturing and maintaining metadata from all data warehousing components
  • Translates user requirements into technical architecture vision and implementation plan.
  • Provide hands-on development of solutions; and supports the analysis and discovery processes
  • Other responsibilities as assigned
  • Requires a Bachelor's degree in Computer Science, CIS or a related field
  • 10 years production dba support of Microsoft SQL servers 2005/2008 and Oracle/Oracle RAC 8i/9i/10G/11G/12c
  • 5+ years of experience in development within a Business Intelligence/ enterprise data warehouse environment
  • 7+ years of working experience with Relational Databases
  • 7+ years of experience with SQL, Stored procedures, Functions and query writing
  • 5 years of experience with Data Modeling and tools
  • 5 years of experience with Dimensional modeling and implementing Cubes
  • 5 years of experience with Reporting Software
  • Data Architecture and Master Data Management principles
  • Data Warehousing and Business Intelligence tools
  • Familiar with Dashboard technology and delivering dashboards and reports via mobile applications
  • Experience in lean manufacturing environments a plus
Skills, Abilities, Competencies Required:
  • Excellent written and verbal communication skills
  • Able to work accurately in a fast-paced, ever-changing environment with strong attention to detail
  • Demonstrated ability to monitor own work to ensure quality, accuracy, and thoroughness.
  • Strong organizational, analytical, and time-management skills
  • Able to self-motivate and work both independently and as part of a team
  • Travel between facilities on as-needed basis roughly 25% of the time
Posted by Robyn Wolf
Technical Resource Manager
(800) 821-4644 x