BI Architect Job Description
BI architect
provides technical leadership in data management: data modeling and db design, DWE Solution Architecture, data integration, data movement and replication, business intelligence, data quality, reference and master data management, data governance etc.
BI Architect Duties & Responsibilities
To write an effective BI architect job description, begin by listing detailed duties, responsibilities and expectations. We have included BI architect job description templates that you can modify and use.
Sample responsibilities for this position include:
Make tradeoffs between speed of delivery and data quality measures
Define and steward the Enterprise Data Lifecycle Management including data quality, data conversion, and data security technologies
Create and maintain a multi-year vision to drive the maturity of enterprise data assets
Manage and drive large cross departmental efforts and delivery teams involving ETL, BI, Data Warehouse, Java, SOA developers
Provide technical leadership, guidance, and support in the deployment of complex applications in distributed computing environments across the project lifecycle
Coordinate with BI analysts to understand business and reporting requirements to translate these needs into efficient data models (logical and physical), and lead the development of Integration, extraction, and transformation processes between operational systems and the DW
Develop, implement, and maintain data models and database designs to build data warehouses related to subject areas covering Retail Sales/Planning, Supply Chain, Customer Analytics, Finance, Merchandise Planning to share and disseminate data throughout the enterprise
Perform database administration, application performance tuning, workload management, DR (disaster recovery) strategy, application architecture
Pro-active monitoring & reporting on system performance KPI’s providing visibility into resource utilization of different workloads such as ETL & BI tool (MicroStrategy)
Database Development Loading/Unloading External tables, table distribution, skew detection/remediation, optimizing query plans
BI Architect Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for BI Architect
List any licenses or certifications required by the position: BI, ITIL, SAP, DRM, EPM, IMS, ERP, OBIEE, PMP, F&O
Education for BI Architect
Typically a job would require a certain level of education.
Employers hiring for the BI 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, Education, Business, Engineering, Technical, Information Technology, Information Systems, Mathematics, Management, Intelligence
Skills for BI Architect
Desired skills for BI architect include:
Data Governance
Data Lifecycle Management and Privacy Principles
Data Quality
SAP BW architecture and Data Workbench
ETL tools
Business Intelligence tools and architectures
DB2
Data modeling and understanding of different data structures and their benefits and limitations under particular use cases
Data modeling tools
Data warehousing tools and techniques
Desired experience for BI architect includes:
Pro-active capability planning to ensure the BI environment is scalable, extensible, and supportable for the future
Responsible for maintenance and timely upgrade EDW platform (IBM Netezza) & ETL platforms (Informatica)
Adhere to established project implementation and development guidelines and standards
Responsible for 24x7 critical support on the Production systems with on-call (on-site/offshore) support teams to ensure business SLA’s are not impacted
Serve as a mentor and coach to the entire BI team
Thought Leader and process champion to move Coca-Cola Global Bottling Investments Group (BIG) to SAP Hana platform
BI Architect Examples
1
BI Architect Job Description
Job Description Example
Our growing company is searching for experienced candidates for the position of BI 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 BI architect
- Providing SAP Business Intelligence (includes non- SAP systems) technical and architectural guidance to project and support teams and ensuring that there is a holistic strategic CokeOne and non-CokeOne BI architecture to support the business
- Provide specific recommendations and architectures for BW and HANA enabled functional solutions including HANA Live/Side-Car solutions, Predictive Analytics, BPC and ultimately reaching S4 Financials/Logistics
- Proactively monitor strategic direction of HANA partner Vendors, technology and market trends, and determine their potential impact and value to the enterprise
- Proactively monitor strategic capabilities that compliment SAP solutions including Tableau, Margin Minder, and other BI and Mobile solutions
- Provide oversight to the implementation of HANA and specifically first BW-on-Hana standards and/or other industry best practices for operational excellence and product development lifecycle methodologies (Agile, waterfall, ASAP)
- Lead technical integration efforts for mobile technologies and other SAP products such as SAP Analytics - SAP BW on HANA, SAP BOBJ & SAP BPC
- Lead organizational move into SAP Hana In-Memory computing with BW first then other SAP platforms
- This role requires close working relationship with BIG ARB (Architecture Review Board), executive business and IT leadership, internal customers, Business Alignment Teams and CokeOne Center of Excellence colleagues
- Works with BRM’s and senior functional leadership to provide guidance and recommendation in the early planning stages around the different solution patterns that may be appropriate for this specific solution
- Design and Develop BI Architecture, Conceptual Approach, Data Model, Integration with other Application platforms
Qualifications for BI architect
- At least 10 years experience in BI/BW Architect
- Bachelor's degree, preferably in Computer Science, Computer Engineering, or related quantitative field
- Over 12 years of IT experience and 8 plus years of Relevant experience in implementing large scale Enterprise DW/BI Application both in the Traditional and BigData space
- Masters in Business Administration or Computer Science degree preferred
- Defines scope and business priorities for small-scale changes and may assist in larger scale scoping exercises
- Minimum 7 years of overall SAP BW/BI experience, including a minimum of 3 years experience in design and architecture
2
BI Architect Job Description
Job Description Example
Our company is growing rapidly and is looking to fill the role of BI architect. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for BI architect
- Writes specifications, develops architectural concepts and artifacts
- Develop specifications and standards for semantic layers Qlik Data Layer, Universes, SSAS Cubes and multidimensional models across all data environments
- Identify opportunities for new architectural initiatives
- A new foundation for an Enterprise Data Warehouse platform and architecture in the cloud
- Lead BI Architecture team meetings with BI team and key IT stakeholders
- Define and steward the Enterprise Metadata Architecture & Standards
- Lead strategy & architecture for Data Management initiatives
- Data Integration between multiple environments and technologies
- Become an a data expert and SME for key data sources
- Lead technology and data infrastructure roadmaps, platforms and standards discussions
Qualifications for BI architect
- Bachelor’s degree or foreign equivalent in Computer Science, Industrial Management Science or a related field
- Minimum of 5 years Enterprise Information Management (EIM) design and development experience, primarily in the Microsoft BI suite
- The candidate must have hands on knowledge of Big Data landscape, specifically hands on working with Hadoop (Cloudera), operating systems storage configurations
- Experience in managing complex multi-national and multi country process harmonization projects and SAP BW implementations
- Experience from technical roles focusing on integration and delivery is a required experience, experience from work as Integration engineer
- Engage with clients and delivery team to deliver solutions within time and budget
3
BI Architect Job Description
Job Description Example
Our innovative and growing company is searching for experienced candidates for the position of BI architect. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for BI architect
- Build a security architecture and partner with the data security team to ensure compliance of policies
- Ensure that BI Sprint solution delivery is adhering to architecture and development standards
- Contribute with hands-on data analysis, data profiling, development, and delivery
- Partner with the Big Data team to integrate the Hadoop infrastructure and data
- Partner with the IT infrastructure team to achieve high performance and scale
- Provide Technical Lead support
- Work with the team members located in a different location
- Administer implementations of OBIEE 12c and BI Publisher
- Assist lead BI architect and developer
- Design and develop highly complex technology solutions
Qualifications for BI architect
- Lead and develop junior team members
- Experience with SQL server queries, query analyzer, T-SQL, Integration Services, and Reporting Services
- Knowledge in real time reporting tools in big data technologies is a plus
- Familiarity with BI Tools such as Spotfire, Tableau, OBIEE
- Experience in at least one primary BI Tool (MicroStrategy, OBIEE, ) is required
- Experience with traditional & Cloud based data technologies (ex
4
BI Architect Job Description
Job Description Example
Our company is growing rapidly and is hiring for a BI architect. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for BI architect
- Develop data interfaces between internal systems external vendors to retrieve or transmit data for reporting purposes using ETL expertise and tools
- Build and maintain BI Business Sales Architecture in relation to definitions of data content, understanding data flow between source system and reports
- Set standards and best practices together with other architects
- Ensuring quality of the content of BI Business Solutions
- Building logical data modelling of BI Business Solutions
- Advise in the use of Business Intelligence, both inside and outside of the BI organization
- Participate/assist in production cutover and migration
- Architect, design, build, and maintain solutions to meet global business needs for the data warehouse and data mart environments
- Works with the Principle architect, BI director, and the business to define the architecture and strategy for BI/DW across the sector
- Provides technical direction to ETL developers, BI developers, data architects, and application developers to architect, design, and implement solutions
Qualifications for BI architect
- Experience with Hadoop ecosystem is preferred ( ex
- Typically requires a Bachelors degree in Information Technology or related field and five or more years progressive experience in programming and development
- Must possess one to three years of experience in designing, developing, configuring, and implementing primarily SAP BI (Business Objects) reporting solutions using SAP BW and/or non-SAP data sources
- Strong experience preferred in SAP BI (Business Objects) 4.1+ using the full suite of BI tools
- Proven success delivering end to end BI Analytic Solutions spanning all aspects of solution delivery, requirements, estimates, designs, approach, dev/build/test, monitoring, transition to production
- Ability to engage business stakeholders to establish, define and maintain solution road maps for legacy systems ensuring they align with strategic and tactical business needs
5
BI Architect Job Description
Job Description Example
Our growing company is looking to fill the role of BI 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 BI architect
- Creating and gaining agreement to BI strategies
- Designing, testing and building inbound and outbound integrations from/to ERP Cloud suite
- Participate in process flow analysis and process redesign along with product manager and/or business constituents
- Share/define best practices and be consultative throughout duration of the project
- Produce a design document to match customer requirements
- Coordinate with the development team to produce a technical specification for custom development and systems integration requirements
- Provide input related to current best practices and 3rd Party solution alternatives as part of the functional design document
- Maintain applicable certifications and/or expertise, as appropriate
- Support the development of data architecture principles, standards and processes for the organization and applies these to deliverables
- Partners with developers, DBAs and data architects to ensure data models can be deployed and maintained efficiently and accessed by consumers of the data effectively
Qualifications for BI architect
- Proven track record in regularly assessing opportunities to enhance and streamline system portfolios
- Self-starter, ability to embrace and learn new technologies, perform proof of concepts and assessments, agile pilots, leading to full blown delivery and adoption of a production solution
- Independent thinker can make technical decisions without extensive input from others
- Ability to self-direct work efforts, meet deadlines, and produce consistent high-quality work
- 10+ years of experience in the Data Architecture and Analytics
- 5-6 years in Data model design and SQL