Find The Best BI Architect Jobs For You

Where do you want to work?

0 selections

Top BI Architect Skills

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

Want to find jobs that match your skillset?
Get recommendations that fit your preferences and skillset. We’ll recommend jobs that fit your skills and key steps to help you stand out to employers. Answer a few questions and get started.
The six most common skills found on BI Architect resumes in 2020. Read below to see the full list.

1. Analytics

high Demand

Here's how Analytics is used in BI Architect jobs:
  • Developed a sales analytics system using Tableau used by every executive at BaxAlta to predict future business needs.
  • Mentored the development team to create Business Analytics reports using Microsoft Reporting Services.
  • Designed analytics and dashboards using Tableau.
  • Brand new data mart creation for Admission, enrollment and student retention analytics with in 4months time frame end to end.
  • Designed and built data mart for SAS OLAP-based applications used in the delivery of market analytics service (predictive analysis).
  • Worked with senior architects and advisory software engineers to perform analytics on the Hedging system which is Grid enabled.
  • Worked with the OBIA Financial Analytics Suite using OBIEE 11.1.1.7.1 and designed/customized the dashboards and metrics for reporting.
  • Installed, Configured and Developed OBIA Financial, Project & HR Analytics 11.1.1.9.x for Oracle with OBIEE 11G.
  • Oversee project prioritization and technical oversight of the data warehouse systems at Office of Institutional Analytics, UNM.
  • Delivered an Enterprise Architecture and a self-service BI framework which is a foundation for Digital data analytics.
  • Involved in performance tuning of the analytics by increasing the caching size, overriding the existing SQL.
  • Created and scheduled Agents to deliver Analytics content for subscribed users and to seed the cache.
  • Created Multiple hierarchies Calendar Year and Fiscal Year for a time dimension in Corporate Analytics Project.
  • Created SQL extracts and interactive dashboards for Tableau 8.1 to make data available for visual analytics.
  • Implemented SAP HANA Live to deliver multiple SAP LoB solutions to enable real time analytics.
  • Worked with Product Owners to identify, analyze, and modules to activate Analytics Dashboards.
  • Created S3 storage for data lake repository for analytics for backup and Glacier for archives.
  • Develop ETL Automation and Enhanced Business Intelligence Analytics for all areas of the enterprise.
  • Author of small data framework for near real time web and mobile analytics.
  • Enabled Financial, SCM, Manufacturer and Procurement and Spend analytics module.

Show More

2. Business Process

high Demand

A business process is a group of tasks that are performed by people working in a business to attain a worthy product and to present it to their customers. A business process can also be defined as performing several steps to achieve a certain goal set by a company. Business processes need to set purposeful goals and the outcome of that goal should be clear.

Here's how Business Process is used in BI Architect jobs:
  • Configured Security model and business process flow.
  • Designed the dimensions and fact tables to reflect the business processes so that it could be easily understood by each department.
  • Mentored data architects and tech leads on business processes, best design & ETL practices and various BI applications.
  • Understand Business process, Landscape & Architecture for BW configuration for the BI Conversion Project.
  • Created business use cases, business process flows, data models and data mappings.
  • Involved in opportunity to cash business process in Sales Planning.
  • Worked on work status and Business process flow
  • Develop and in-depth understanding of the data, business processes, and existing solution within assigned workstream(s).
  • Implemented apache Cassandra big database for optimizing the performance of tax lot business processes.
  • Developed BI (Business Intelligence) roadmap to harmonize business processes.

Show More

3. Dashboards

high Demand

The dashboard is a data management tool used for business intelligence. Dashboards, store, organize and display the scattered data in one system providing easy access to information whenever required. The data is displayed using advanced data visualization techniques, allowing users to understand the intricate patterns in their data. Dashboards make it easier to draw parallels between different data metrics and help in the identification of data trends.

