Top Business Intelligence Architect Skills

Below we've compiled a list of the most important skills for a Business Intelligence Architect. We ranked the top skills based on the percentage of Business Intelligence Architect resumes they appeared on. For example, 13.8% of Business Intelligence Architect resumes contained Data Warehouse as a skill. Let's find out what skills a Business Intelligence Architect actually needs in order to be successful in the workplace.

The six most common skills found on Business Intelligence Architect resumes in 2020. Read below to see the full list.

1. Data Warehouse

high Demand
Here's how Data Warehouse is used in Business Intelligence Architect jobs:
  • Included creating process documentation, agile project management techniques, continuous improvement, data warehouse performance improvement and post project mentoring.
  • Participated in the design and development of an intricate, comprehensive data warehouse solution to standardize reporting across hospital systems.
  • Managed multiple efforts for medium to large clients building enterprise data warehouse and business intelligence solutions.
  • Developed and maintained enterprise data warehouses for a variety of lines of business and department analysts.
  • Reviewed logical data models and acted as liaison between data warehouse and application development groups.
  • Identified data quality was a gap preventing successful implementation of target data warehouse architecture.
  • Facilitated regular technical training for the data warehouse / business intelligence staff.
  • Helped integrate data warehouses into Business Objects Universes for specialized finance analysts.
  • Developed COGNOS Framework Manager Models and supporting Database/Data Warehouse Data Models.
  • Developed code review guidelines for ETL applications and Data Warehouse applications.
  • Developed SSIS processes to integrate SalesForce data with enterprise data warehouse.
  • Performed data modeling for an extensive data warehouse.
  • Redesigned and replaced legacy data warehouse ETL/Cube environment.
  • Performed Data Warehouse tuning and optimization.
  • Customized OBIA ETL mappings and table extensions to design the Star Schema and populate the Data warehouse based on business requirements.
  • Experienced in modeling, designing, and developing OLTP databases, Data Warehouses (Dimensional Modeling), and Data Marts.
  • Managed multiple BI project enhancements by collaborating with ETL team to integrate new data feeds and fields into Oracle data warehouse.
  • Designed data warehouse architecture using dimensional modeling (Star Schema, ETL processes, EDW, and Data Marts).
  • Provided guidance to the government client in their effort to consolidate multiple data stores into an integrated enterprise data warehouse.
  • Designed and developed complex ETL Processes using Microsoft Integration Services (SSIS) and Stored Procedures to service data warehouses.

Show More

2. Business Requirements

high Demand
Here's how Business Requirements is used in Business Intelligence Architect jobs:
  • Conducted interviews with various business users in identifying and capturing business requirements; defined and developed project scope/plan.
  • Gathered and translated business requirements into technical specifications using structure techniques and data warehousing methodology.
  • Designed the logical data model incorporating a slowly changing dimension to meet all business requirements.
  • Collected and documented business requirements for delivering BI content to various areas within Funds Management.
  • Performed feasibility studies to translate business requirements into an appropriate technical architecture/design.
  • Developed reporting models, frameworks and strategies based on business requirements.
  • Collaborated with end-users to analyze business requirements and processes.
  • Analyzed business requirements to develop complex business metrics.
  • Coordinated with multiple architects that support business requirements.
  • Conducted business requirements gathering and process analysis sessions.
  • Designed and implemented the security in XI 3.0 as per business requirements for 3100 users.
  • Worked with Business Analyst team to ensure business requirements were sufficient to define system needs.
  • Developed and lead teams to develop SSRS reports based upon company standards and business requirements.
  • Formulated system requirements from the business requirements and implemented Hyperion Strategic Finance (HSF).
  • Developed business requirements for the data mart.
  • Developed and maintained functional IT roadmap in correlation with business requirements.
  • Co-ordinated the development efforts with offshore team, and delivered the reports as per business requirements.

Show More

3. Analytics

high Demand
Here's how Analytics is used in Business Intelligence Architect jobs:
  • Performed as technical owner for introducing Tableau desktop and server as a preferred data visualization tool for analytics.
  • Directed implementation of Data Warehousing, Business Intelligence and Predictive Analytics for all internal business systems.
  • Placed Data Engineers in business departments to increase analytics maturity throughout the company
  • Identified the data, designed the data models required for Advanced analytics which is used for data discovery using Tableau tool.
  • Worked closely with executives at client firms to understand requirements and suggest solutions and technology for BI reporting and analytics.
  • Developed and enhanced marketing analytics reports for the new product strategy and development group with a focus on business insights.
  • Designed & developed data analytics products & platform for micro-markets POS, vending machine & unattended retail.
  • Led the OBIA 7.9.6.3 (Human Resources Analytics) customization effort sourced from the following systems:.
  • Implemented Procurement and Spend, Order Management, and Financial analytics using Oracle Business Intelligence.
  • Performed data mining and data validation of unique visitors for Site Analytics.
  • Worked with clients in the implementation of the Business Intelligence Analytics Product.
  • Led a Software Vendor Selection process for an analytics and reporting application.
  • Rolled out more than 56 end-user reports and analytics in 18 months.
  • Designed and developed Financial Analytics and Clinical Analytics commercial software products in use by many medical organizations.
  • Designed Healthcare master data sets as dimensions to understand and analyze patient accounting analytics.
  • Worked on Inventory management / Item Master analytics and Transportation Analytics.
  • Helped architect multi-dimensional security model for Advanced Analytics.
  • Architected and managed a BI project solution for a Canadian bank that provides analytics to measure the effectiveness of loan management.
  • Worked on Wiley Online Libraries web-logs to collect clickstream data that empowered the business with a robust web-analytics solution.
  • Presented a BI roadmap taking the BI capabilities from basic reporting to prescriptive analytics.

Show More

4. ETL

high Demand
Here's how ETL is used in Business Intelligence Architect jobs:
  • Designed and implemented a unique metadata driven ETL solution for aggregated facts using partition switching and parallel processing.
  • Developed front-end, metadata and ETL specification to support business requirements for reporting across the organization.
  • Developed process/guidelines for MUD development, RPD/Catalog/ETL/DAC code deployment and performing full load in production environment.
  • Implemented technical database solution including data modeling, data base design ETL solutions.
  • Developed Best Practices documentation for ETL and Business Intelligence development.
  • Accomplished performance tuning of production ETL/SQL and database operation.
  • Coordinated day-to-day ETL progress monitoring.
  • Played as an ETL Architect in the Data Acquisition and Data Quality Group at US Air Force Expeditionary Combat Support System.
  • Mentored solution, data architects & tech leads on business processes, best design & ETL practices and various BI applications.
  • Gained greater exposure to ETL, creating dummy data, writing SQL stored procedures, and reporting in Crystal Reports.
  • Analyzed and identified the Tables/Views, Procedures and ETL objects that need to be migrated and prepared necessary documentation.
  • Created High Level and Detail Design documents for ETL design specifications, data migration and data scrubbing processes.
  • Provided an analysis of the current ETL load strategy and changes required to move to an incremental load.
  • Worked with ETL team and DBA to work on efficient data processing and performance on data base.
  • Analyzed/modified and extended delivered SDE & SIL ETL mappings, DAC tasks to tailor to the requirements.
  • Designed, enhanced and deployed Claims, Referrals and Membership Data Marts adopting Star Schema for ETL/ELT.
  • Created complex ETL solutions loading more than100GB of raw data daily/weekly into staging SQL Server DataWarehouse.
  • Worked with ETL engineers and DBA s to create data structures that enable efficient report performance.
  • Utilized indexing methods and optimized the ETL process using the new features of SQL 2012.
  • Implemented a migration process of business intelligence data stores, reports, & ETL programs.

