Business Intelligence Architect Job Description
Business intelligence architect
provides hands-on participation with common analytics and data warehousing concepts & technologies such as data marts, star schemas, facts and dimensions.
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:
Work in the project lifecycle including design and development of MDM solutions
Develop and ensure compliance with data modeling best practices and standards
Mentor junior IT staff as needed to develop data analysis and data modeling skills
Develops or manages development of automated governance tools quality gates checks
Developing/delivering the architecture solution including software development, database/data warehouse and Business Intelligence
Ensuring data quality engineering, metadata consolidation and integration, meta-model development and maintenance
Design logical Data Warehouse architecture and data model, implement physical Data Warehouse design (schema, indexes, partitions)
Design ETL architecture including CDC, mappings, data flows, procedures, schedules
A certain degree of creativity and latitude is required flexibility in job role and working hours during critical deliveries
Documentation of all work carried out, data models, configurations, and setup
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:
Development
Claims/Encounters processing
Client/Server concepts and how they work within network environments
Data warehousing concepts
ETL processes
Procedure Codes
Provider Organizations
RVU’s
Windows operating systems and MS Office tools/applications
Data modeling
Desired experience for business intelligence architect includes:
Strong skills and experience in of Qlikview, Cognos or other data visualization tools
Experience in utilizing a Business Intelligence Platform (MicroStrategy a plus)
Experience in relational database design and usage, dimensional, star-schema models
Experience deploying Hadoop for operational, production, and test/lab purposes
Experience using the Hadoop tool set such as Sqoop, Oozie, Flume, Yarn, (3+ years)
2+ years of experience in Big Data solutions based on Hadoop, Cassandra, HBase
Business Intelligence Architect Examples
1
Business Intelligence Architect Job Description
Job Description Example
Our growing company is hiring for a business intelligence architect. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for business intelligence architect
- 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
Qualifications for business intelligence architect
- 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
2
Business Intelligence Architect Job Description
Job Description Example
Our growing company is hiring for a business intelligence architect. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for business intelligence architect
- 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
Qualifications for business intelligence architect
- 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
3
Business Intelligence Architect Job Description
Job Description Example
Our innovative and growing company is searching for experienced candidates for the position of business intelligence architect. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for business intelligence architect
- 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
Qualifications for business intelligence architect
- 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
4
Business Intelligence Architect Job Description
Job Description Example
Our growing company is hiring for a business intelligence architect. Please review the list of responsibilities and qualifications. While this is our ideal list, we will consider candidates that do not necessarily have all of the qualifications, but have sufficient experience and talent.
Responsibilities for business intelligence architect
- 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
Qualifications for business intelligence architect
- 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
5
Business Intelligence Architect Job Description
Job Description Example
Our growing company is hiring for a business intelligence architect. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for business intelligence architect
- 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
Qualifications for business intelligence architect
- 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)