Here's how Dashboards is used in BI Architect jobs:
  • Performed data validation and unit testing on developed reports and dashboards.
  • Developed Tableau visualizations and dashboards using Tableau Desktop and Tableau Server.
  • Implemented QlikView solution to provide in-memory business analysis and dashboards.
  • Performed requirements gathering and developed new Reports and Dashboards.
  • Implement RPD Sales Framework & OBIEE Dashboards that reflects Segment Sales/Product Sales/HeatMap/YOY/MOM/New Clients Revenue/New Client Counts/PNC New Money etc., 4.
  • Created intuitive, interactive dashboards that illustrate key findings, along with providing detailed monthly and quarterly results overview to management.
  • Background This project is about producing SAP BOBJ reports and dashboards out of SAP BI system for utilities & Energy domain.
  • Designed and Developed dashboards, scorecards, charts, trends to show various KPI's to different kinds of users.
  • Published reports and dashboards in power BI website and setup the personal gateway to refresh the dashboards in scheduled time.
  • Delivered Formatted Reporting, AD-HOC Reporting, Self-Service Reporting, OLAP Analyses and Executive, Dashboards using MicroStrategy OLAP tool.
  • Trained end users on Tableau basics, workbook creation, dashboards, filters, parameters, calculated fields and more.
  • Performed Presentation Services Administration tasks like managing privileges, managing groups and users, and managing interactive dashboards and sessions.
  • Published extensively interactive dashboards on Tableau Server for Executive Committee to provide them with detail insights based on Subject area.
  • Integrate BI Publisher as the front end tool for report display to Executive Committee instead of the delivered Dashboards.
  • Created Bar Charts, Line Charts, Pie Charts, Filters and According Menu in dashboards based on requirements.
  • Created custom objects and its related reports / dashboards to hide data access from other profiles across the organization.
  • Created dashboards, scorecards, reports, indicators of different templates and integrated them on to SharePoint server 2010.
  • Develop reports, dynamic dashboards using Tableau 9 for quick reviews to be presented to Business and IT users.
  • Developed various dashboards, used context filters, sets while dealing with huge volume of data in Tableau.
  • Interacted with the business users for gathering the Reports/ Dashboards requirements and to define business and functional specifications.

Show More

4. ETL

high Demand

Here's how ETL is used in BI Architect jobs:
  • Ensured data accuracy across application interfaces by documenting ETL job process flow and communicating necessary application recovery procedures to team members.
  • Facilitated interview sessions with the client's business stakeholders to gather and develop reporting requirements and to develop ETL requirements.
  • Translated requirements into designs for a solution that incorporates ETL components.
  • Worked very closely with Project Managers and Product management to understand the requirement of ETL and reporting solutions to be built.
  • Created the Data & ETL Architecture Reference document and guided RAD sessions between reporting, modeling, mapping and ETL teams.
  • Performed ETL to extract, transform and load data from multiple data sources including IMS data files and SAP data files.
  • Re-designed the Clinical Data Warehouse, including ETL, Stored Procedures, Universe Design, Report Design, and Database Design.
  • Managed the team in all the development efforts which include ETL, RPD, Report, DAC and Database changes.
  • Ensured technical designs conformed to the overall ETL Architecture standards, adhering to data governance policies and ensuring data quality.
  • Played a role of ETL Design- Designed and developed SSIS package for Partnership Form data from excel to EYPTS database.
  • Recommended & debugged legacy PL/SQL packages, procedures, functions and views for systems & converted them in to ETL.
  • Identified and implemented policies, standards and procedures in the ETL environment while ensuring industry best practices were followed.
  • Led 5-person development team in design of data warehouse model providing direction to DBA, ETL and reporting teams.
  • Worked with DB, ETL and business analysts to identify tables and columns in both Development and Production Environments.
  • Developed a Dynamic ETL system that effectively does complete ETL for all facts and dimensions in a single package.
  • Implemented SSIS ETL Framework and methodology along with structured development process leveraging Team Foundation Server (TFS).
  • Define and solution ETL strategies to support data integration, aggregation and mining between internal and external systems.
  • Help in designing the ETL Architecture, and also adopting the solutions to tool of choice, SSIS.
  • Involved with major aspects of QlikView development, including scripting, data modeling, data optimization, ETL.
  • Create Unix shell scripts, Perl scripts to schedule the mappings in batch process with ETL process dependency.

Show More

5. Tableau

high Demand

Here's how Tableau is used in BI Architect jobs:
  • Contributed towards standards development for Tableau Data Visualization tool.
  • Configured and optimized Tableau Server.
  • Provided SAP, Tableau tool training to internal team as well as the cross functional analysts across the health system.
  • Created maps and charts in Tableau to capture various metrics (annual rent, occupancy per floor etc.)
  • Created repeatable processes for data extraction, classification, enhancement, and analysis activities in Tableau.
  • Communicate Data Patterns, Anomalies, Metrics & Relationships through Tableau as Data visualization tool.
  • Developed MS analysis Reports, Input Templates and Tableau Dashboard on HANA views.
  • Administered users, groups, and scheduled instances for reports in Tableau server.
  • Created custom admin views to monitor tableau server activities on periodic basis.
  • Used Tableau to create reports and publish them on the server.
  • Created views in Tableau Desktop based on the business requirements.
  • Defined DEV, UAT and PRD Tableau BI environments.
  • Developed new Tableau visualizations based on the business need.
  • Set up best practices for Tableau development and administration.
  • Used Row level security feature in Tableau.
  • Designed, and developed Tableau reports.
  • Installed and Configured Tableau Server.
  • Designed Tableau Server maintenance strategy, security and per-missioning rights for user teams or individuals, scheduling, notifications.
  • Rolled and monitored the progress of Tableau adaptability Implemented Standards and best practices and documentation.
  • Developed business dashboard with multiple panels and parameters that became a favorite sales tool for most of the Salesforce using Tableau.