Show More

5. Intelligence Architect

high Demand
Here's how Intelligence Architect is used in Business Intelligence Architect jobs:
  • Worked as a Business Intelligence Architect/Developer at the Office of Under Secretary of Defense at the Pentagon (Comptroller).
  • Served as the Microsoft Business Intelligence architect.

Show More

Job type you want
Full Time
Part Time
Internship
Temporary

6. Dashboards

high Demand
Here's how Dashboards is used in Business Intelligence Architect jobs:
  • Designed and developed Data Quality reports and dashboards to ensure production data maintained the highest level of data integrity and consistency.
  • Developed multiple Views and combined them into Dashboards for interactivity by providing Quick Filter and Parameters for further data drilling capability.
  • Created executive presentations that defined the current state environment and future state/capabilities for reporting, dashboards and predictive analysis.
  • Guided team of junior analysts in developing and documenting reports and dashboards and implementing maintenance and issue resolution processes.
  • Developed and maintained monthly dashboards that served as a tool for administrators and clinicians to monitor financial and operational efficiency.
  • Deployed MicroStrategy Mobile reporting app for executives to provide interactive dashboards on key performance indicators for various channels.

Show More

7. Ssis

high Demand
Here's how Ssis is used in Business Intelligence Architect jobs:
  • Bridged the gap between corporate finance and information technology divisions to develop agreed upon solutions and assisted in delivering the project.
  • Led requirement definition and refinement; then researched, recommended and assisted with the implementation of solutions.
  • Led a business strategy effort to assist the adoption of Business Intelligence technology within a large organization.
  • Assisted in developing a Classic Application via loading/extracting the metadata and configuring application settings.
  • Designed and implemented SSIS templates to standardize logging, notification and database connections.
  • Provided technical assistance to offshore.
  • Assisted with Property and Casualty data integration initiative from a recently acquired company, Allied Insurance, purchased by Nationwide.
  • Assisted in importing and validating historical data from Oracle GL into the target FDM application and reconciliation of the data.
  • Saved over $100k/year by creating SSIS packages to automatically import and export data to new expense-reporting and reimbursement system.
  • Designed and implemented standard template of SSIS packages to load data from operation databases into ODS, data marts.
  • Created several extracting stored procedures in SSIS ranging from other MS-SQL databases, Excel documents and text files.
  • Developed Patient Blood Management SQL Server Analysis Services Cube and SSIS Package (SQL Server 2014).
  • Created method to extract data directly from BO into SSIS using web services and C#.
  • Assisted in the design and development of SQL Server Analysis Services 2016 Clinical and PB/HB Cubes.
  • Used object manager to assist with promotion process, from our development environments to production.
  • Assisted IV&V team in fulfilling CMS guidelines of DSS/DW checklist for MMIS certification.
  • Merged the two sets of data into seamless reporting using SSIS on SQL Server 2008.
  • Assisted in developing the current and future consolidation process and defining pain points for resolution.
  • Worked with DBA's on creating new aggregates to assist users with reporting requests.
  • Assisted clients in creating groups, folders, and categories to simplify maintenance processes.

Show More

8. Architecture

high Demand
Here's how Architecture is used in Business Intelligence Architect jobs:
  • Managed well file business process definition, requirements gathering, architecture solution, foundation system integration for Information Delivery System.
  • Created system architectures, managed client relationships and ran several simultaneous projects.
  • Designed and Implemented tableau infrastructure architecture using Azure SAML SSO authentication.
  • Developed and started implementation of architecture to modernize BI delivery.
  • Developed Architecture for all new Business Intelligence delivery.
  • Delivered architecture to support various company projects.
  • Delivered reusable reporting architecture and security implementation.
  • Included architecture and systems analysis documentation.
  • Developed the overall system architecture.
  • Documented System Architecture, Production Support guides, Source to Target mappings for end to end data integration process.
  • Standardized the framework for the web and established the guidelines for data access in compliance with standard architecture.
  • Established guiding principles, standards and best practices for business driven data architecture and related technologies.
  • Developed a Master Data Architecture (MDA) to track Clinical Study management and reporting.
  • Created technical documentation for system builds, installations, and upgrades * Defined and documented requirements and high-level architecture.
  • Provided standards across business/technology teams to ensure alignment between business solution definition & systems architecture for the organization.
  • Designed and implemented scalable architecture for content management; provided custom training, support, and recommendations.
  • Identified, analyzed, and communicated architecture and integrations options and made recommendations to management.
  • Served as key business solutions architecture performing BI solution requirements solicitation and documentation.
  • Designed client future state data flow, system architecture and redesigned their Planning / Essbase (ASO/BSO) cubes for optimization.
  • Architected and designed high available SAP HANA MDC scale out architecture to support multiple business units of Mohawk Industries.

Show More

9. Ssrs

high Demand
Here's how Ssrs is used in Business Intelligence Architect jobs:
  • Deployed SSRS, Scorecard, and tabular reports to the SPS sites and libraries.
  • Developed an Alerts Platform to push reports based on SSRS data driven subscriptions.
  • Utilized Power BI, Tableau, SSRS and Excel for data visualization.
  • Implemented and maintained SSRS security.
  • Worked as SSRS developer, working closely with Business Analysts gathering and clarifying data reporting requirements.
  • Deployed and configured SSRS reports to Reporting Server using Report Manager and Configured report subscription for report delivery purpose.

Show More

10. Data Analysis

high Demand
Here's how Data Analysis is used in Business Intelligence Architect jobs:
  • Performed extensive data analysis on Tableau PostgreSQL content store to create data models for custom visualization around Tableau server usage.
  • Orchestrated operational objectives including identifying business intelligence, reporting and data analysis needs.
  • Involved in detail data analysis of data validation, Cleansing, Data consistency and data quality checks.
  • Documented to Data analysis and generating the assessment reports for Chevron's stake holder to review.
  • Performed detailed unit / system testing / peer review with in-depth data analysis on various projects.
  • Used Dashboard Manager and Crystal Xcelsius to visualize and bridge the gap between data analysis to enhance the data presentation.
  • Performed data analysis using SQL in Sql server to address the missing data issue and fixed queries for GEMS project.
  • Trained end users in understanding the canned reports and how to develop simple ad-hoc reports for their data analysis.
  • Developed PL/SQL procedures then performed system/data analysis to port SQL to Informatica mappings and workflows.

