Business Intelligence Architect Job Description
Business Intelligence Architect Duties & Responsibilities
To write an effective business intelligence architect job description, begin by listing detailed duties, responsibilities and expectations. We have included business intelligence architect job description templates that you can modify and use.
Sample responsibilities for this position include:
Business Intelligence Architect Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Business Intelligence Architect
List any licenses or certifications required by the position: BI, MCSE, MCP, AWS, ITIL, PMP, SAP
Education for Business Intelligence Architect
Typically a job would require a certain level of education.
Employers hiring for the business intelligence architect job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Master's Degree in Computer Science, Business, Education, Engineering, Information Systems, Information Technology, Mathematics, Technical, Intelligence, Statistics
Skills for Business Intelligence Architect
Desired skills for business intelligence architect include:
Desired experience for business intelligence architect includes:
Business Intelligence Architect Examples
Business Intelligence Architect Job Description
- Responsible for preparing and delivering proposals and presentations lending support for key business development events such as Webinars, CIO Awards
- The role must maintain influential knowledge of industry trends and innovation for infrastructure supporting SAP BW, Teradata and cloud business intelligence technologies
- Directs the activities of hosting partners to design, develop, and coordinate the compatibility and integration of solution designs
- Develop partnerships and relationships within the organization with colleagues (including superiors, peers and subordinates), with clients, partners and other business associates outside of the Company
- Plays a role of master data application owner for master data domain, acts as a SPOC for IT and Business partners covering all topics related to the domain
- Analyze business requirements and provide end-to-end solution design for respective data foundation builds including but not limited Data Marts, Data Feeds, Data Warehouse Subject Areas
- Designing/developing data warehouse approaches and data repositories (terabyte scale or larger)
- Ensuring repository management, data warehouse design and data mining, data security administration, and formulation of enterprise-specific data metrics
- Be a part of critical and/or strategic projects prioritized projects and be prepared to be considered for these projects
- Participate in reviews of architecture concepts and solutions
- Experience in deriving physical data models from a logical data model reverse engineering a physical data model from a physical database
- Extensive data mapping and modelling experience
- The leader must have ability to influence direction and balance challenging trade-offs between alternative architectures, time to deliver, and cost of ownership
- 5+ years of experience in of Qlikview, Cognos, or other data visualization tools
- Very strong understanding of Data Warehousing theory (both Kimball and Inmon approaches), deep understanding of Big Data architecture and unstructured data analysis approach
- Previous working experience in a digital data environment, providing BI solutions
Business Intelligence Architect Job Description
- Support reduction of complexity in business processes, information, applications, integration and infrastructure
- Lead competence networks and communities both locally and globally
- Collaborate effectively with other Architects to solve cross solutions problem spanning their respective areas and resolve technological disagreement with informed, rational solutions
- Project ownership and coordination end to end
- Contribute to, and drive the adoption of patterns and standards, building our library of repeatable solutions
- Provision of timely architectural insight to relevant projects and initiatives
- Solutions delivered fit with the Digital & Technology IT Roadmap and adhere to the defined Enterprise Architecture standards
- Engagement levels with projects is at or above agreed capitalisation rate
- Progress made towards the achievement of the target architecture
- Recognised authority on Enterprise Architecture by both the business and Digital & Technology division
- 10+ years’ experience in information technology, with at least 5 years of experience leading and delivering complex BI initiatives on the enterprise level
- Other Tools / Applications
- Experience in leading indirect resources/teams preferred, Business/Systems Analyst/Project Management experience in a footwear/ apparel industry preferred
- Proven ability to gather and interpret business requirements
- Hands-on experience with at least one of major BI platforms (Business Objects, OBIEE, Hadoop) familiarity with some emerging data analytics tools (Tableau, Spotfire, QlikView)
- Establishes building a technical BI vision, strategy and executable roadmaps (3-5 years) based on strategic company business direction Enterprise architecture standards/methodologies with clear articulation of benefits, costs and risk
Business Intelligence Architect Job Description
- Provides technical training to external team members to encourage cross-department connections including the development and maintenance of standard operating procedures
- Experience with ERP integration
- Knowledge of Oracle's prebuilt BI Applications (OBIA) for E-Business Suite, Siebel, OTM or PeopleSoft is highly desirable
- Experience with the different configuration options that exist for failover, load balancing, caching, security, with respect to OBIEE
- Experience with customizing the functional setups of OBIA & ETL Mappings (Pre-Packaged Analytics) for modules like Financial, SCM, and HRMS
- SME in Industry leading ETL/Data Integration tools
- Well versed with Linux (or other flavors of Unix) operating system and should be comfortable in writing shell script
- Perform Project Design Authority (PDA) role of applicable systems
- Responsible for project phasing and reviewing key technical and project artifacts throughout project lifecycle, including requirements, interfaces, design reviews, integration plans, test plans and deployment strategies
- Leads technical direction and support to implementation teams in developing these artifacts as necessary
- Demonstrated success in building a technical BI vision, strategy and executable roadmap based on strategic company business direction Enterprise architecture principles with clear articulation of benefits, costs and risk
- Bachelor's degree in Computer Science, Information Systems, Business, or other relevant subject area preferred
- 10 years of progressive experience delivering business intelligence solutions preferred
- Deep knowledge and hands on creation of key artifacts including uses cases, user stories, user acceptance criteria, functional and technical specifications, configuration stories or specifications
- 3 years experience with large databases such as Oracle or Teradata preferred
- Experience with SAP Business Objects & BW is preferred
Business Intelligence Architect Job Description
- Work extensively with Executive Business stakeholders to understand their organizations, processes and business needs
- Be a thought leader on future data and application use and be a catalyst for converting data into a knowledge base of desired future states
- Participate in Architecture Review Board meetings
- Leads MicroStrategy administration and is responsible for overall MicroStrategy architecture, design and implementation
- Appropriately utilize administration tools and functionality of MicroStrategy 10, including Enterprise Manager, Object Manager and Integrity Manager
- Performs MicroStrategy platform upgrades and manages all aspects of the upgrade including planning, testing, communication and execution
- Supports the compilation and rollout of custom MicroStrategy mobile app within the internal app store
- Drive metric definition and troubleshooting for application performance criteria and lead solutioning to optimize performance
- Manage system related metrics and performance management dashboards for the overall health of the MicroStrategy environment
- Proactively manage MicroStrategy related issues and communicate to appropriate people prior to the issue being discovered by the user community
- Extensive experience working with BI Tools
- Experience with Geographic Information Systems, ESRI & Cognos
- Dimensional data model design, ETL/ELT frameworks and processing, metadata management, operational data integration, master data definition and data quality, data auditing and profiling, business intelligence reporting solutions, and dashboard solutions
- Gather requirements from the business community
- Provide resource estimates for user requests
- Perform feasibility analysis on user requirements
Business Intelligence Architect Job Description
- For the design and delivery of data solutions to empower data migration initiatives, BI initiatives, dashboards development
- For the design of ETL processes and able to explore the POC/prototype options
- Responsible for supporting and enhancing MicroStrategy custom portal
- Collaborate with IT colleagues and business users to gather requirements and lead design sessions
- Assessing the as-is
- Describing to-be state, requirements, principles and models
- Building up Roadmap and managing it
- Creating, Streamlining and maintaining MicroStrategy BI dashboards, documents, MSTR Schema creation, advanced reporting
- Develops Public Objects like reports, filters, prompts, metrics, templates, consolidations, custom groups, cubes
- Monitor the database system in order to guarantee optimal performance and proactively recommend corrective actions when issues are identified
- Identify data needs to complete a project
- Ten years experience in database technologies such as Microsoft Structured Query Language (SQL)/Server and/or Oracle, reporting tools such as Microsoft SQL Server Reporting Services (SSRS) and/or Tableau, Extract Transform Load (ETL) tools such as Microsoft SQL Server Integration Services (SSIS) and/or Informatica, data warehousing business intelligence architecting, designing, and modeling of data
- Ability to design data warehouse
- Experience with master data, big data and data mining are a plus
- Knowledge of design patterns and UML
- Support alignment efforts across multiple BI tracks at Stanford (HR, Sponsored Research, Student)