Show More

Job type you want
Full Time
Part Time
Internship
Temporary

6. Data Warehouse

high Demand

Data warehouse, often abbreviated as either DW or DWH is a system used in computing for data analysis as well reporting. The DW is also considered to be an integral component of business intelligence as they also provide storage facilities for both real-time and historical data. ETL and ELT are the two driving forces behind a data warehouse system.

Here's how Data Warehouse is used in BI Architect jobs:
  • Fostered strong relationships with data architecture, database administration and data consumers including designs for both OLTP and Data Warehouse/BI structures.
  • Recommended and demonstrated cost and performance benefits business would get by migrating existing Data Warehouse to Novartis BICC US environment.
  • Lead all the data warehouse initiatives of Capitol Indemnity including current system maintenance and enhancements/new development initiatives.
  • Gathered user and functional requirements, developed data models, and implemented NineWest Data warehouse.
  • Developed various SSAS Tabular Models to facilitate data validation for Enterprise Data Warehouse development project.
  • Performed source data analysis to identify entities and attributes list for data warehouse.
  • Defined migration strategy to migrate data from mainframe system into data warehouse.
  • Designed and Developed Logical/Physical Data Model for Data warehouse and E-business application.
  • Performed requirements analysis and established new standards for the data warehouse.
  • Gathered business requirements for enterprise wide data warehouse project.
  • Designed data warehouse architecture and developed database data models.
  • Develop reporting applications and ensuring data warehouse consistency.
  • Prepare technical documentation for data warehouses.
  • Gathered user and functional requirements, developed data models, designed and implemented custom developed data warehouse in SAP BW system.
  • Created Mining structures and mining models to predict the Foreign Exchange conversion rate depending the past history from a data warehouse.
  • Key liaison among business owners, functional analysts, application developers, and data warehouse teams to clarify functional design questions.
  • Worked on all phases of data warehouse development life cycle, from gathering requirements to testing, implementation, and support.
  • Synchronize different DB servers and Applications: Data Environments DEV, QA and PROD (Relational, Data Warehouse).
  • Developed BW project plan and estimated cost to implement custom data warehouse for all primary and ceded insurance business reporting.
  • Design, development and support of Dimensional data model using SSAS Cubes on top of MS SQL 2008 Data Warehouse.

Show More

7. Architecture

high Demand

Here's how Architecture is used in BI Architect jobs:
  • Performed architecture and code review of the existing business model, established development and delivery processes, designed project execution plan.
  • Developed technical architecture descriptions, design specifications, operational and maintenance procedures and installation qualification and operational qualification scripts.
  • Gathered reporting requirements to deliver reporting tools, architecture, infrastructure, and security recommendations.
  • Involved in extensive analysis of source systems, existing database architecture, mapping reporting requirements.
  • Designed and validated the high-level proposed solution architecture with Data Analysis and Data Architecture.
  • Provided architecture vision for integration, upstream downstream layouts for enterprise Applications.
  • Manage the enterprise level architecture and production management of Pension system.
  • Performed architecture and configuration analyses of DEV and QA environments.
  • Worked with Business Objects Security and understanding of system architecture.
  • Analyzed enterprise data sources and design integration solutions and architecture.
  • Designed APO-BI interface architecture design and implementation for Demand Planning.
  • Developed additional standards and processes surrounding BI data architecture.
  • Trained Cognizant Internal Project Folks for Hybrid architecture implementation.
  • Worked on BPC application architecture, performance enhancement using optimization
  • Provided management with strategies for development and computing architecture.
  • Created HLD/LLD documents and provided Solution Architecture Document.
  • Identified custom extraction needs and documented architecture.
  • Defined high-level future-state application architecture and infrastructure.
  • Developed technical architecture design and documentation.
  • Defined future state data architecture.

Show More

8. Ssis

high Demand