Show More

11. Ssas

high Demand
Here's how Ssas is used in Business Intelligence Architect jobs:
  • Designed and built ETL and SSAS Cubes using relational tables, public API's and flat files as sources.
  • Developed SQL Server Databases with SSIS, SSAS, and SSRS to support Enterprise and client Data needs.
  • Designed and implemented SSAS cubes and data mart for Product Management, Game Development and Accounting/Finance Team.
  • Reviewed the SSAS tabs for team and demonstrated the best practice to develop the cubes.
  • Created application specific data marts and deployed SSAS cubes on top the data marts.
  • Utilized Microsoft BI (SSAS and SSRS) to provide analysis of sales data.
  • Created multiple MS SSAS OLAP cubes to support interactive analysis and fast reporting.
  • Performed Data Modeling using SQL Server Analysis Services (SSAS).
  • Developed solution using Microsoft SQL Server, SSAS, SSIS.
  • Created self-service reporting interfaces using SSAS and Business Objects.
  • Implemented End-to-End Business Intelligence (BI) stack solution using SSIS, SSAS, SSRS and MDX.
  • Designed and Developed OLAP Cubes using SAS EBI, SSAS 2005, MSAS 2000.
  • Trained Users on the new Mart and SSAS cube.
  • Developed 1.5+ GB SQL OLAP/Cube using SSAS.
  • Implemented shared hierarchies (SSAS 2000).
  • Designed, developed, configured, and deployed MS SQL SSRS, SSAS, reports and analytics.
  • Trained users with SSAS 2005, Performance Point, ProClarity and SharePoint Portal.
  • Performed tradeoff analysis and demos of SSAS OLAP and Oracle OLAP Cubes.
  • Created the OLAP cube, kpi's and calculated members using SSAS.
  • Designed and developed SSAS cube for use in Cross-sell/Up-sell analytics.

Show More

12. SQL

high Demand
Here's how SQL is used in Business Intelligence Architect jobs:
  • Developed and personally coded internal IntraNet website based upon SQL-server and ASP web technology.
  • Automated numerous regulatory requirements through data extracts and custom SQL reports.
  • Developed interactive reporting and analysis delivery platform with SQL Reporting Services (SSRS) and Crystal Reports to support accounting teams.
  • Designed an internal ASP.NET web form app in C# & MS SQL Server for creation of lab reports and invoices.
  • Developed best practice SQL backup strategies including full transaction log and simple backups to ensure business appropriate time of failure resurrection.
  • Coded a Technology Solutions-specific Sales Order Processing (SOP) system based on Visual Basic 6.0 and SQL Server 2000.
  • Migrated Pre-Existing Access and SQL 2000 Databases and Data Transformation Services (DTS) Packages to SQL 2005.
  • Mentored teams on advanced SQL topics including SQL development and tuning as well as the Microsoft BI Stack.
  • Mentored team members for a financial project on how to build cubes in SQL Server Analysis Services.
  • Designed and implemented solution using Microsoft Reporting Services, C#, ASP.NET, and SQL Server.
  • Added SQL job notification to all BI jobs to notify team of issues and cause of failures.
  • Developed the overall SQL Server and Business Objects Integration architecture for the client and process areas.
  • Microsoft-certified in SQL Server Business Intelligence (MCITP) and Database Development (MCTS).
  • Migrated data, transaction processing, and reporting from legacy Ingres database into SQL 2012.
  • Worked on SQL Database replication for creating another database in order to reduce data traffic.
  • Created Manhole Inspection System for the Public Service Commission using Visual Basic & SQL Server.
  • Administered SQL Server databases that included backups, optimizing, security, and troubleshooting.
  • Designed reporting tables in SQL Server to handle complex requirement for GEMS project.
  • Devised table and SQL scripts to load test data into Oracle tables.
  • Identified performance issues and optimized SQL Server 2012 environment and database solutions.

Show More

13. Cognos

high Demand
Here's how Cognos is used in Business Intelligence Architect jobs:
  • Decomposed business logic for data mapping to be implemented using COGNOS Framework.
  • Worked closely with executives and senior management to develop reporting solutions for all business units using Cognos Query and Report Studios.
  • Created presentation quality reports into zero-client application with Cognos and Business Object Reports.
  • Re-Architected Legacy Cognos Environment reducing operational support issues by 75%.
  • Designed and Implemented security solutions for Cognos using Active Directory.
  • Managed and maintained Cognos infrastructure for the Rational division.
  • Created test plans to verify the accuracy of the information delivered by the Cognos reporting environment.
  • Phased out the legacy Cognos solution by providing custom executive Daily Sales reporting through BI Publisher.
  • Worked on the Cognos 10.1 and 10.2 upgrade projects in capacity of modeler and report developer.
  • Performed administration for Cognos environment, including maintenance, upgrades, and performance tuning.
  • Conducted training on use of Cognos suite as well as data structures and usage.
  • Designed the Cognos Portal and implemented a Wiki for the Business Intelligence Users.
  • Created technical documentation for the IS department on using the Cognos products.
  • Performed Cognos 8.2 to 8.3 report migration during final phase of deployment.
  • Upgraded Framework Manager Models, Transformer Cubes and reports from Cognos 11.
  • Created training manuals for the Cognos products for the end users.
  • Integrated Active Directory roles and groups with the Cognos reporting environment.
  • Administered Cognos 8 environment for 300 consumers across multiple business lines.
  • Designed and developed multiple SDK applications from Cognos and Tableau.
  • Created end user documentation on using the Cognos products.

Show More

14. Olap

high Demand
Here's how Olap is used in Business Intelligence Architect jobs:
  • Designed a STAR schema data model for handling the OLAP reporting and Ad-Hoc querying needs.
  • Designed and taught a one-week training course in OLAP programming for a client company.
  • Redesigned large Oracle OLAP marketing analysis system with more than a terabyte of data.
  • Provided subject matter expertise to other branches of the firm with OLAP cubes implementations.
  • Trained report developers to leverage OLAP data source for the development of SSRS reports.
  • Automated the process for building and monitoring OLAP cubes creation.
  • Created and maintained OLAP universes sourced from BW.
  • Developed OLAP Standard and AD HOC reports.
  • Developed multiple Cognos frameworks to simplify end users access to information via OLAP or ROLAP data structures.
  • Designed and modeled star schemas to support reporting and OLAP needs.
  • Administered OLAP database schema Analytic Workspace User and Temp resources.
  • Created database schemas with grants to OLAP_USER and OLAP_ADMIN.

