BI Solution Architect Job Description
BI Solution Architect Duties & Responsibilities
To write an effective BI solution architect job description, begin by listing detailed duties, responsibilities and expectations. We have included BI solution architect job description templates that you can modify and use.
Sample responsibilities for this position include:
BI Solution Architect Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for BI Solution Architect
List any licenses or certifications required by the position: ITIL, IMS, ERP, SAP, F&O, D365, BI
Education for BI Solution Architect
Typically a job would require a certain level of education.
Employers hiring for the BI solution 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, Engineering, Technical, Business, Education, Information Technology, Information Systems, Management, Leadership, Business/Administration
Skills for BI Solution Architect
Desired skills for BI solution architect include:
Desired experience for BI solution architect includes:
BI Solution Architect Examples
BI Solution Architect Job Description
- Elaborate an initial conceptual vision of application landscape for analytics and engineer it into a concrete software architecture
- Structure and improve the technical user experience of research analysts and data scientists within the group, from data governance to analytics tools best delivering business insight
- Envision the solution architecture based on business and IT requirements, and document steps to reach the vision
- Define and review data governance for the predictive analytics department
- Manage the data science and analytics framework for the company, participate in data science internal workshops
- Streamline predictive analytics initiatives from the LDC business units to the data science framework, and advise on enterprise architecture accordingly
- Define and collect metrics to give a sense on the organization progress of its analytics architecture vision
- Technology watch – research new/emerging technologies that could benefit predictive analytics solutions
- Experience working on large BI projects/programs
- Experience conducting project/program/application assessments and recommend remediation efforts/roadmaps
- Research on existing reports usability and discuss with Business on findings and make recommendations
- Experience working with ETL tools like Informatica, VLDB of Teradata is a must
- 10 years experience in modeling and business system designs
- 8 years hands on experience in Informatica ETL development
- 5 years of Oracle (or comparable database) experience with BI/DW deployments
- Must have proven experience with STAR and SNOWFLAKE schema techniques
BI Solution Architect Job Description
- Experience in prototyping applications and gathering/facilitating requirements sessions
- Experience in managing/guiding technology projects and experience with industry standard business intelligence/DW reference architectures
- Experience and knowledge in ETL/BI tools and large database technologies
- Works in a team of other BI Solution Architects and BI Developers under the guidance of a reporting Project Manager/Program Manager
- Making recommendations on strategic direction and roadmap for the use and implementation of SAP BI applications, integrated third party systems
- Provide technology and architectural leadership, strategic direction and long-term vision for the SAP BI investment
- Document achievements and learnings (White papers, Good News Stories ), in order to develop and share knowledge
- Perform CSR role, leading a cross functional, cross organizational team of Solution Architects, SMEs and product managers to create a compelling solution
- Guide the core team on list of potential activities & solution options to refine the approach
- Embrace and drive knowledge sharing, asset creation and reuse to ensure that we work efficiently and effectively across the team of Solution Architects in this space
- Candidate must be a strong team player/leader
- Data analysis and/or BI development experience using large data repositories and industry leading BI Tools
- Experience working with Hadoop, including Hive and Spark technologies is desired
- Proven data analysis and interpretation skills using Microsoft Excel and SQL queries
- Expertise in visualization tools (Tableau, Jaspersoft and Big Data Analytical Tools like Datameer, Platfora, etc)
- A passion for learning and curiosity
BI Solution Architect Job Description
- Support the SSL management through regular reporting and governance
- Solicits, develops, documents and manages requirements and provides detailed design and business processes to support the requirements throughout the project life cycle up to and through change control
- Reviews system test plans and system tests applications to ensure successful test cycles
- Provides expert input on processes, procedures, or new approaches
- Leads large scale or complex business systems and application upgrades/ enhancement development and installations
- Evaluates user requirements for specialized reporting solution need and translates those needs into defined user assessment plans or specifications used in determining end-user business or technical needs
- Technical expert in more than one reporting technology
- Serves as a functional/technical resource and mentors the business organization
- Defines cost and time estimates for implementation/ development projects
- Develops project plans, user acceptance test plans and communication plans for knowledge transfer to end-user
- Bachelor’s Degree in Computer Science, Mathematics, Statistics, Industrial Engineering or other related degree
- 5+ years of progressively responsible experience in a directly related area
- 3+ years of experience with Data Warehouse and BI systems
- 3+ years of extensive experience in collecting business requirements from customers, and transform the requirements into DB data processes and data schema
- 3+ years experience in Microsoft SQL Server and relational SQL databases that include data modeling, development, and management
- 3+ years of experience translating business needs to BI Requirements, functional documentation, process flows, business rule definitions, assumptions, risks and others related to Data Architecture and Business Intelligence solutions
BI Solution Architect Job Description
- Creates business process and data flow charts for customer and technical review
- Serves as the subject matter expert and consulting resource for data management and reporting
- Works on applications and business problems that are highly complex and diverse in scope and may include and project size, multiple applications, multiple I/T segments, contractors, global rollout, new technologies, new architectures
- Manage the delivery of transitional and target state IT architectures and capability designs for a diverse range of transformation and tactical initiatives across Enterprise Business Units in Group and participating Local Markets in relation to this domain
- RFIs/RFPs and sourcing strategies and include a level of architecture consultancy and governance for the wider Group IT Architecture team
- Develop policies, standards and guidelines that direct the selection, development, implementation and use of Information Technology within the enterprise
- Define and align IT Enterprise and Capability Architectures for Enterprise Business Units in Group and Local Markets with strategies
- Develop a good understanding of the long term care business in order to design solutions to monitor KPIs
- Develop a good understanding of the data elements and provide guidance on data governance
- Analysis to identify appropriate data sources and data analysis
- 3+ years of experience designing and developing data extractions, models and UIs with QlikView
- 3+ years of experience working with Agile
- Must have extremely strong analytical and problem-solving skills
- Must possess outstanding verbal, written and visual presentation skills
- Must be a structured thinker and effective communicator, comfortable with interacting with customers
- Must have the ability to work independently, establishing strategic objectives, project plans and milestone goals
BI Solution Architect Job Description
- Work with key organizational stakeholders to define a strategic plan for leveraging integrated IT and business architecture as part of the Master Data & Solution Architecture
- Provide strategic consultation to assigned line-of-business (LOB) customers in defining or designing IT capabilities, processes, functions and organizational structures, in researching, identifying and internally marketing, selling and enabling technologies based on business and end-user requirements
- Participate in Master Data & Solution Architecture development, including business architecture, information architecture, application portfolio and technical architecture
- Assess near-term needs, using structured interview processes, to establish business priorities
- Leads, designs, implements and supports the enterprise BI dashboards and reports
- Develops reports, dashboards & KPI scorecards and aggregate data from various sources
- Balance functionality, look/feel and performance to ensure an excellent user experience which is a strong focus of the role
- Work with other teams to gather and document reporting requirements and to use the underlying data sources/data warehouses to meet business requirements
- Liaise with the SAP Data Warehouse team to design the data model
- Conduct training programs and knowledge transfer sessions for junior developers as needed
- 3+ years of experience with SAP ECC, SAP CRM, and SAP BW functional use and data structure is a plus
- 3+ years of strong understanding of ETL capabilities and data integration technologies
- 10-15 years of IT experience in multiple disciplines such as EA, project management, infrastructure management, sourcing, consulting At least 5 years of that experience in IT management leading work teams and managing budgets
- BA/ BS or 15 years of experience in diverse professional roles
- Has a comprehensive understanding BI patterns and related system architectures and Able to work independently requiring guidance in only the most complex situations
- Has experience in IT development with specific emphasis on SAP Business Objects, SAP BW 4/HANA, Hadoop, Vora, Oracle Hyperion Products as a strong plus