Here's how Ssis is used in BI Architect jobs:
  • Created SSIS packages using various control flow tasks like For Each loop, File system task, Send Mail Task etc.
  • Designed SSIS Packages to transfer data from various sources like Excel Files, SQL Server using Business Intelligence Development Studio.
  • Converted process that associates order items with a promotion from a massive stored procedure to a sustainable SSIS solution.
  • Created SSIS framework from scratch to perform logging, error handling, status, job management and timings.
  • Created SSIS packages to extract data from OLTP to EDW systems and scheduled Jobs to call the packages.
  • Installed and configured several tools including but not limited to SQL Server 2005/2008, SSIS 2005/2008, SSRS 2005/2008
  • Developed common framework in SSIS package to bring the data from PDW servers to EDW Metadata Reports database.
  • Used SSIS to load data from various sources into on SQL Server 2012 database and created packages.
  • Worked with SQL Server 2008 and created packages in SSIS to load data to the staging area.
  • Implemented SSIS package which used SFTP protocol to download files and then used them in feed Processing.
  • Build, deployed and executed SSIS packages in both the environments (Development and Production).
  • Build a business rule engine using T-SQL and SSIS to enhance and ensure data quality.
  • Use SSAS to validate the results of loading incremental data made up with SSIS packages.
  • Created SSIS packages to dynamically create staging tables and Switch it with fact table partition.
  • Support production system for OLTP and post deployment SSIS packages/ SSRS Reports on the server.
  • Created Views and used client for pulling data into SQL server using SSIS.
  • Created an SSIS solution that process approved orders for new store kits.
  • Develop and support SSIS import packages for DBA activities and Cube support.
  • Contracted to develop scheduled SSIS jobs for the BI process at ORNL.
  • Provided expertise in SSIS, SSAS design, configuration and customization.

Show More

9. SQL

high Demand

Here's how SQL is used in BI Architect jobs:
  • Structured and maintained initial SQL Server infrastructure including disaster recovery and database mirroring.
  • Defined partitioning strategy, performed extensive tuning (explain plan, logical i/o, waits) and defined best SQL practices.
  • Redesigned cube SQL source to cut disk requirement by 10 plus minimized stress on internal storage during cube partitions processing.
  • Converted an executive level performance reporting system built in SAS to one built on SQL Server SSAS and SSRS.
  • Modeled metadata from SQL Server 2005 data source for use in Report studio and Query Studio using Framework Manager.
  • Worked on Development, Data Load and Deployment of Data Model for Clients using SQL Master Data Services 2012.
  • Worked within a group to create a fail-over strategy for Power Exchange Listeners and Oracle and SQL Server databases.
  • Developed Stored Procedures and custom macro based SQL's to be used as data source query subjects.
  • Integrated 3rd party product - SQDR and enabled 'real-time' data replication between DB2 and SQL server.
  • Installed and configured OBIEE 11g, 10g for development, test and production environments with SQL Server.
  • Run Trace files on SQL Server and SSAS environment to get the duration of long running queries.
  • Created SQL server agent jobs to run packages and setup alerts for job failures and success.
  • Trouble-shoot and optimize SQL stored procedures, implement partitioning, high availability and cloud solutions.
  • Create SQL Server Agent jobs for the incremental and full processing of the SSAS cubes.
  • Coded and implemented all backup and restore routines for Oracle and SQL Server.
  • Created a SQL Server 2012 Reporting environment in order to host BI reports.
  • Designed, Developed and Deployed packages in SQL server environment using SSIS-2013.
  • Performed Development tasks with SAP HANA programming including SQL, SQL Script.
  • Develop SQL scripts and stored procedures to provide 4 way recon reports.
  • Analyzed IO performance at logical, physical and application SQL levels.

Show More

10. Ssrs

high Demand

Here's how Ssrs is used in BI Architect jobs:
  • Developed SharePoint solutions with SSRS reports and web parts for external clients based on data rendered by SSAS cubes.
  • Designed and created the reports against relational and OLAP databases as per the user requirements using SSRS 2005.
  • Design and development of both statistical and BI related reports using SSRS and Stored Procedures.
  • Used that calculated measures in SSRS reports by using source connection as cube in SSRS.
  • Designed and implemented reporting server to house and distribute SSRS reports.
  • Implemented 'forms authentication' on SSRS using custom security extensions.
  • Installed and configured SSRS 2008 and SSRS 2012 Reporting Services.
  • Created a Master SSRS report with more than 200+ sub-reports.
  • Configured and deployed SSRS report in SharePoint environment.
  • Design and development of SSRS Reports.
  • Developed integrity check reports with SSRS.
  • Designed the data driven SSRS template.
  • Create multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts.
  • Design & Code SSRS reports.
  • Designed and developed reports in SSRS Diagnose and fix issues reported in Development and Production environment.
  • Provided canned reports and Reporting Data Model using SSRS for Analysts to generate ad-hoc reports.
  • Recreated legacy .net reports and SSRS reports in Business Objects and provided same functionality.
  • Designed and developed T-SQL queries to create SSRS datasets.
  • Design OLAP/Ad-hoc reports for business users using SSRS.
  • Improved reporting SSRS (datasets/design)