Show More

15. Microstrategy

average Demand
Here's how Microstrategy is used in Business Intelligence Architect jobs:
  • Utilized MicroStrategy data blending features to join data at dashboard level to achieve desired performance requirements.
  • Created project metadata using MicroStrategy Architect and deliver MicroStrategy prototype reports.
  • Developed numerous MicroStrategy attributes, facts, MicroStrategy Intelligent Cubes.
  • Implemented and delivered MicroStrategy mobile dashboards via MicroStrategy mobile application.
  • Coordinated and performed all MicroStrategy software upgrades.
  • Provided expertise in the development of MicroStrategy Dashboards: Resurrected a Sales and Marketing dashboard, made changes for a demo.
  • Implemented MicroStrategy 9.4.1 for web and desktop reporting, designed data cubes, dashboards, self-serve, and interactive reports.
  • Developed proof of concept dashboards using MicroStrategy to provide the Business options for their Dashboard design.
  • Designed the MicroStrategy BI High level & low level documents for developing the data model.
  • Contacted MicroStrategy Support, on 10 occasions, following through from problem to resolution.
  • Designed and Developed Templates, Filters, and OLAP Reports using MicroStrategy Desktop.
  • Played key role in upgrading current MicroStrategy 6.5 application to new 7I version.
  • Developed a MicroStrategy training program to roll out for the wholesale businesses.
  • Guided and Mentored team members in the migration process of MicroStrategy objects.
  • Architected MicroStrategy report and dashboard design specifications for implementation of development best practices with respect to report performance and re-usability.
  • Configured all MicroStrategy components like MicroStrategy Desktop, Intelligence Server, Web and MicroStrategy Narrowcast Server on NT Servers.
  • Administered MicroStrategy Security for all users, and monitored licenses to comply with MicroStrategy licensing agreement.
  • Developed institutional reports using Tableau and MicroStrategy *Functioned as sole MicroStrategy administrator for 18 months.
  • Constructed MicroStrategy project and dashboard/reports to aid cyber analysts.
  • Implemented Microstrategy security for different business users.

Show More

16. Pl/Sql

average Demand
Here's how Pl/Sql is used in Business Intelligence Architect jobs:
  • Developed PL/SQL stored procedures & packages, Established data retrieval standards through code libraries and conducted code reviews.
  • Created, database links, synonyms and materialized views, and maintained, and tuned PL/SQL queries.
  • Pushed out custom PL/SQL function from Oracle to BOXI Universe.
  • Modified PL/SQL code to ensure data source is correct.
  • Created Logical and Physical Data Process using ERWIN Process Modeler and MS Visio to implement with PL/SQL.
  • Redesigned oracle database tables and created pl/sql packages to improve application performance.
  • Streamlined and implemented Water/Wastewater asset-data-management processes (PL/SQL procedures) that greatly enhanced the management reporting capabilities on Wastewater utility data.

Show More

17. Java

average Demand
Here's how Java is used in Business Intelligence Architect jobs:
  • Created Java programs in conjunction with Tableau Command Line Utility to automatically generate PDF output from dashboards on Tableau Server.
  • Created a silent/auto print solution for web portal users using Active Tree Java PDF libraries and NetBeans IDE.
  • Created an automated email daemon to notify clients of available lab results using Actuate and JavaMail API.
  • Developed user interfaces using HTML, Javascript, CSS, Server-side includes and Perl template modules.
  • Managed various Java SDK jobs scheduled in ASG Zena application for daily / weekly execution.
  • Adapted existing Java based data load application for Netezza database thus making first generation of Netezza data warehouse operational.
  • Developed using IBM Cognos 8/10 BI framework, Transformer Cube, JavaScript and Red Brick database as the backend tool.
  • Customized Siebel Analytics look and feel by modifying or creating style sheets, xml messages and javascript components.

Show More

18. Metadata

average Demand
Here's how Metadata is used in Business Intelligence Architect jobs:
  • Prepared several architectural artifacts that include metadata, partitioning & indexing strategies, data naming standards.
  • Conducted gap analysis based on out-of-box metadata/reports and client reporting requirements.
  • Managed data lineage and metadata.
  • Evaluated new tools and technologies; managed the metadata and designed & developed several Business Objects Universes and Reports.
  • Designed and built custom Narrative Views, metadata, and database objects to enable prompt display in excel.
  • Provided a mapping of the fields: A document which lists the Metadata mapping from source to target.
  • Created Business Objects SDK scripts for manipulating scheduled report recipients, destinations, and other metadata.
  • Designed/developed metadata, reports, and dashboards to be accessible by various levels of users.
  • Provided data governance support in keeping the metadata repository and the customer-wide system in sync.
  • Designed and implemented the data layer for the Metadata Management Tool (MMT).
  • Designed & developed custom metadata, reports, & dashboards.
  • Developed procedures and best practices for OBIEE metadata multi-user development and change control.
  • Worked extensively on Cognos Metadata definition for prompts, metrics and dimensions.
  • Performed technical assessment of Metadata and query performance for several Vendors prior to final selection of Cognos BI for extended POC.
  • Identified and corrected anomalies in the Micros- trategy project metadata and SQL generation.

Show More

19. Hadoop

average Demand
Here's how Hadoop is used in Business Intelligence Architect jobs:
  • Established connectivity to Apache Hadoop from Cognos as well as Tableau.
  • Trained & implemented rapid prototyping using AGILE/Scrum Master/JIRA methodologies with BIG DATA/HADOOP/HIVE background.
  • Developed efficient MapReduce programs for filtering out the unstructured data on a Hadoop framework implemented in Pseudo Distributed Mode.
  • Participated in Hadoop cluster development.
  • Conducted research and provided recommendations on providing exploratory analysis utilizing hadoop and other big data technologies.
  • Used Hadoop HDFS, Python to implement data retention process, monitoring, communication with upstream and downstream application.

Show More

20. EDW

average Demand
Here's how EDW is used in Business Intelligence Architect jobs:
  • Provided technical leadership and guidance for Data Warehousing and reporting solutions; enhanced the existing Data Warehousing environment into EDW.
  • Coordinated conformed Dimensions between EDW projects.
  • Created ETL frame work to extract data from corporate EDW SDI data-mart to provide updated info to external corporate customers.
  • Created and modified normalized (3NF) data models to incorporate enhancements and to resolve defects in the EDW.
  • Researched all IBM mainframe data source feeds and completed all data mapping to Marketing Analysis EDW worksheet specifications.
  • Developed a standard Reference data repository and shared entities used by the EDW and subsequently several other projects.

Show More

21. Teradata