Show More

Find which skills are in demand

Skill Page Callout

Jobs With Trending Skills

11. Data Analysis

high Demand

Here's how Data Analysis is used in BI Architect jobs:
  • Gathered business requirements, performed data analysis, created mapping documents and conducted code reviews.
  • Perform data analysis/data mapping to identify legacy custody data available in GDW.
  • Conducted in-depth data analysis to understand business information needs.
  • Apply BI and DW Best Practices in solution delivery and solution architect; apply Big Data analysis to improve Data Management.
  • Perform data analysis and come up with requirement gap assessment of data sets.
  • Performed Data Analysis in the working Subject areas for identifying Data discrepancies.
  • Risk data analysis, graphical presentation using SAS Graph and ODS layer.
  • Conducted data analysis using the PowerPlay Transformer cubes and DQM models.
  • Involved in Data Analysis of the existing system.
  • Integrated Google Bigquery into company data framework to enable extremely efficient data analysis of multi-terabyte data sets.
  • perform data analysis via SQLs, data cleansing and implement data quality procedures.

Show More

12. Data Models

high Demand

Here's how Data Models is used in BI Architect jobs:
  • Activated business content for Material Ledger prices and updated custom data model to reflect historic material valuation for blend components.
  • Performed data modeling, application development, technical product assistance and tuning to meet customer performance and functional requirements.
  • Developed custom data models to accommodate business requirements of material component breakdown, blend composition, and valuation.
  • Performed reverse engineering using Erwin to generate ERD diagram/data model from vendor databases.
  • Worked as a data modeler and developer in various application development initiatives.
  • Defined conceptual data model for marketing database based on business requirements.
  • Recommended and developed new Data Models for multiple cross functional databases.
  • Worked on conceptual data models associated with area of responsibility.
  • Improved overall data model and introduced data model layering concept.
  • Analyzed user requirement for data modeling and reporting requirement.
  • Created data models from different source systems and modeled the as a composite provider in SAP BW basing on SAP HANA.
  • Analyzed existing Reports and have performed mapping to them with CRMOD Data Model for Reporting to be done within CRMOD.
  • Designed and delivered data model and OBI solution that would dynamically add dimensions and measures with minimal effort on development.
  • Tax Reporting: Implemented new Tax reporting data model and WEBI reports for use tax and tax paid to vendor.
  • Created ERD, did Data modeling at the canonical, conceptual, logical, physical and model management levels.
  • Created a Data model to connect the opportunities and Deals generated by SFDC with the bookings and the fulfillment.
  • Analyzed the reporting requirements and developed a Data Model that was best suited for meeting the business critical requirements.
  • Prepared Metadata model to support Ad-Hoc model for newly created Financial Tables in RDW and published the package.
  • Performed gap analysis, created functional, architectural designs, reviewed Data Modeling designs with functional team.
  • Implemented cache management strategy, data purge strategy, performance tuning strategy, and data model strategy.

Show More

13. Ssas

high Demand

SQL Server Analysis Services (SSAS) is an intricate OLAP server and analytics engine that can manage large quantities of data. It has two variations, Multidimensional and Tabular. As part of Microsoft SQL Server, it can perform analysis using various dimensions. Organizations use this tool to analyse information across multiple databases, or in disparate files or tables. It creates cubes using data from data marts/data warehouse for in-depth for quicker data analysis. Installed as an on-premises server, SSAS supports tabular models at all compatibility levels, data mining, multidimensional models, and Power Pivot for SharePoint.

Here's how Ssas is used in BI Architect jobs:
  • Created new reports and updated existing reports (Online Reports, Customer Reports) that sourced information from the SSAS Cube.
  • Designed and developed a solution for financial reporting using SSAS and Excel to replace the current Hyperion based solution.
  • Developed a custom SSAS DLL that generated Member Sets based on a keyword parameter.
  • Develop and architect SSAS cubes using tabular and multidimensional cubes for self-service BI.
  • Developed SSAS data mining models for predictive analysis for sales and marketing.
  • Designed dimensional model for SSAS Cube source database.
  • Created Analysis tabular cube using SSAS.
  • Connect to the SSAS cube using Excel 2007 & 2010.
  • Designed and developed multi dimensional Cube databases using SSAS.
  • Developed SSAS Tabular Models for the company s Prologis One Executive Dashboard.
  • Cube Development using SSAS 2012 (both multi-dimensional and tabular).
  • Deployed SSAS dimensions for BI reporting using Cognos and Crystal Reporting.
  • Design MOLAP/ROLAP cubes on Teradata Database using SSAS.
  • Defined and designed project scope Create Dimensions and Fact tables Designed, built and deployed MOLAP cubes in SSAS.
  • Developed a .Net application that automatically generated SSAS custom security roles based on user department assignments.

Show More

14. Olap

high Demand

Here's how Olap is used in BI Architect jobs:
  • Involved in designing and developing subject areas in Repository (.RPD) catering to the OLAP reporting needs of OBI Project.
  • Structured the reporting requirements and consolidated the reporting needs against OLTP and OLAP (TM1 Cubes, MSAS) sources.
  • Worked on Dashboard development using Design Studio with BW OLAP sources as the back-end.
  • Drive and specify global design and development principles to be deployed for OLAP reporting.
  • Developed OLAP application including the SAS MDDB Viewer and Microsoft Office Web Components.
  • Created brand new OLAP cube for Online Reporting and Customer Reporting.
  • Designed and developed DTS packages, designed and enhanced OLAP cubes.
  • Lead Logical & Physical Design of OLTP & OLAP Databases.
  • Designed and implemented OLAP cubes using SAS OLAP Cube Studio.
  • Designed multiple Cubes using IQD's using Transformer for OLAP.
  • Developed Schema objects, public objects and OLAP functionality.
  • Designed and Implemented OLAP Cubes.
  • Created OLAP Universe from SAP BI cube / Multi-provider / ODS data model in Universe Designer.
  • Configured DAC server host along with informatics servers and OLTP and OLAP physical sources.
  • Created Universes and Reports based on BEx quires and OLAP reports with BICS.
  • Worked on Business objects OLAP Reporting systems based on BEx Reports.
  • Maintained BW and BOBJ OLAP applications for sales, finance, Vistex, SPM & HR.
  • Educated Users on WEBI and OLAP and Xcelsius(Dashboard).
  • Created OLAP Universes on SAP data (Infocubes / BEx queries) and Relational Universes on Non-SAP data
  • Upgraded Cognos 7 environment to Cognos 8 along with all key components such as Portal, reportnet, OLAP Cubes etc.

Show More

15. Data Quality

average Demand

Here's how Data Quality is used in BI Architect jobs:
  • Designed and deployed data governance process for managing the master data, using IDQ for analyzing data quality/ data profiling.
  • Worked on analyzing data quality issues and provide and implement possible solutions with a clear and concise project planning.
  • Worked with Match Transforms, Address Cleanse and Data Cleanse Transforms for US Data Cleansing in Data Quality.
  • Designed and configured the Address Verification feature of Data Quality Management (DQM 4.0) at MUD.
  • Supported Web-based reporting, ABAP routines, Data Quality Management, Cube Statistics and Environment Management.
  • Worked on Design strategy, Source System analysis, Data Quality, Requirement's gathering.
  • Created metadata based process which verifies data quality and alerts as per its threshold.
  • Gained solid trust on the data quality by providing a single version of truth.
  • Analyzed and designed a data quality project for City of Tulsa using MS DQS.
  • Worked on the Data Quality, Address cleanse transformations for cleansing the data.
  • Implemented the data quality model.
  • Provided end user training, customizations, troubleshooting of load scripts and data quality.

Show More

16. Informatica

average Demand

Here's how Informatica is used in BI Architect jobs:
  • Provided development best practices and technical support on the installation/configuration and development using Informatica.
  • Extracted Customer/Address/Contacts data from SFDC through Informatica.
  • Used C program to convert DAASC Internal Messaging Format files to standard ASCII text for further processing by Informatica PowerCenter.
  • Lead POC efforts for the following Informatica Products: PowerCenter Real-time web services, Release management and Metadata Manager.
  • Optimized the performance of the Informatica mappings by analyzing the session logs and understanding various bottlenecks (source/target/transformations).
  • Designed and developed Informatica PowerCenter programs to extract, transform, and load data into AFDS.
  • Have developed Informatica Web services & these services are being consuming by Integration teams.
  • Experience on working with running daily jobs on Informatica for data loading.
  • Extracted Data from various source systems using Informatica and stored procedures.
  • Model the data load with Informatica lead.
  • Identified infrastructure needs for implementation of the new environment including the latest greatest Informatica Tool releases.
  • Analyzed informatica metadata repository and teradata query log for long running sessions/query and resource utilization.
  • Obtained efficiency by pulling data instead SAP pushing data into Teradata via Informatica.
  • Created new ETLs using informatica to handle complex multiple hierarchy reporting requirement.
  • Configured Informatica servers /Connections/Logical folders setup in DAC.
  • Developed Teradata BTEQ script and Informatica mappings.
  • Convert custom code from OBIA (7.6.3) - Informatica mappings to corresponding interfaces of ODI.
  • Performed the role of SAP Business Objects SME and also supported Informatica Power Center efforts.
  • Have developed Informatica workflows to consume data from Webservices.
  • Implemented integration of business segmentation between Informatica MDM and Salesforce for Sales Process using Informatica Web service (SOAP).