average Demand
Here's how Teradata is used in Business Intelligence Architect jobs:
  • Worked on different data sources such as Oracle, Teradata and Flat files.
  • Prepared the semantic layer in Teradata database to be used by BOBJ environment.
  • Reviewed performance of OBIEE dashboards, spotfire IL queries; created teradata join indexes, secondary indexes, partition primary indexes.
  • Worked on data sources such as Oracle and Teradata Involved in debugging of Mapping and other components like unix scripts.
  • Managed a data warehousing project to make SeaWorld presence possible in Teradata data warehousing environment.
  • Extracted data from Oracle database transformed and loaded into Teradata database according to the specifications.

Show More

22. ERP

average Demand
Here's how ERP is used in Business Intelligence Architect jobs:
  • Defined Business Intelligence strategy for enterprise implementation with various technical subsystem components focused on self-service principles with familiar business tools.
  • Conducted comprehensive vendor assessment and developed vendor scorecards to evaluate business intelligence software for enterprise adoption.
  • Worked closely with application developers to synthesize their requirements into a reusable enterprise data model.
  • Developed strategy to incorporate Enterprise Architecture and Information Architecture for inclusion of IT modernization initiatives.
  • Created Enterprise Data Model for organization and implemented Master Data Management standards.
  • Configured Intelligence Server, Enterprise Manager and server definitions using Linux scripts.
  • Developed business case scenarios for enterprise social networking key performance indicators.
  • Identified and resolved control gaps in the enterprise business intelligence initiative.
  • Presented solutions to clients senior management via PowerPoint and whiteboard.
  • Developed Framework Manager Models and created enterprise reports.
  • Provided data governance and created enterprise data standards.
  • Managed architecture solution for enterprise corporate reporting environment.
  • Established enterprise architecture and governance processes.
  • Partnered with senior management to create daily report detailing and summarizing sales activity across entire enterprise, encompassing 12 sales feeds.
  • Created numerous enterprise analytic reporting solutions implemented in SSRS based on OLAP Cubes as well as OLTP data including interactive reports.
  • Installed SAP Integration Kit over the SAP Business Objects Enterprise environment and managed several reporting initiatives over the existing BW environment.
  • Implemented RapidDecision (JDE Enterprise One sourced) GL, AR, AP, FA, and Property Management Marts.
  • Managed for the functionality, performance, troubleshooting and management of the enterprise-wide SAP Business Objects Enterprise Reporting Program.
  • Played a key role in upgrading enterprise data warehousing (EDW) from SQL 2005 to SQL Server 2014.
  • Configured SQL Server 2008 Reporting Services and deployed various SSRS projects to meet the enterprise data reporting needs.

Show More

23. SAS

average Demand
Here's how SAS is used in Business Intelligence Architect jobs:
  • Planned and scheduled regular backup and recovery operations with mirrored and off line storage hosted off site at disaster recover location.
  • Designed, installed, configured, developed, tested and deployed SAS-BI reports and SAS BI applications.
  • Implemented the OLAP and Ad-Hoc reporting interface in SAS 9i.
  • Created dashboard/reports using SAS suite of tools.
  • Developed and implemented a Business Intelligence methodology and standards to run Business Objects/SAS/Essbase projects within Sears.
  • Managed the BI team for Business Objects/Essbase/SAS development and support a 20 people team.

Show More

24. T-Sql

average Demand
Here's how T-Sql is used in Business Intelligence Architect jobs:
  • Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
  • Prepared Documents of each process involved, Developed complex stored procedure using T-SQL to generate reports using SSRS 2005.
  • Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
  • Designed and developed a database to house data from various data sources for all reporting needs with T-SQL proficiency.
  • Converted Active script task logic in Script task and T-SQL and produced the desired result.
  • Designed and developed a Build Verification Test (BVT) tool to validate the build; using C# AND T-SQL.

Show More

25. Windows

average Demand
Here's how Windows is used in Business Intelligence Architect jobs:
  • Installed, configured, serviced, and maintained BI suite and servers on Linux and Windows Server 2003.
  • Created folders, groups and users' security levels via Windows AD authentication in Central Management Console.
  • Installed and configured 2 OBIEE [ ] environments on Windows Server 2003 virtual machines.
  • Installed and configured the Cognos BI environment in a distributed multi server Windows environment.
  • Installed and configured PowerCenter 9.0.1 in a Windows-based environment.
  • Installed Business Objects Enterprise XI 3.1 Sp4 on Windows 2008 Servers and published reports on to Business Objects Enterprise Server.

Show More

26. CRM

average Demand
Here's how CRM is used in Business Intelligence Architect jobs:
  • Designed and lead development of numerous data manipulation processes for various clients CRM applications.
  • Developed and provided user-appropriate documentation for various supported business systems including CRM, PSA, LOB, and other systems
  • Managed customer support for Onyx CRM, Great Plains, QuickArrow PSA, and N-Able Remote Monitoring Systems.
  • Redesigned flows and usage of CRM.
  • Developed customer-centric analysis, for a large commercial organization, by relating market and CRM data into a cohesive package.
  • Implemented a CRM for a prospect management system with drill-down capability enabling access to data on new business development opportunities.

Show More

27. Sharepoint

average Demand
Here's how Sharepoint is used in Business Intelligence Architect jobs:
  • Created Scheduled Data Driven Subscriptions on Report Server in order to deliver reports to different SharePoint locations.
  • Designed and developed SharePoint KM architecture environment solution.
  • Designed and built administrative dashboard reports using SSRS, SharePoint Server, and Power View.
  • Led project to implement SharePoint Farm for highly available reports and development.
  • Published briefing books and BI web parts to SharePoint portal.
  • Utilized Analytics tools and SharePoint collaboration as aids.
  • Streamlined frequent audit requirements by providing FAQ sharepoint site where auditors can collect answers before engaging our team.
  • Involved in the planning, development and deployment of SharePoint sites while adhering to iNAVSEA software compliance standards.
  • Created multiple Key Performance Indicators (KPIs) for use with SharePoint 2010 dashboards.
  • Worked on Open Doc and Integration of BO Reports with Sharepoint and web pages.
  • Designed multiple dashboards using SharePoint, Performance Point, and Dundas visualizations.
  • Converted many existing .Net applications into SharePoint Team Pages.
  • Created implementation roadmap for a corporate reporting solution in Sharepoint that allows users to share data.

Show More

28. Linux

average Demand
Here's how Linux is used in Business Intelligence Architect jobs:
  • Created and setup database audit procedure on Linux, AIX Z/OS Platform for SOX'S Compliance.
  • Maintained Daily, Weekly and Monthly Production Processes on Linux Environment which were scheduled via Autosys Application.
  • Architected, installed, and configured three Weblogic/OBIEE 11g environments on 64-bit Linux, two of which were clustered.
  • Developed many reusable shell scripts in Red Hat Linux.
  • Administered Linux and Apache servers.
  • Installed and administered the Oracle RAC (on ASM), on Linux.

Show More

29. MDX