Show More

top-skills
What skills help BI Architects find jobs?
Tell us what job you are looking for, we’ll show you what skills employers want. Get Started

Online Courses For BI Architects

One of the best ways to acquire the skills needed to be a bi architect is to take an online course. We've identified some online courses from Udemy and Coursera that will help you advance in your career. Since bi architects benefit from having skills like analytics, business process, and dashboards, we found courses that will help you improve these skills.

Advertising Disclosure
advertising-disclosure
Complete Business Intelligence with SSIS, SSAS and SSRS
udemy
3.8
(340)

Master Microsoft BI by solving Real-Life Problems. Learn ETL, Integration, Analytics, Reporting and Visualization!...

Become an SQL Developer: Learn (SSRS, SSIS, SSAS,T-SQL, DW)
udemy
3.9
(1,573)

Learn SQL Developer Skills from Scratch(SSRS, SSIS, SSAS,T-SQL, Data Warehouse(DW))...

Learn MSBI, SSIS, SSRS and SSAS Step by Step
udemy
4.5
(2,455)

This course teaches you MSBI from basic level to advanced level. Covers all 3 concepts SSIS, SSAS and SSRS...

Microsoft Power BI - Business Intelligence for Beginners
udemy
4.4
(4,963)

Beginner Course on Power BI: Business Intelligence & Data/Business Analysis with Microsoft Power BI...

Learn Data Warehousing and Analysis with Microsoft BI Tools
udemy
4.5
(362)

Learn how extract, clean and load data in a database using Microsoft Excel and Business Intelligence tools...

Data Warehousing for Business Intelligence
coursera

Evaluate business needs, design a data warehouse, and integrate and visualize data using dashboards and visual analytics. This Specialization covers data architecture skills that are increasingly critical across a broad range of technology fields. You'll learn the basics of structured data modeling, gain practical SQL coding experience, and develop an in-depth understanding of data warehouse design and data manipulation. You'll have the opportunity to work with large data sets in a data warehous...

Microsoft Power BI Desktop for Business Intelligence
udemy
4.6
(39,197)

Master Power BI Desktop & learn advanced Power BI analysis & data visualization w/ a top Microsoft Power BI instructor...

Design and Build a Data Warehouse for Business Intelligence Implementation
coursera

The capstone course, Design and Build a Data Warehouse for Business Intelligence Implementation, features a real-world case study that integrates your learning across all courses in the specialization. In response to business requirements presented in a case study, you'll design and build a small data warehouse, create data integration workflows to refresh the warehouse, write SQL statements to support analytical and summary query requirements, and use the MicroStrategy business intelligence pla...

SAP BI /SAP Business Objects Web Intelligence
udemy
4.1
(687)

SAP BO 4.1 Web Intelligence course gives you the comprehensive reporting knowledge and real-project perspective!...

Business Intelligence and Automated Reports using Power BI
udemy
4.3
(285)

Self-service Business Intelligence with complex, insights-rich, interactive reports and dashboards in Power BI Pro...

Azure SQL Data Warehouse Synapse Analytics Service
udemy
4.5
(808)

Cloud Data Warehouse in Azure Synapse Analytics Service (formerly Azure SQL Data Warehouse). [Covered: DP-200, DP-201]...

Microsoft Power BI Desktop - Data Analytics with Dashboards
udemy
4.1
(343)

Learn Microsoft PowerBI to build interactive dashboards in Microsoft Power BI Desktop and PowerBI Service...

Data Warehouse Concepts: Basic to Advanced concepts
udemy
4.1
(2,349)

Data Warehouse Concepts: Learn the in BI/Data Warehouse/BIG DATA Concepts from scratch and become an expert...

SQL Server SSAS (Multidimensional MDX) - an Introduction
udemy
4.6
(1,404)

Create cubes from databases, analyse them in Excel, SSRS etc. using SSAS MDX (a Business Intelligence tool)...