average Demand
Here's how MDX is used in Business Intelligence Architect jobs:
  • Created SSRS reports using MDX queries for reporting financial matrices.
  • Converted existing SQL reports to MDX drastically reducing execution times.
  • Designed and optimized MDX queries to improve performance.
  • Created MDX queries and implemented performance optimization.
  • Developed 550+ MDX calculated members for complex financial accounting calculations.
  • Provided user-friendly dimension hierarchies and measures displaying cost and revenue calculations using MDX syntax.

Show More

30. Salesforce

low Demand
Here's how Salesforce is used in Business Intelligence Architect jobs:
  • Ensured the delivery of vital actionable information from multiple source systems including SalesForce.com.
  • Performed configuration and change control functions within the SalesForce environment for disparate instances.
  • Customized the Salesforce implementation to support Business Requirements, Procedures and Process flows.
  • Administered Salesforce Campaigns for New Customers and Customer Retention Programs.
  • Worked extensively with Microsoft Office products and Salesforce.com.
  • Migrated custom legacy applications into custom Salesforce modules to ensure maintainability and integration in the overall application landscape.

Show More

31. Qlikview

low Demand
Here's how Qlikview is used in Business Intelligence Architect jobs:
  • Developed executive dashboards in QlikView, enabling to measure the performance of the business with analytical capabilities.
  • Advised on costs and benefits for the acquisition of new technologies that included the Red-gate products, Pentaho, and QlikView.
  • Worked on Qlikview Server and Publisher, to manage user access, schedule refreshing of documents, mount completed.
  • Designed and developed QlikView Applications that use Clarity and Cogito Data Warehouse (Star) as data sources.
  • Implemented Qlikview as BI Presentation layer.
  • Participated in build of several in-memory analytical apps using Qlikview 9/10/11.
  • Designed and developed multiple Qlikview dashboards for Phreesia Analytic product.

Show More

32. Web Intelligence

low Demand
Here's how Web Intelligence is used in Business Intelligence Architect jobs:
  • Provided mentoring to Clarity report developers as it relates to Web Intelligence (SAP Business Objects 4.1 SP2) report development.
  • Architected the Business Objects environment including developing Universes and Web Intelligence Reports.
  • Developed 3 brand new Web Intelligence reporting applications and maintenance technical support of 4 existing reporting applications.
  • Changed existing Universes using Universe Designer, and redesigned/improved Reports requiring custom SQL in Web intelligence.
  • Trained staff of approximately 25 to create web-based information reports using Business Objects Web Intelligence application.
  • Created several Web Intelligence reports to help management track and monitor IT/Information Security metrics globally.

Show More

33. Unix

low Demand
Here's how Unix is used in Business Intelligence Architect jobs:
  • Modified the clients unix scripts to load offshore databases via load rules/text files.
  • Performed Unix programming for radio station.
  • Coordinated infrastructure changes (Unix System Groups, Policy Director Administrators) and developers in each project for the upgrade.
  • Tuned the warehouse from both the Oracle and Unix perspective, setup of Advanced Replication servers (master-master configuration).
  • Developed UNIX scripts to automate deployment of the releases related to different phases of this program.
  • Created generic templates for UNIX shell scripts used for automation.

Show More

34. Oltp

low Demand
Here's how Oltp is used in Business Intelligence Architect jobs:
  • Re-architectured Sikorsky Fleet Analytics from OLTP to OLAP.
  • Detected a pattern where Data Warehouse calculations were increasingly shifting from regular OLTP to scientific calculations.
  • Integrated data mining applications in OLTP databases for predictive analysis & user behavior analysis.
  • Composed subject area oriented OLTP Entity Relationship Diagrams.
  • Provided leadership in Data modeling for Conceptual, Logical and Physical data Models for OLTP, and OLAP.
  • Used Oracle Wait interface extensively to resolve the bottlenecks of many applications for both OLTP and OLAP environment.

Show More

35. Kpis

low Demand
Here's how Kpis is used in Business Intelligence Architect jobs:
  • Developed calculated measures, leveraged as drag and drop KPIs, used in information trending.
  • Developed KPIs and other metrics for measuring performance and meeting business objectives.
  • Interviewed over 45 key Executives multiple times to design KPIs and metrics.
  • Used Business Intelligence Reporting Tool to create KPIs and Scorecards to improve corporate profitability measures and comparative financial analysis.
  • Developed dashboards in Tabular Modes to help management identify critical KPIs and facilitate strategic planning in the organization.
  • Interacted with business representatives for Need Analysis and to define KPIs for Business and derive functional specifications.

Show More

36. S3

low Demand
Here's how S3 is used in Business Intelligence Architect jobs:
  • Saved VNSNY IT approximately 200k in SAS Mainframe licensing fees on their OS390 IBM systems.
  • Evaluated OS390/DB2 Vs HP-UX/Oracle and recommended HP-UX/oracle as the direction for operating system/database environment.

Show More

37. Universes

low Demand
Here's how Universes is used in Business Intelligence Architect jobs:
  • Designed data marts and associated data integration strategy to support the Business Objects universes and reporting applications.
  • Interacted with Business Users and End Users to know their Business views in developing and modifying Universes and Reports.
  • Identified all the reports and Universes in Business Objects system to be migrated and develop a project plan.
  • Involved in creating and validating Universes, providing technical support to the users on universe and reports.
  • Created universes, classes and objects by retrieving the data from various data sources and connections.
  • Maintained and optimized Epic provided universes for Access Log, ED Visits, and Hospital Visits.
  • Customized Epic Hospital Billing and Professional Billing Universes (SAP Business Objects 4.1 SP2).
  • Created WebI and Crystal reports with universes created from SAP BW data.
  • Created complex new Universes, Linked with existing Universes from Data marts.
  • Created Business Objects Universes in order to enable self-service reporting.
  • Created Linked Universes to save time and improve performance.
  • Created and maintained several Business Objects 3.1 universes.
  • Developed UNX and UNV universes.
  • Architected the Design and Created Universes for Sales, Plant Management and Inventory Reporting.
  • Developed PB/HB Universes and Webi Reports.
  • Worked on developing 20 universes using BW , RDBMS using secured connections, Row level security , complex calculations.

Show More

38. DBA

low Demand
Here's how DBA is used in Business Intelligence Architect jobs:
  • Designed and implemented global mobile broadband wireless devices sale, activation and tacking business intelligence solution.
  • Provided application DBA support of all Hyperion application.
  • Resolved several database issues by performing DBA role, and provided primary and secondary on-call support activities on a rotational basis.
  • Served as DBA and project lead on the deployment and completion of Canon Document Manager application for electronic document management.
  • Performed Oracle DBA duties as needed, particularly in the area of performance tuning at the Db server level.
  • Viewed and monitored system and DBA tables for troubleshooting database related issues for the clients.
  • Facilitated requirements sessions, team status meetings and feedback reviews.
  • Developed user stories, use cases and designed UX/UI for Avanti Markets retail kiosk POS mobile payment app with customer/stakeholder feedback.

Show More

39. MDM

low Demand
Here's how MDM is used in Business Intelligence Architect jobs:
  • Gathered, reviewed and validated business processes for all touch-points into customer subject area for the scope of the MDM project.
  • Engaged in a Master Data Management (MDM) vendor tool selection.
  • Designed a Color MDM accurately representing company's proprietary color-related information.
  • Participated in MDM product evaluation (Oracle and IBM) and POC focusing on development of governance and compliance issues.
  • Designed and developed custom MDM tool with user interface for creating, configuring new rules and correction of data.
  • Managed, designed and deployed the global Data Warehouse and associated MDM (Master Data Management) applications.

Show More

40. DB2

low Demand
Here's how DB2 is used in Business Intelligence Architect jobs:
  • Involved in the creation of DB link to access DB2 data via Oracle Transparent Gateway.
  • Sourced data from DB2 production database to provide accurate and timely information distributed via web portal applications utilized globally.
  • Performed database migrations, provided ongoing database support including performance enhancement maintenance and end-user education, Performed DB2 installation and configuration.
  • Designed and developed a DB2 data cleansing application to enable a customer marketing promotion.
  • Configured Access server and admin console to capture HMS's PCF & EC DB2 data store's daily updated data.
  • Tuned, solved problems, and made performance improvements for data warehouses in SQL Server and IBM DB2.

Show More

41. UAT

low Demand
Here's how UAT is used in Business Intelligence Architect jobs:
  • Developed detailed technical blueprints for the integration of business intelligence solutions; performed tools evaluation and selection for various client projects.
  • Evaluated the environment and recommended hardware configurations for development, stage and production environments for all migrations.
  • Troubleshooted and evaluated data to certify information is precise and reconcilable to its source of origin.
  • Designed a new business intelligence product by conducting market analysis studies evaluating competition and industry trends.
  • Evaluated and procured departmental development/test laboratory (hardware and software).
  • Conducted evaluation of dashboard and visualization tools such as Business Objects Explorer, Tableau Desktop, and Tableau Server.
  • Evaluated potential new hires as part of the hiring process and wrote performance appraisals on a yearly basis.
  • Evaluated all company Business Intelligence technology to determine the appropriate approach to take in growing the corporate warehouse.
  • Managed evaluations of technical solutions and vendor products to include proof of technology and proof of concepts.
  • Advanced WellPoint s Information Management department to evaluate and adopt new Business Intelligence products and services.
  • Evaluated tools to replicate SQL Server to AWS and SQL Server slaves in a distributed environment.
  • Used Business Objects, Quality center and share point for UAT tracking and resolution.
  • Worked with customer team to discuss the requirement and ensure UAT approval for Dashboard.
  • Evaluated, compared and integrated new data vendors for use in portfolio management.
  • Developed an UAT tool for business users not comfortable with SQL.
  • Worked with users in conducting user acceptance testing (UAT).
  • Evaluated Database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
  • Used Quality Center Edition of Application Lifecycle Management Tool from HP to execute SIT and UAT process.
  • Developed custom lab results Actuate reports in the Chemware Horizon laboratory information system (LIMS).
  • Evaluated multiple BI vendors to select the most appropriate toolset.

Show More

42. ODS

low Demand
Here's how ODS is used in Business Intelligence Architect jobs:
  • Implemented SQL Server 2012 Change Data Capture features for near real-time ODS Updating.
  • Mentored DBA's on deployment and configuration methods for SQL Server 2005.
  • Designed ODS, DW & Data mart flexible dimensional model.
  • Provided strategic guidance for warehouse implementation, development practices, report distribution methods, performance improvement, and disaster recovery.
  • Coordinated across global organizations as required to support data integration efforts to populate a clinical reporting ODS.
  • Improved Business Processes by implementing different Business Intelligence methods.

Show More

43. QA

low Demand
Here's how QA is used in Business Intelligence Architect jobs:
  • Engaged with Product team, Report Writers and QA Team and SME to improve business process.
  • Implemented Change Requests and Defects raised by Business Users/QA teams in Data Marts & Reporting Area.
  • Performed QA on data and reports reconciling them with spreadsheets used for input.
  • Migrated all code from Dev to QA to Prod.
  • Participated in the full development life-cycle from developing business intelligence requirements to QA and production deployment.
  • Involved in putting together a comprehensive strategy for migration and QA activities

Show More

44. Netezza

low Demand
Here's how Netezza is used in Business Intelligence Architect jobs:
  • Worked with DW developers to model a supporting DataMart using Composite data virtualization software on top of the Netezza data store.
  • Improved the throughput of the ELT processes for Netezza by a factor of 100x.
  • Imported data and structures used in existing Netezza decision support system.
  • Led migration of Oracle data warehouse to Netezza.

Show More

45. Procedures

low Demand
Here's how Procedures is used in Business Intelligence Architect jobs:
  • Implemented database refresh from Production to QA and automated data backup and restoration procedures.
  • Developed, audited, coordinated, and promoted procedures during application development life cycle.
  • Developed Stored Procedures for Data Import/Export and Data Conversions.
  • Created stored procedures for complex reporting scenarios.
  • Authored documentation of procedures of a self-service BI model resulting in increased efficiency, reduced costs, and increased speed.
  • Completed design documents, document templates for future designs as well as exception and error handling procedures.
  • Documented all processes and procedures as they relate to the Emergency Department and Radiology Data Marts.
  • Maintained and tuned procedures in three separate environments (development, Quality, and Production).
  • Developed dimensional model, tables, attributes, elements and procedures required for application.
  • Created and updated Standard Operating Procedures (SOP), including checklist.
  • Provided test plans and procedures for the validation of test data.
  • Created stored procedures, Functions, Common Table Expressions and Triggers.
  • Created Standard Operating Procedures (SOP) in preparation for transition.
  • Used Six Sigma Standards for the Documentation of the procedures.
  • Designed most of the tables and stored procedures.
  • Developed vibrant and visually-rich reporting using SQL Server Reporting Services 2008 for end users with parameterized SQL Queries and Stored Procedures.

Show More

46. Informatica

low Demand
Here's how Informatica is used in Business Intelligence Architect jobs:
  • Tuned various informatica/DB objects and hence improving the overall productivity of project.
  • Performed upgrade of Informatica PowerCenter include hardware platform migration.
  • Created Informatica mappings and sessions with PL/SQL Procedures/Functions to build business rules to load data and tuned them for optimum performance.
  • Learned both Informatica and IBM tools for Data Governance and Master Data Management.
  • Installed and configured Informatica and OBIA software on Test and Production servers.
  • Worked on Informatica Power Center tools-Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
  • Customized Informatica 8.6.6 mappings and workflows to support client-specific customizations, including an additional source system.
  • Worked with Informatica Designer, Repository manager, Workflow Manager and Workflow Monitor.
  • Used Informatica to create an incremental (change data capture) load workflow to update the Siperian customer list database.