Power BI A-Z: Hands-On Power BI Training For Data Science!
udemy
4.5
(14,503)

Learn Microsoft Power BI for Data Science and Data Analytics. Build visualizations and BI reports with Power BI Desktop...

Power BI - Data Analytics Essentials with Power BI
udemy
4.6
(2,980)

Get Started Quickly with Visualization, Data Prep and DAX on Power BI...

Learning Path: The Roadway to IBM Cognos Analytics
udemy
3.8
(378)

Acquaint with new unified interface of Cognos Analytics to consume, modify, and author dashboards...

Microsoft Certified: Data Analyst Associate with Power BI
udemy
4.2
(3,132)

Analyzing and Visualizing Data with Microsoft Power BI - Exam Guide. Get Microsoft Certified in 30 days...

SQL - MySQL for Data Analytics and Business Intelligence
udemy
4.6
(29,139)

SQL that will get you hired SQL for Business Analysis, Marketing, and Data Management...

Learn Data Warehousing From Scratch- From Solution Architect
udemy
4.2
(688)

Real life data warehouse guide from the industry expert. Succeed in BIDataWarehouseData ModelBIGDATA...

20 Most Common Skill For A BI Architect

Analytics10.5%
Business Process6.9%
Dashboards6.9%
ETL6.7%
Tableau6.4%
Data Warehouse5%
Architecture4.1%
Ssis3.8%

Typical Skill-Sets Required For A BI Architect

RankascdescSkillascdescPercentage of ResumesPercentageascdesc
1
1
Analytics
Analytics
10.5%
10.5%
2
2
Business Process
Business Process
6.9%
6.9%
3
3
Dashboards
Dashboards
6.9%
6.9%
4
4
ETL
ETL
6.7%
6.7%
5
5
Tableau
Tableau
6.4%
6.4%
6
6
Data Warehouse
Data Warehouse
5%
5%
7
7
Architecture
Architecture
4.1%
4.1%
8
8
Ssis
Ssis
3.8%
3.8%
9
9
SQL
SQL
3.3%
3.3%
10
10
Ssrs
Ssrs
2.7%
2.7%
11
11
Data Analysis
Data Analysis
2.7%
2.7%
12
12
Data Models
Data Models
2.4%
2.4%
13
13
Ssas
Ssas
2.4%
2.4%
14
14
Olap
Olap
2.1%
2.1%
15
15
Data Quality
Data Quality
2%
2%
16
16
Informatica
Informatica
1.8%
1.8%
17
17
SAP BW
SAP BW
1.5%
1.5%
18
18
Data Marts
Data Marts
1.5%
1.5%
19
19
Schema
Schema
1.5%
1.5%
20
20
QA
QA
1.4%
1.4%
21
21
Web Intelligence
Web Intelligence
1.4%
1.4%
22
22
Hadoop
Hadoop
1.4%
1.4%
23
23
Procedures
Procedures
1.4%
1.4%
24
24
CRM
CRM
1.3%
1.3%
25
25
Microstrategy Desktop
Microstrategy Desktop
1.2%
1.2%
26
26
Cognos
Cognos
1.1%
1.1%
27
27
KPI
KPI
1%
1%
28
28
Master Data
Master Data
1%
1%
29
29
BI
BI
0.9%
0.9%
30
30
Java
Java
0.9%
0.9%
31
31
T-Sql
T-Sql
0.9%
0.9%
32
32
Teradata
Teradata
0.9%
0.9%
33
33
Technical Specifications
Technical Specifications
0.9%
0.9%
34
34
Sharepoint
Sharepoint
0.8%
0.8%
35
35
Windows
Windows
0.8%
0.8%
36
36
EDW
EDW
0.8%
0.8%
37
37
BO
BO
0.7%
0.7%
38
38
DB
DB
0.7%
0.7%
39
39
Pl/Sql
Pl/Sql
0.6%
0.6%
40
40
ECC
ECC
0.6%
0.6%
41
41
Bobj
Bobj
0.6%
0.6%
42
42
User Interface
User Interface
0.5%
0.5%
43
43
SAS
SAS
0.5%
0.5%
44
44
Linux
Linux
0.5%
0.5%
45
45
POC
POC
0.5%
0.5%
46
46
DB2
DB2
0.4%
0.4%
47
47
HR
HR
0.4%
0.4%
48
48
Oltp
Oltp
0.4%
0.4%
49
49
Data Source
Data Source
0.4%
0.4%
50
50
UAT
UAT
0.4%
0.4%

43,394 BI Architect Jobs

Where do you want to work?