Show More

47. R2

low Demand
Here's how R2 is used in Business Intelligence Architect jobs:
  • Developed and deployed the portal, automation tools, deployment tools, monitoring tools XI R2 SDK to XI R3 SDK.
  • Conducted proof of concept to integrate SAP Business Warehouse (SAP BW 7.1) and SAP Business Objects XI R2.
  • Managed and completed Business Objects 6.5 migration to Business Objects XI R2 and XI Release 3.
  • Extracted and consolidated data from diverse data sources into a uniform SQL Server 2008 R2 database.
  • Worked star schema to combine SFDC and Call Center data on MS SQL Server 2008 R2.
  • Managed BI enhancement from SAP Business Objects XI R2 to Business Objects XI 3.1.
  • Involved in migration of Business Objects 6.5 to Business Objects XI R2.
  • Architected and developed Emergency Department Data Mart (Oracle 11g R2).

Show More

48. BO

low Demand
Here's how BO is used in Business Intelligence Architect jobs:
  • Developed collaborative working relationships with business units, technical teams and project managers to produce tools and solutions.
  • Created improvements that boosted quantitative assessments and analysis of the social network activity for key performance indicators.
  • Collaborated with investment managers to build tools for constructing optimal portfolios and monitoring portfolio risks.
  • Designed and developed performance dashboards used by senior management to monitor business performance and status.
  • Developed architectural enhancement for forecast model including labor hours, dollars, and material quantity.
  • Analyzed business and user needs and designed Dashboards to support customer requirements.
  • Consolidated multiple silo BO platforms into single technical platform and ecosystem.
  • Collaborated directly with user community for detail requirements and issue resolution.
  • Developed reports ranging from Operational Customer Statements to Corporate Dashboards.
  • Collaborated with peer business groups to adopt data-driven decision-making practices.
  • Performed BOE administration and designed and documented security model.
  • Created multiple interactive data-driven visual storyboards in Tableau.
  • Created Operational dashboards to analyze real-time claim processing.
  • Planned, designed, and implemented database (Oracle) applications exceeding Terabyte in size in both Unix and Windows environment.
  • Involved in Weekly and Monthly deployment activities Reviewing reports and Universes, Improved report response time by tuning BO queries.
  • Collaborated with business users using white boarding sessions to validate requirements and guide them on best way to present data.
  • Designed, built and managed an Executive Scorecard and Dashboard solution to support the first-of-its-kind executive reporting for the company.
  • Managed the user, groups, repositories and the documents through the BOXI 3.1 Central Management Console (CMC).
  • Designed custom dashboards combining prescription, sales, service request, adverse event, and vendor service level agreement metrics.
  • Involved in creating Excel Workbook Connections using SQL databases in order to load the data to Excel from SQL tables.

Show More

49. SAP R/3

low Demand
Here's how SAP R/3 is used in Business Intelligence Architect jobs:
  • Established connection between Business Warehouse, SAP R/3 systems and Non-SAP systems like BECON, ICESTROM and other data sources.
  • Analyzed and activated relevant Business Contents and set SAP R/3, Flat Files and BW as source systems.
  • Worked on LO extractors for extracting sap R/3 data into BI.
  • Configured the Data services to connect to the SAP R/3, BI, and CRM.
  • Uploaded master data and transactional data from Flat Files and SAP R/3 to BW system.

Show More

20 Most Common Skill For A Business Intelligence Architect

Data Warehouse17%
Business Requirements16.4%
Analytics11.8%
ETL7.3%
Intelligence Architect5.7%
Dashboards5.5%
Ssis3.6%
Architecture3.4%

Typical Skill-Sets Required For A Business Intelligence Architect

RankSkillPercentage of ResumesPercentage
1
1
Data Warehouse
Data Warehouse
13.8%
13.8%
2
2
Business Requirements
Business Requirements
13.3%
13.3%
3
3
Analytics
Analytics
9.5%
9.5%
4
4
ETL
ETL
5.9%
5.9%
5
5
Intelligence Architect
Intelligence Architect
4.6%
4.6%
6
6
Dashboards
Dashboards
4.5%
4.5%
7
7
Ssis
Ssis
2.9%
2.9%
8
8
Architecture
Architecture
2.7%
2.7%
9
9
Ssrs
Ssrs
2.5%
2.5%
10
10
Data Analysis
Data Analysis
2.4%
2.4%
11
11
Ssas
Ssas
2.2%
2.2%
12
12
SQL
SQL
2.1%
2.1%
13
13
Cognos
Cognos
2%
2%
14
14
Olap
Olap
2%
2%
15
15
Microstrategy
Microstrategy
1.9%
1.9%
16
16
Pl/Sql
Pl/Sql
1.8%
1.8%
17
17
Java
Java
1.8%
1.8%
18
18
Metadata
Metadata
1.7%
1.7%
19
19
Hadoop
Hadoop
1.7%
1.7%
20
20
EDW
EDW
1.6%
1.6%
21
21
Teradata
Teradata
1.5%
1.5%
22
22
ERP
ERP
1.3%
1.3%
23
23
SAS
SAS
1.2%
1.2%
24
24
T-Sql
T-Sql
1.1%
1.1%
25
25
Windows
Windows
0.9%
0.9%
26
26
CRM
CRM
0.9%
0.9%
27
27
Sharepoint
Sharepoint
0.9%
0.9%
28
28
Linux
Linux
0.8%
0.8%
29
29
MDX
MDX
0.8%
0.8%
30
30
Salesforce
Salesforce
0.7%
0.7%
31
31
Qlikview
Qlikview
0.7%
0.7%
32
32
Web Intelligence
Web Intelligence
0.7%
0.7%
33
33
Unix
Unix
0.7%
0.7%
34
34
Oltp
Oltp
0.6%
0.6%
35
35
Kpis
Kpis
0.6%
0.6%
36
36
S3
S3
0.5%
0.5%
37
37
Universes
Universes
0.5%
0.5%
38
38
DBA
DBA
0.5%
0.5%
39
39
MDM
MDM
0.4%
0.4%
40
40
DB2
DB2
0.4%
0.4%
41
41
UAT
UAT
0.4%
0.4%
42
42
ODS
ODS
0.4%
0.4%
43
43
QA
QA
0.4%
0.4%
44
44
Netezza
Netezza
0.4%
0.4%
45
45
Procedures
Procedures
0.4%
0.4%
46
46
Informatica
Informatica
0.4%
0.4%
47
47
R2
R2
0.4%
0.4%
48
48
BO
BO
0.3%
0.3%
49
49
SAP R/3
SAP R/3
0.3%
0.3%

32,291 Business Intelligence Architect Jobs

Where do you want to work?