BI Architect Resume Samples
4.5
(125 votes) for
BI Architect Resume Samples
The Guide To Resume Tailoring
Guide the recruiter to the conclusion that you are the best candidate for the bi architect job. It’s actually very simple. Tailor your resume by picking relevant responsibilities from the examples below and then add your accomplishments. This way, you can position yourself in the best way to get hired.
Craft your perfect resume by picking job responsibilities written by professional recruiters
Pick from the thousands of curated job responsibilities used by the leading companies
Tailor your resume & cover letter with wording that best fits for each job you apply
Resume Builder
Create a Resume in Minutes with Professional Resume Templates
CHOOSE THE BEST TEMPLATE
- Choose from 15 Leading Templates. No need to think about design details.
USE PRE-WRITTEN BULLET POINTS
- Select from thousands of pre-written bullet points.
SAVE YOUR DOCUMENTS IN PDF FILES
- Instantly download in PDF format or share a custom link.
AT
A Treutel
Alfonso
Treutel
124 Kayleigh Fords
Dallas
TX
+1 (555) 148 3166
124 Kayleigh Fords
Dallas
TX
Phone
p
+1 (555) 148 3166
Experience
Experience
Boston, MA
BI Architect
Boston, MA
Auer and Sons
Boston, MA
BI Architect
- Develop best practices and standards for data access and perform reviews with product management teams to ensure they are being used
- Manage change control according to the development policy
- Provide best practices in ETL Architecture, Data Architecture, BI Architecture, Information Governance, Data Quality and Master Data Management
- Design, development, testing, performance tuning, roll out and ongoing enhancements of
- Review and provide input into key aspects of the business case and work effort for a specific project
- Work with EDW Manager and Security Architect to implement security architecture within the data access/Presentation area
- Provide solution performance analysis and tuning
Detroit, MI
Microsoft BI Architect
Detroit, MI
Hand-Weimann
Detroit, MI
Microsoft BI Architect
- Liaise and attend meetings necessary to perform duties and aid business and technical development
- Guide and coach developers, share best practices, perform code reviews
- Assist business development team with pre-sales activities and RFPs
- Develop dimensional data models and SSAS cubes on SQL Server DB
- Design, develop and maintain Data Warehouse using best practices
- Develop and maintain SSIS/ETL packages
- Design and develop Integration (ETL, ELT, Data Governance, MDM) processes using MS SQL Server 2012 SSIS, DQS, MDM or other related tools/technologies
present
Houston, TX
Senior BI Architect
Houston, TX
Hand-Leuschke
present
Houston, TX
Senior BI Architect
present
- Expertise in all areas of data warehousing (architecture, data sourcing/acquisition, integration, transformation, presentation)
- Participate in developing and documenting technical standards and best practices for the BI organization
- Design reporting architecture and provide recommendations for reporting technology
- Nice to Have: ETL & Data Warehousing technologies including Ab Initio, Talend, etc
- Design ETL architecture including CDC, mappings, data flows, procedures, schedules, etc
- Data and BI reporting systems, models, and architectures
- Help solve complex production issues spanning multiple tiers in the BI/DW technology stack
Education
Education
Bachelor’s Degree in Computer Science
Bachelor’s Degree in Computer Science
Auburn University
Bachelor’s Degree in Computer Science
Skills
Skills
- Quick learner and ability to code and test quality applications in an scrum / agile environment
- Experience with BI Platforms such as OBIEE, Tableau, SSRS Experience with programming languages like Java/Javascript, SQL
- Ability to pass a thorough background check and drug test
- Good verbal and written communication skills to interface with the team and business stakeholders
- Self-motivated analytical thinker and able to work with minimal supervision
- Ability to lead and liaison between cross functional teams within the organization
- Creating and maintaining financial reports and have solid understanding of data analytics
- Strong architecture design and modeling capabilities Common Competencies
- Provide best practices in ETL Architecture, Data Architecture, BI Architecture, Information Governance, Data Quality and Master Data Management
- Evaluating various BI products and be able to implement/migrate to a new BI solution
15 BI Architect resume templates
Read our complete resume writing guides
1
Microsoft BI Architect Resume Examples & Samples
- Design ETL architecture including CDC, mappings, data flows, procedures, schedules, etc
- Coordinate activities with data source application owners to ensure integration within data warehouse and that data integrity issues are addressed
- Liaise and attend meetings necessary to perform duties and aid business and technical development
- The ideal candidate will have 5 + years of hands-on professional experience
- Excellent organizational, verbal and written communication skills
- 3+ years of prior consulting experience
- Has good knowledge of standard methodologies, concepts, best practices, and procedures within a Business Intelligence environment
- A certain degree of creativity and latitude is required as well as flexibility in job role and working hours during critical deliveries
2
BI Architect Resume Examples & Samples
- Identify and develop new data sources for use throughout the organization. Develop data sources, stages for immediate use, designs a process or plan for integration into overall infrastructure and manage integration to completion
- A minimum of ten years experience in computing or information science oriented area
- Bachelor’s degree, or equivalent experience, in Computer
- Science, Mathematics, Statistics, or related field .Advanced degree preferred
- Excellent management, project management, organizational, analytical and technical skills
- Demonstrated proficiency in programming in SAS, Easytrieve, COBOL, SQL, PEARL, or JAVA
- Demonstrated ability in managing a multitude of projects and requests of varying degrees of complexity
- Excellent interpersonal, presentation, organizational, and written and verbal communication skills
3
SAP Business Objects / BI Architect Resume Examples & Samples
- The SAP Business Objects/ Business Intelligence Solution Architect works closely with the Business Leads and IT Leads to complete the requirements planning, and then carries out development and day-to-day operational activities. This includes
- Bachelor’s degree from an accredited college or university required in Computer Science, Mathematics, Engineering or related field
- The SAP Business Objects Solution Architect must have prior SAP Business Objects development experience as well as a broad background and experience with Data Warehouse development
- Best practices Business Objects modeling/ universe concepts
- Integration points between Business Objects, BW, HANA, OLAP, etc
- Business Objects Administration
- Strong SAP BI Business Objects Development and integration skills (minimum 5 years’ experience)
- Expert in developing in SAP BI including
- Bachelor’s degree in Information Systems/ Accounting or Business from an accredited institution is required
- Minimum 2 years Experience in SAP BW 7.30 or later (Netweaver 2004s) environment required
- Minimum 2 years experience in leading teams consisting of on-shore and offshore consultants
- Minimum 5 years Strong Technical/ Functional Knowledge of SAP Business Objects and BI with BEx Analyzer and Web Application Designer
- Minimum 5 years of hands-on SAP Business Objects using Web Intelligence and Dashboards, performance debugging, and tuning. Knowledge in SAP BW and integration to Business Objects required
- Minimum 3 full SAP project life cycle implementations, following the ASAP or an equivalent systems methodology
- Excellent Verbal, Written, Presentation and Communication Skills to interface with all levels of leadership with Customers & IT
- Minimum 1-2 years managing SAP Business Objects projects and upgrades
- Experience working in large global/ multinational corporations
- Super great attitude and willingness to learn new areas
- Ability to build strong relationships with business partners and be comfortable managing large teams
- Minimum 3 years of working knowledge of MS Office Tools (MS Excel, PowerPoint, Visio, Word)
- ETL Technology: SAP BW/ Teradata/ Tableau
- Knowledge of SAP Business Objects tools such as
- Self-starter with minimum supervision, in a fast paced environment with tight deadlines and ability to interact with global users of the application
- ABAP experience is a Plus
- Mercury Quality Center experience is desirable
- Experienced and comfortable working with culturally diverse outsourced on/offshore staff in post-production environment with high service levels
- Knowledge of SAP Portal a plus
- Experience with SAP BPC is a big plus
- Familiarity with SAP Solution Manager a plus
4
BI Architect Resume Examples & Samples
- Provide guidance on the BI tool to use for various use-cases
- Propose the BI Technology stack and architecture to use within the analytical platform
- Implement standards and best-practices for the selected BI Tools
- Develop a generic framework for a Common Dashboard and Reporting platform that can be used by various business units in various use-cases
- Identify and implement the best integration with Big Data systems to get optimal performance and scalability
- Lookout for new tools and technologies that may come-up and evolve the system to stay current and leverage the best without compromising security, stability and scalability of the existing system
- Collaborate with team and project members, brainstorm ideas, and innovate
- Understand the business requirements and identify the best solution, technology and tool
- Has a minimum of 5 years of experience in the BI and Analytics field
- Has extensive hands-on experience in at least two leading BI Tools such as Tableau, QlikView, Cognos and Business Objects
- Proven track record of successful BI and Analytics Experience in large projects
- Has good understanding of the various BI tools and how they fit for various business requirements
- Integrated BI tools with any Big Data system such as Hadoop, Vertica, Aster, HANA
5
SAP BI Architect Resume Examples & Samples
- Work closely with BI technical architect to implement the technical programme including application upgrades and HANA implementation,
- Manage the change request and global BI support function to ensure timely and appropriate resolution of all business requests,
- Work with business partners to define requirements, analyse and propose initiatives,
- Contribute to the technical data model and reporting design of business reporting solutions
- Development of the technical solutions to meet business requirements
- Develop junior BI technical resources,
- 5 years + experience as a SAP BW developer (BeX 3.5 and 7.0)
- Extensive SAP BW / SAP BI experience in regards to architecture, design, back end extraction, modelling, front end reporting
- Have experience in the areas of BI authorisations, complex currency reporting, performance monitoring, BI Accelerator and data archiving
- Experience in CO-PA, MM, SD and FI
- Intermediate level of ABAP
- Experience in SAP BO CMC
- An ability to work with a geographically diverse and international teams spanning US, China and Europe
- Strong business processes knowledge
- Excellent analytics skills
- Good service orientation and customer service skills
- Be a dedicated team player
- Ability to manage team of junior technical resources
- Flexibility for international travel
6
SAP BI Architect Resume Examples & Samples
- Reviewing business requirements and then ensuring that the deliverables produced by the development effort conform to the business requirements
- Reviewing key development and design deliverables, including interface specifications, integration requirements, data schemas, and design documentation, as well as the business’s implementation and conversion strategies and plans
- Responsible for producing SAP BI solutions design (functional specifications) for internal customers, in alignment with the overall SAP BI Vision & Strategy
- Contributing to the project planning and administration - assists in developing the project charter documentation, including helping with the high-level plan, the feasibility analysis, and in developing the business case
- Participate in the integration testing and user acceptance testing process, including preparation of acceptance criteria, review of the test plans and scenarios, review of test results as well as taking responsibility for end to end testing
- Ensure compliance with all appropriate Bell IT standards (eg. Security, Architecture, Project Delivery, SOX, etc.)
- Remain current with SAP BI Standards and BI KPI's (Business Alignment, Scalability, Adaptability, Performance, Ease of use, Product Quality)
- Remain current with SAP BI Strategy and Roadmap - ensuring that it is current with business needs and strategic roadmap, technology and evolving trends and aligned with Bell IT imperatives and enterprise architecture directives
- Support the delivery teams on any questions or issues related to the solutions architecture
- Ensure that BI process flows are documented and remain current with upgrades, project deliverables
- Support information architecture - Support current and future needs in data design and content
- Participate in the resolution of semantic discrepancies in data definitions that arise among multiple sources and projects
- Explore new opportunities to reduce costs/improve business and IT targets such as in storage, server usage, reduce complexity and risk, improve quality and reliability
- 5-7 years in a SAP BI Architecture role with leadership experience defining SAP BW solutions
- Experience dealing with multiple stakeholders in the creation of end to end solutions
- Strong knowledge of Business Intelligence concepts and practices, Data warehouse design, and Agile BI concepts
- Strong analytical skills and strong business user focus
- Computer proficiency with Windows and Microsoft Office tools (Word, Excel, Powerpoint, Visio)
- Knowledge of project delivery methodology and best practices
- Bilingual: English and French
- Knowledge and experience with SAP BI Reporting & Analytics, SAP HANA, SAP ECC 6 functionality and its implementation
- Familiarity with telecommunications industry would be an asset
- Post secondary degree with a business or IT focus, or equivalent
7
Data & BI Architect Resume Examples & Samples
- Proven years of experience within a Business Intelligence IT role
- Proven years of experience within a Data Architecture / Database Administrator role
- In-depth knowledge of Oracle Database technologies
- Experience of Big Data tools, Pivotal technologies and/or GE Predix
- Proven analytical and process oriented skills with a clear sense of urgency and initiative
- Knowledge of Data Warehousing technologies and principles and experience using Business Objects, OBIEE, SAS or other BI Tools
- Intense attention to details, while maintaining an accurate, results-oriented mentality
- Proven ability to leverage support within a Matrix environment
- Degree in Business Studies, Information Technology, Management Systems or similar
- Analytical field by experience
- Recognised Architecture Qualifications e.g. TOGAF
- Previous experience of working with people from different countries, cultures and time zones
8
Cognos BI Architect Resume Examples & Samples
- Create, enhance and maintain Framework Manager models to support business requirements
- Create logical and physical data models using best practices and compliance with BI data models (Snowflake, Star Schema)
- Architect Cognos multi-dimensional cube solutions
- Review modifications to existing framework models and data models to improve efficiency and performance
- Responsible for performance tuning and optimization of the systems
- Design and implement security architecture which will include both row level security and object security
- Develop Complex Reports (List, Crosstab, Drill through, Master-Detail, Charts, Maps, multi-query multi-prompt reports, burst reports) and Dashboards and Active Reports using Report studio
- Help drive the development of standards and best practices, and mentor team members
- 7+ years of Cognos experience with
- 5+ years of experience with relational and multi-dimensional (OLAP) data modeling. Experience with Dimensional Data Modeling and creating Star Schema/Snowflake Schema
- Experience in creating complex Stored Procedures, Tables, Views, Materialized Query tables, Indexes and SQL
- Familiarity with ETL tools like Informatica
- Strong presentation and collaboration skills, including the creation of formal documentation
- Ability to manage numerous priorities/projects and mentor other team members
- Cognos certification a plus
- Understanding of Data Warehouse, Star Schema, and OLAP is a plus
- Knowledge of financial services industry is added advantage
9
Report & BI Architect Resume Examples & Samples
- Collaborate with product manager, business partners and application platform teams to develop efficient and scalable reporting and BI solutions
- Build deep understanding of data and business (Revenue & Pricing) domain knowledge
- Design and Develop BI Architecture, Conceptual Approach, Data Model, Integration with other Application platforms, etc
- Responsible for the design, development, testing, implementation and support of mission-critical enterprise Business Intelligence (BI) reports that utilize the underlying data stores/data warehouse/data marts/OLAP cube
- Must demonstrate proficiency in administrating and maintaining the MicroStrategy components
- Eliminate any potential Revenue loss and inaccurate billing by developing deep insight on data and detecting issues before it gets to billing. Use a combination of Data Quality, Advanced Statistical Techniques and Machine Learning to detect potential Revenue leakage and perform root cause analysis
- 5 or more years of hands-on experience in Business Intelligence Industrydeveloping BI Architecture, Datatbase Schemas, integrating BI tools to Application platform
- Excellent analytic and programming skills in languages such as; Excel, SQL, VBA, R, Python/Java
- Demonstrates abilities in analytical thinking leading to the formulation of independent decisions and recommendations
10
BI Architect Resume Examples & Samples
- Excellent communication skills and a diplomatic nature
- Proven experience in the successful delivery and ongoing maintenance of complex, high volume, high performing and high quality software systems
- Working knowledge of big data implementation and associated issues
- Experience of implementing/supporting cloud-based solutions
- Ideally previous experience within the retail industry, eCommerce
- T-SQL, and the effective use of constraints and Indexes
- Expert SSIS Developer; Lookups, Loops, Cache, Events, and Parameterization
- SQL Server 2012 or 2014 Enterprise Edition, including SSAS
- Database & Table Partitioning and Data Compression
- Data Warehousing techniques, methodologies, and data modeling tools
- SQL Server Security
- SQL Server Transactional Replication
- Azure technologies in particular SQL DB and SQL Data Warehouse
- ORM & the exchange between an object-oriented language and a relational database
- Experience of working in virtualized environments
- Source Control particularly TFS
- Experience of optimizing SSAS for large data volumes and incremental, trickle-in updates
11
Senior BI Architect Resume Examples & Samples
- Data and BI reporting systems, models, and architectures
- Enterprise-class technical solutions and processes
- Extract Transform Load (ETL) and reference data management tools and process
- Understanding of Data modeling, design and databases
- 3-5 years’ experience in similar positions, preferable in the financial services sector, with knowledge in the following areas
- Hands on expertise in MicroStrategy strongly preferred
- Must Have: Experience with major RDBMS technologies like Oracle, Sybase, DB2, etc
- Nice to Have: ETL & Data Warehousing technologies including Ab Initio, Talend, etc
- Nice to Have: SOA, ESB, J2EE technologies, Web Services (SOAP, WSDL, UDDI, JAX-RPC, WS-Security, WS-Policy), Axis, AquaLogic, WebLogic, WebSphere, Tibco EMS and BusinessWorks
- Strong understanding of system analysis and modeling techniques. Knowledge of structured design techniques using tools like UML is preferred
- Strong understand of security and its applicability to the financial services sector
- Involved in successful implementation of SOA solutions
- Ability to work with globally located teams in various time zones
12
BI Architect Resume Examples & Samples
- Conducts research and makes recommendations on BI products, services, and standards
- Works with users to gather business requirements for reports, dashboards and scorecards
- Organizes and leads IT projects in the implementation/use of new BI software tools/systems
- Designs/codes/tests/documents all new or modified BI systems, applications, and programs
- Creates ETL processes to make data available for reporting and analytics
- Develops and Integrates Business Intelligence Reports, Dashboards and Scorecards
- Manages the Operational Data Store to ensure data integrity and optimum performance
- Participates and leads research and development efforts (proofs of concept, prototypes)
- Applies architectural/engineering concepts to design a solution that meets requirements
- Manages and performs data cleansing, de-duplication and harmonization of data
- Troubleshoots BI tools, systems, and software; performance tunes these applications
- Architects security models for appropriate data access and implements data security design
- Five or more years of experience with OLTP and OLAP database models
- Strong problem solving, time management and organizational skills
- Strong ability to analyze requirements/build BI applications according to specifications
- Strong understanding of data warehouse structures, theories, principles, and practices
- Experience with data warehousing frameworks and design patterns
- Fluent in relational database concepts and flat file processing concepts
- Knowledgeable in software development lifecycles/methodologies i.e. agile
- Strong understanding of the organization’s goals and objectives
- Working knowledge of applicable data privacy practices and laws
- Experience with SQL server queries, query analyzer, T-SQL, Integration Services, and Reporting Services. Included in the availabilities to write queries and stored procedures in SQL
- Strong analytical skills, excellent oral and written communication skills, be self-motivated, and be able to work in stressful situations with changing priorities
- Experience with Technologies such as: SQL Server, MongoDB or other NoSQL data stores, SSRS, SSAS, SSIS, SAP Business Objects a plus
- Experience with Qlikview, Tableau, Spotfire or other BI visualization tools is a plus
- Working knowledge of the Banking and Financial industry a plus
13
Senior BI Architect Resume Examples & Samples
- Build a strong team of BI architects, developers, analysts and PMs
- Create and manage a robust, sustainable cloud first big data architecture that supports requirements and provides for expansion
- Oversee the design of the data and technical architecture of the operational data store, data lake, data mart, pipelines and other assorted reporting/distribution services
- 10+ years of experience building and operationalizing complex, large scale, highly available, big data data warehouses, including 7+ years of leadership experience
- Proven track record of shipping highly-scalable and reliable systems through multiple cycles
- Strong experience in Big Data, large scale computing systems like COSMOS, Hadoop, MapReduce and other big data technologies
- Strong skills and experience in SQL, R, Python, SAS, AzureML or similar languages
- Strong skills and experience in Microsoft BI stack
- Great design and architecture skills with a strong bias for BI and deep expertise in big data technologies
- Leading with engineering & information architecture partners on design & architecture
- Excellent written and oral communication skills, particularly the ability to synthesize complex issues/scenarios into easy-to-understand concepts
- An attention to detail with self-discipline and a drive for results
- Demonstrated ability to work in ambiguous situations and across organizational boundaries
14
Lead BI Architect Resume Examples & Samples
- Bachelor’s degree from an accredited university or college in Computer Science or Information Systems
- 7 + years’ experience of design & development of data centric applications leveraging data from enterprise data warehouses
- 7+ years’ Information Technology experience
- Expertise with BI / BA visualization and/or reporting tools. (Expert level knowledge of Modern BI Platforms specially Business Objects and Tableau
- Ability to lead and coach a team of IT developers through the SDLC process assuming responsibility for the quality of the deliverables
- Expertise on Data architecture for ODS, Data Marts, Data Warehouse and others
- Expertise on designing ETL for performance
- Expertise on Informatica and PL/SQL
- Ability to guide and direct technical team members through the SDLC
- Ability to support business analysts and project managers on project scope and requirements definition
- Great communication skills so to be able to support our business analysts through project definition and project execution
15
BI Architect Resume Examples & Samples
- Design, model, document, and guide the logical and conceptual relationship of data and database changes for complex applications
- Ensure efficient and uninterrupted operations while developing innovative solutions to complex technical and procedure problems
- Analyze needs and requirements of existing and proposed systems and develop technical, structural and organizational specifications
- May create standards and/or do modeling to monitor and enhance capacity and performance
- Develop technical solutions which require the regular use of ingenuity and creativity to solve complex problems
- Represent the organization as the prime technical contact on projects. May interact with senior external contacts on significant technical matters
- Stay abreast of new technology to ensure future applications are met
- Maintain the strict confidentiality of sensitive information
- Responsible for observing all laws, regulations and other applicable obligations wherever and whenever business is conducted on behalf of the Company
- Expected to work in a safe manner in accordance with established operating procedures and practices
- LI-GA
- Typically requires a Bachelors degree in Information Technology or related field and five or more years progressive experience in programming and development. Equivalent professional experience may be substituted in lieu of education
- Must possess one to three years of experience in designing, developing, configuring, and implementing primarily SAP BI (Business Objects) reporting solutions using SAP BW and/or non-SAP data sources. Equivalent professional experience may be substituted in lieu of education
- Strong experience preferred in SAP BI (Business Objects) 4.1+ using the full suite of BI tools; WEBI, Analysis for Office/OLAP, Lumira and Design Studio. Additional experience in BO Server configurations with Web tier development will be beneficial to the role
- Experience preferred in developing BW BEx queries and BO universes using BICS connections as well as knowledgeable in SAP BW architecture and Data Workbench
- Ability to build highly intuitive and captive reporting solutions and dashboard metrics
- Strong experience required in ECC modules of PP/MM/WM, FI/CO, QM, PS with understanding and familiarity of business process within these key areas
- Demonstrated experience as a key contributor to multiple end-to-end SAP BI implementation projects
- Experience working in an Aerospace & Defense / Manufacturing environment would be preferred
- Must have excellent organization skills including planning and coordinating work assignments to meet project milestones or completion dates
- Must be customer focused and possess: (a) the ability to identify and analyze issues and develop solutions to a variety of moderately complex problems; (b) strong analytical, verbal and written communication skills to accurately document, report, and present findings; (c) strong interpersonal skill to interface with all levels of employees, management and external contacts
- Ability to work independently or in a team environment is essential
16
Microsoft BI Architect Resume Examples & Samples
- Collaborate with business users and analyze user requirements
- Conduct and lead white-boarding sessions, workshops, design sessions, and project meetings as needed, playing a key role in client relations
- Lead analysis, architecture, design and development of data warehouse and business intelligence solutions
- Work independently or as part of a team to design and develop analytics/reporting solutions using SSRS, SSAS, PerformancePoint, PowerView and Excel/Excel Services
- Assist business development team with pre-sales activities and RFPs
- Assist in the estimating and planning of projects
- Collaborate in the creation/enhancement of data platform solutions (Data Marts, Cubes) to facilitate decision making
- Collaborate with client DW/BI/Reporting team to standardize reporting and analytics implementation(s) across a variety of business teams/users/constituents
- Design and develop Integration (ETL, ELT, Data Governance, MDM) processes using MS SQL Server 2012 SSIS, DQS, MDM or other related tools/technologies
- 5-20+ years of experience, specializing in BI solution architecture, design, and development
- Technical Specialization in: SQL Server Analysis Services, SQL Server Reporting Services, SQL Server Integration Services, SQL Server MDM, DQS and other related technologies, SharePoint and SharePoint integration with PerformancePoint Services, PowerView and Reporting Services, PowerPivot
- Familiarity with database centric applications, elegantly engineered data warehouse solutions
- Data Warehousing and Data Modeling, specifically building / understanding star schema based data marts
- Architecture: How to define non-functional requirements and ensure they are achieved
- Demonstrated passion for analytics/BI and the ability to communicate its value as a strategic business advantage
- Strong aptitude for learning new technologies and analytics techniques
- Microsoft BI (Business Intelligence) certification a plus
- Experience with programming languages such as Java or Python
17
BI Architect Resume Examples & Samples
- Create high-level comprehensive Information Management solution designs that address the needs of key stakeholders from the business, solution delivery and operations areas
- Complete understanding and experience in various layers and architecture options for EDW, ODS, Data Marts, Big data, ETL etc
- Work with peers to conduct Solution Architecture Reviews for a broad set of projects
- Review and provide input into key aspects of the business case and work effort for a specific project
- Review and provide input into functional & non-functional requirements
- Provide consulting and conduct reviews through the development lifecycle
- Deep understanding of the architecture discipline, processes, concepts and best practices
- Strong architecture design and modeling capabilities Common Competencies
- Provide best practices in ETL Architecture, Data Architecture, BI Architecture, Information Governance, Data Quality and Master Data Management
- Design and support the strategic direction for the data warehouse environment
- Lead the data warehouse towards an Enterprise Data Model
18
Lead Solution Designer BI Architect for Manufacturing Resume Examples & Samples
- Understands the business problems and identifies relevant Data warehouse, ETL, Big data, Business Intelligence and Analytics components, technologies or architecture required for the solution
- Ensure the consistent design of business intelligence solutions and leads coordination of all solution design activities across projects and changes
- Leads alignment for the solution design, liaising between Enterprise architects, Project managers, Technical architects, Business analysts, Information Architects and developers
- Ensure solutions to meet the business needs and associated architecture and build are managed in accordance with Novartis information governance, security and technology standards
- Governs all solutions, projects and overall design for all Data, Business Intelligence and Advanced Analytics solutions for TechOps & QA functions (Supply chain, Quality, Manufacturing sites and External supply operations)
- Work closely with various TechOps & QA IT functional leads, SMEs and product managers to understand various business initiatives, direction, alignment of strategy to scope of project and drive BI requirements / solution design early on in the associated projects
- Works closely with the Technology Architecture teams to align solution designs with the proposed enterprise, technology and security architecture
- Lead the solution design of all solutions across TechOps & QA Data, BI and Analytics projects, closely liaising with business analysts, product and project managers
- Ensure compliance of all designed solutions to all relevant internal/external regulatory requirements (e.g. GxP, Novartis Information and Security framework)
- Support and/or lead scoping, fit-gap workshops for projects, propose solutions for key gaps and provide high level effort estimation for CAR preparation
- Proactively builds and shares knowledge of technology trends, their applicability to TechOps & QA solutions, associated risks and benefits resulting in competitive advantage and improved solution efficiency / effectiveness
- Actively leads, develops and/or supports the creation of technical design documents (FS/DS) incl. sizing estimates and reusability for designed solutions
- Defining architectural roadmap for reporting and analytics in strong alignment with enterprise, technology and security architects, managing technology relationships various stakeholders across geographies
- Leads project team members for all solution design related activities and establishes best practice and standards in solution design to be followed across projects
- Conduct technology PoCs, suggests new technology standards and tool recommendations to the Analytics CoE teams
- Evangelize the need and recommend strategies to position advanced analytics in areas such as Predictive/Prescriptive Analytics
- Must have a Computer Science, Engineering, Information Management Systems University Degree or adequate equivalent
- A Master Degree Education will be Desirable
- Must have at least 8 years of experience in solution design and architecture for integration, data ware housing, business intelligence and analytics systems preferably coming from Pharma companies
- Has excellent knowledge of Logistics (Supply Chain) and Manufacturing processes and associated systems (e.g. SAP ERP, MES, Historians, Lab & testing systems, Automation systems (SCADA))
- As exposure and working knowledge of various SAP ERP systems/modules (e.g. SAP ECC PM, SD, MM, QM, APO)
- Has solid experience working and hands on knowledge of different Integration, Data Warehousing, Business Intelligence and big data analytics tools and technologies (e.g. SAP Business Warehouse, QlikView, Tableau, Spotfire, Hadoop, Oracle, SAP HANA at least two of them)
- Has worked in or closely with business functions / leads, preferably in the areas of manufacturing and product quality operations
- Has implemented agile solutions using data warehousing and business intelligence tools/techniques (OLAP, OLTP, ETL, Business intelligence, Web portals etc.)
- Has relevant exposure to various manufacturing processes and systems
- Has relevant exposure to and is aware of developments in the areas of big data technologies and advanced analytics techniques
- Project management experience is a plus
- Must have experience working with IT projects, security, audit and service management procedures
- Experience in managing external consultants in different locations and time zones
- Excellent communication, coaching and relationship building skills
- Strong learning, logic building, analytical and problem solving abilities combined with sense of curiosity
- Collaborative attitude and experience of working in a multi-cultural and matrix setup
- TOGAF Certification
- ITIL or PMP Certification Desirable
- Advanced English skills (written, reading and speaking)
19
Oracle BI Architect Resume Examples & Samples
- Lead the definition of Bill-to-Cash Business Intelligence IT Vision and Strategy
- Define and manage the organization's information architecture
- Develop and maintain operating models, standards, best practices, guidelines and compliance to the architecture, roadmap and governance
- Mentor/coach teams to ensure applications and data warehouse are designed to be scalable and support the business needs with data reliability and integrity
- Engage as a strategic liaison to the business community and IT teams for all BI and financial reporting project deliverables
- Provide thought leadership and subject matter expertise on data warehouse concepts, industry trends and best practices
- Assist in gathering requirements from business stake holders, consult with business and IT teams to define necessary system capabilities
- Collaborate with governance and administration teams to establish governance around Business Intelligence / Data Warehouse
- Communicate regularly with Finance and the supporting IT organizations at all levels
- Bachelors or Master’s Degree in Computer Science/Information Systems or equivalent experience
- Strong hands-on lead experience for BI, Data Warehouse design and development
- Full life-cycle Oracle BI Enterprise Edition implementation experience, including ODI, Essbase, RPD
- Experience customizing the ODI ETL processes
- Experience in repository (RPD) development (Physical, Logical and Presentation layer)
- Experience in configuring security (Authentication and Authorization - Object level and Data level security)
- Demonstrated knowledge of industry trends and standards
- Established front line business relationships and an understanding of Finance operations
- Experience leading large technical enterprise scale projects and managing competing priorities
- Strong interpersonal, leadership and managerial skills
- Ability to provide effective communication at all levels of the organization and across business teams
- Ability to articulate a business intelligence vision, the strategic value and measurable benefits
- Proven execution with large scale, high performance business intelligence/warehouse platforms
- Architecture and development/technical skills in the multiple technology stacks
20
BI Architect Resume Examples & Samples
- Define, Design and Implement a scalable BI and DW Self-Service framework
- Define and Manage Business Intelligence Data Presentation and data visualization architecture
- Work closely with EDW Manager to understand data preparation and visualization requirements and translate business needs into deliverables
- Definition and development of global self- Service architecture through research and implementation of innovative approaches to increase efficiency of Development and Operations while removing duplication of effort
- Maintain an understanding of how current work in BI Architecture relates to overall CHI strategic initiatives
- Develop, maintain, and publish BI data access architecture
- Collaborate with data architects and data modeler to create highly efficient self-service scalable subject area data marts
- Evaluate and recommend tools for data presentation and self-service
- Develop specifications and standards for semantic layers i.e. Qlik Data Layer, Universes, SSAS Cubes and multidimensional models across all data environments
- Identify opportunities for new architectural initiatives; make recommendations on increasing scalability and robustness of data access platforms and solutions, including performance of data access
- Develop best practices and standards for data access and perform reviews with product management teams to ensure they are being used
- Work with EDW Manager and Security Architect to implement security architecture within the data access/Presentation area
- Appropriately escalates and pro-actively communicates with BI leaders to confirm priorities, approach, issues found, and options for solutions
- Keeps current with available technology to support BI solutions
- Mentor Developers and Data Modelers with issues and techniques
- Timely completion of architectural design and reviews with department
- Follow agile development process and use tracking tools as required
- Bachelor degree in computer science or related technical field required
- 6-8 years experience in a highly critical Operational Data Warehouse environment working to develop and apply effective solutions for major Data Warehouse applications required
- Experience with multiple data access techniques from data warehouse like reports, dashboards, self-service etc. is required
- Experience with Qlik View/Qlik sense /Microsoft BI Stack (Power BI, SSRS) etc.) is required
- Experience with SSAS is a plus
- Experience with data access and analytics tools such as SAP Business Objects, SAS is a plus
- Experience with RDBMS SQL preferably Microsoft SQL Server 2012 and above
- Experience in the use of massively parallel processing appliances such as Microsoft Parallel Data Warehouse
- Experienced with Multidimensional design and database structures
- Experience with mentoring less experienced members of staff to provide growth and development
- Experience with enterprise architecture relating to data warehousing
- Knowledge of leading practices within complex data warehouse environments required
21
Enterprise BI Architect Resume Examples & Samples
- Minimum 10 years’ experience in data warehousing industry
- Minimum 5 to 7 years’ experience and demonstrated expertise in managing architecture and ETL development and business critical support operations
- Experience in data warehouse and data integration architecture design and implementation
- Strong SQLServer skills
- Developer / admin “big data” skills in Hadoop, Spark SQL, and Hive
- Experience with a major BI tool vendor
- Experience with cloud-based architecture, AWS
- Experience with SAP technologies such as HANA, Business Objects a plus
- Proven leadership, organizational, interpersonal, analytical and problem solving skills
- Proven facilitation, relationship building and negotiation skills
- Strong team building, partnership and collaboration, and resource management skills
- Demonstrated ability to prioritize/communicate conflicting demands in a fast-paced environment
- A Bachelor’s degree in Information Systems or Computer Science, or equivalent work experience
22
BI Architect With Tableau Resume Examples & Samples
- Key Responsibilities include but are not limited to
- Developing business focused technical solutions leveraging Business Intelligence (BI) Reporting/Visualization using one of the technologies like Tableau, QlikView, Cognos and Hyperion Essbase
- Defining test conditions and test scripts to ensure system stability and validity
- Supporting user training; documentation; and rollout
- Must have at least 7+ years’ experience with data modeling/data architecture for business intelligence and reporting
- Must have high-level of experience with ETL methodologies
23
Senior BI Architect / Microstrategy Resume Examples & Samples
- Design the data model for data mart and redesign the Microstrategy cubes and some of the reports
- Write design specifications and coordinate with offshore for entire delivery of code, design, testing
- Work with client BA/PM for entire life cycle of the project
24
Senior Microstrategy BI Architect Resume Examples & Samples
- Deep experience using MicroStrategy for large-scale programs
- Minimum 8-10 years of IT experience
- Must have: BI & Analytics technologies and tools (SAP-BO, QlikView, Cognos, MicroStrategy, etc.)
- Must Have: Hands on expertise in MicroStrategy
- Knowledge of all tiers/components of a technical architecture
- Comfortable presenting technical solutions to large audiences
- Ability to work independently and take ownership of various parts of a project or initiative
- Ability to run quick proof of concept and make recommendations
25
Senior BI Architect Resume Examples & Samples
- Direct functional and technical consulting delivery
- Responsible for oversight of multiple concurrent functional and technical implementation projects
- Provides sales support and enablement
- Ensure group leadership and resource mentoring
- Ensures management and provides administrative support
- Outstanding client-interfacing skills
- Must possess the ability to interact effectively with all levels of internal and external clients
- Excellent communication skills – both oral and written
- Self-motivated, responsible, efficient and organized
- Able to position, present and evangelize the value proposition for Business Intelligence and Data Warehousing solutions in general, and for Oracle BI/DW/ETL, OBIA, and BI Cloud Service solutions in particular
- Professional and cordial demeanor
- Ability to shepherd clients toward success
- Able to lead teams of consultants engaged in client projects
- Must be able to mentor junior resources
- Must be able to work seamlessly with remote team including those based in India and UK
- Able to work independently, with a high level of performance, with minimal direct supervision
- Able to gather, interpret, clarify and refine business requirements – and provide solid recommendations for cost-efficient, value-add enhancements
- Able to estimate work effort accurately, and then meet all delivery commitments
- Able to foster true collaboration with client and other resources to ensure output reports meet the defined business needs, and exceed client expectations
- Minimum 5 years direct (hands on) experience developing data warehouse and reporting solutions with Oracle BI technologies (OWB, ODI, OBIA, OBIEE, BICS, PeopleSoft EPM, etc)
- Experience managing a team
- Prior work with offshore/cross-culture teams a plus
- 2 years’ direct experience implementing OBIEE/OBIA
- Experience implementing for Higher Education a definite plus
- 2 years’ direct experience architecting, designing, configuring and implementing Oracle BI reporting environments
- 2 years’ direct experience leading or managing teams involved in technical implementations and/or data warehouse development projects employing the Oracle BI toolset
- Able to design, develop, configure and optimize complex ETL packages and process flows
- Able to design, develop, configure and optimize OBIEE reports and dashboards using the most current versions
- Able to understand and articulate what the client really needs (even when they cannot)
- Able to understand the larger context (the big picture) in which their efforts are a part
- Able to make tactical technical decisions that are aligned with the established technical strategy and framework
- Experienced in developing large Oracle-based data warehousing environments
- Possesses a working understanding of logical and physical database design
- Possesses direct experience with dimensional data modeling
- Experienced in writing functional and technical specifications
- Oracle DBA and BI certifications are a plus
- Experience with Higher Education concepts and clients is a plus
- Experience with other RDBMS platforms, ETL tools and/or BI reporting applications is a plus
- Consulting experience with a track record of successful implementations is mandatory
- Team Lead or Project Management experience is mandatory
- PM Certification a plus
26
BI Architect Resume Examples & Samples
- Leads all aspects of the delivery of BI solutions and related components
- Understand business challenges perfectly
- Validate requirements / solutions
- Provide solution performance analysis and tuning
- Technical leader of the platforms SAP BI 4+ and Talend 6+
- Support advanced users on the BI platform, perform code review of their production
- Works across several business technology teams to ensure alignment between business requirements and systems architectures
- Manage change control according to the development policy
- Able to Troubleshoot complex issues, identifies root causes, resolves bugs and errors
- 2-4 Years in designing, developing and implementing complex Business objects solutions
- 2-4 Years in designing Talend flows / or other ETL solution
- 3 years in Business objects SAP BI 4+, full lifecycle implementations
- Business knowledge of processes of Software industry and CRM an asset
- Able to work well in a team environment as well as independently
27
BI Architect Resume Examples & Samples
- 7+ years of Microsoft BI technologies knowledge such as SQL Server SSRS, SSIS, SSAS
- Understanding of Microsoft .NET
- Organizes data at the macro level (i.e. which subject areas are managed in which goldensources)
- Effectively promote process best practices
- Excellent client interaction skills
- Communication skills: strong presentation/ communication / facilitation skills (oral and written)
- Works well with teams or in a team environment, with the ability to work independently
28
BI Architect Resume Examples & Samples
- Demand Fulfilment Process (DeFuP)
- BI Service Operation Process (BISOP)
- Service Support Process (SeSuP)
- Alignment of solution design decisions with lead information architect and – if required – with IT
- Architectural Design, concepts and strategies for future development of the VF BI application landscape
- Data Warehouse-Concepts
- ETL-Design- and Development
- Data Modelling in BI context
- SQL, especially Teradata and Exadata
29
BI Architect Resume Examples & Samples
- Build SAP HANA data models using Attribute Views, Analytic Views, and Calculation Views, programming including SQL, SQL Script/Procedures and Analytic Privileges & SAP HANA Data Provisioning using SAP LT Replication Server (SLT)
- Write ABAP programs, Function Modules, Include programs etc
- Experience with SAP functional applications areas of SD, MM, PP, FICO, HR
- Master's or higher level degree required
- Strong communication skills and team player
30
SAP BW BI Architect Resume Examples & Samples
- To ensure that the SAP BW system delivers benefit to business users
- Provide design and thought leadership to ensure that changes and enhancements to the BW system are made in an effective and sustainable manner
- Ensure that the opportunities presented through the future upgrade to BW on HANA are realised
- To assess all changes to the SAP MI Template for suitability and fit to process. This role is the facilitator of all MI creation through BW
- Co-ordinate implementation activities with off-shore implementation teams
- To ensure all changes to the MI Template are approved by the MIDA and relevant Process DA
- Quality assurance of the overall BI solution, through supporting the delivery process. This includes having a high level understanding of the request, driving the request through the CR process
- Deliver changes through the quarterly release process. Bridge understanding between development team and business user requirements
- Create technical specifications for changes to BW objects, to be implemented by off-shore teams
- Lead BW testing and integration activities (data objects and reports) as SAP is deployed into new countries
- Contribute towards advancing analytical, self-service/ad hoc reporting capabilities across the Lubricants business using existing or future toolsets
- Work with the business to find opportunities to standardise the MI Template
- To be an advocate for the adherence to the SAP Template across all process areas in support of the wider process team
- Run ad hoc training courses in the BW toolset and data for new starters and colleagues who change roles
- Design and ownership of the data security and data privacy model within the BW environment
- 5+ years of SAP BW experience (knowledge of BW objects and how they are used such as Info
- Deep business knowledge of Lubricants Management Information
- Experience of SAP systems implementation
- Process Improvement experience (CI methodology)
- Experience in use of Business Objects 4.x against BW sources
- SAP Design Studio
- Change Management, particularly around enabling cultural change
31
Consultant BI Architect Resume Examples & Samples
- Role involves Client Interaction
- Handle performance tuning in a large scale
- Write MDX queries, SQL 2008, R2, SSRS, SSIS, SSAS, TSQL & DWH
- Primary skill: SSIS, SSRS, SSAS, TSQL & Data warehousing
- Secondary skill: Cloud knowledge
- Should be aware of Waterfall methodology & SDLC process
- Experience in BI as Technical Architect
- Knowledge of BI Data Warehouse Concepts
- Cloud Knowledge & Data Analytics experience
- Should have worked in Service Projects
- Member should have good Communication & Negotiation Skills
32
Lead BI Architect Resume Examples & Samples
- Design relational and dimensional enterprise BI data models
- Design the data integration from source to interactive reports and data visualizations
- Develop and implement the BI architecture which includes data warehousing, OLAP, ETL, ODS, data integration, report data sets
- Work with product owner and business users to understand and translate user stories/requirements into data structures, models and reports
- Find answers to business questions through hands-on exploration of data sets via SQL for dashboards, statistical analysis and data visualizations
- Maintain and enhance the enterprise BI data architecture to increase the robustness, performance, and scalability of systems
- Review and explore source data as it relates to business concepts as well as how it relates to other data elements
- Map data from original source to the BI database layer to the presentation database layer and communicate and document that to guide the BI Developer
- Manage the reporting and analytics platform(s) to ensure that scheduled jobs are successfully run and analytics data aligns to timeliness and completeness of requirements
- Work with database administrators to ensure that databases feeding the reporting platforms are tuned for optimal performance
- Stay current with latest BI industry trends and software versions
- Work on special assignments as they arise
- Solid understanding of large ERP systems (e.g. Oracle EBS or SAP)
- Excellent verbal/written communication skills and strong analytical/problem solving skills
- Excellent collaboration skills and able to work in a team environment
- Minimum 3 years of experience in an IT BI reporting environment, preferably as a BI Architect
- Minimum 5 years of experience working with the following BI software and technologies: MS SQL/Oracle 11g, Data warehousing, OLAP - MS Analysis Services/Essbase, MS Reporting Services, OBIEE/OBIA, Sharepoint 2010, BI Publisher, Oracle Discoverer, ETL tools - Informatica, SSIS, ODI
- Experience working for a mid-sized to large organization; manufacturing experience preferred
- Must be 18 years of age and must pass pre-employment drug screen and background check
33
Senior BI Architect Resume Examples & Samples
- Conduct requirement gathering, fit gap analysis, configuration, development, testing and delivery
- Customize and integrate OBIA Components (Informatica ETL, DAC, OBIEE) with Peoplesoft
- Develop reports and dashboards using OBIEE tool suite
- Performance tuning of reports and involve in BI changes and implementation
- Involve in resolving customer issues, troubleshoot and provide fix
- Create Users, Groups, and Initialization Blocks in Oracle Admin Tool to set up Security using LDAP
- Create formatted reports using BI Publisher
- Sr. BI Architect, Bachelor's degree in Computer Science, Engineering or related & 5 years' experience
- Experience in Java Script, HTML, XML, Linux, Tableau, SQL Server
- Work in tools like Oracle Multi-Dimensional OLAP Cube using AWM, BI Suite and Fusion Middleware with Weblogic, Siebel Analytics, Siebel CRM Application and Informatica (ETL tool)
- Java Script, HTML, XML, Linux, Tableau, OBIEE, Informatica ETL, Weblogic, SQL Server
34
Enterprise BI Architect Resume Examples & Samples
- Determines scope and participates in the design and delivery of advanced, scalable BI and Analytics solutions in partnership with ETL developers, business stakeholders and other technical data warehouse team members and database administrators
- Enhances database schemas, procedures, functions, ETL, data loads and extracts that migrate disparate data including spreadsheets and external data sources into a unified and structured environment
- Manages data and analytic frameworks to provide timely, accurate and insightful information for the global STERIS organization
- Conducts design reviews and provides recommendations for critical solutions or solutions that use new technologies to meet evolving business requirements
- Locates and defines new process improvement opportunities using data and analytics capabilities
- Analyzes, designs and builds dashboards/reports and assist in the creation of data organization structures as needed
- Identifies, analyzes and interprets trends or patterns using visualization and statistical methods
- Coordinates documentation and training for technical/business users working together with BIA team and consulting resources
- Works closely with cross functional IT teams to resolve issues and recommend solutions
- Bachelor's degree required in Computer Science, Information Systems or related field. 7+ years of experience required if holding Bachelor's degree only
- Master's degree preferred in Computer Science; Information Systems or related field with 5+ years of experience
- 5+ years architecting data structures such as Data Warehouse, Dimensional Modeling, ETL, Big Data platforms, Analytical databases and streaming data sources; integration of multi-format databases from internal and external sources for Business Intelligence and Analytics consumption
- Extensive experience in Report and Dashboard development, data management to solve complex business analysis needs, report development, data handling, impactful visualizations and server management
- 5+ years reporting experience involving both ad hoc, fast turnaround requests, along with standardized scheduled reporting based upon large data sets and complex queries
- 3+ years cleaning, combining, transforming and navigating data through SQL and other database and ETL platforms
- Solid written and verbal communication and organization skills. Strong documentation & training skills
- Project management and/or SCRUM/Agile experience is a plus
- Advanced knowledge of end-to-end BI tools such as RDBMS, Cloud, ETL tools, Data Warehousing, Dimensional modeling, OLAP, Statistical analysis, Dashboarding and reporting products
- Excellent collaboration skills to work with Technical team and business users to foster an open relationship of trust
- Proven attention to detail and accuracy in the context of data analysis, solution development and requirements translation
- Solid ability to coach, mentor and train team members and business users
- Outstanding written and verbal communication skills with the ability to work effectively in multifunctional global teams
- A self-managed "doer" and self-starter who works well in a fast-paced, dynamic, team environment
- A creative thinker who can take business questions and deliver impactful visualizations and dashboard solutions
- Highly responsive and adaptable to efficiently manage quick-turn around of tactical projects with an ability to work in an ambiguous environment with complex business logic and data flows
- Ability to organize and coordinate multiple tasks and communicate information in a timely fashion with the appropriate sense of urgency
- Demonstrated problem solving skills and ability to consistently exercise sound judgment and initiative, including stressful situations. Must be able to effectively manage competing priorities
- Willingness to train and self-teach to grow technical and business understanding
- Deep understanding of Finance, Sales and Marketing environments is a plus
- LI-KL1
35
IT BI Architect / Developer Resume Examples & Samples
- 30%
- 7 Years
- 5 Years
36
Senior BI Architect Resume Examples & Samples
- Provide data management expertise to our clients in evaluating requirements and developing data architecture and BI solution design. Data management includes appropriate structuring, stewardship of data, semantics/syntax of data attributes, coding structures, and mapping schemes
- Design logical Data Warehouse architecture and data model, implement physical Data Warehouse design (schema, indexes, partitions, etc.)
- Design OLAP and semantic layer based on the reporting requirements
- Design reporting architecture and provide recommendations for reporting technology
- Guide and coach developers, share best practices, perform code reviews
- The ideal candidate will have 7 + years of hands-on professional experience
- Travel requirements: up to 50 %
- 5+ years of prior consulting experience
- Very strong technical knowledge in ETL tools (SQL Server SSIS or Informatica), Databases (SQL Server 2012, Oracle), OLAP tools (Microsoft SSAS), Reporting tools (Microsoft SSRS, Cognos), ability to work alone or in conjunction with a DBA
- Microsoft BI certification is strong plus
- A natural sense of urgency, initiative and a positive team player philosophy to be reflected in daily work ethics
37
Senior BI Architect Resume Examples & Samples
- Define, develop and maintain Sun’s Enterprise Business Intelligence architecture, including standards and protocols for design, environments, implementation, ETL, reporting and analytics, and integrations
- Work with end-users and IT team members to define data reporting and analysis needs
- Design, develop, implement and maintain data stores (data warehouses, data marts and related information repositories) to support organizational reporting, analytics and integrations, and to meet performance and reliability objectives
- Design, implement and maintain ETL processes to acquire, validate and transform information from source systems into data stores
- Guide the efforts of other BI team members and provide training and mentoring to enable them to fully support the environments
- Establish performance and reliability metrics for all data stores, reports, dashboards and analytics tools
- Design, implement and tune relational queries for optimal performance and reliability
- Design, implement, deploy and maintain reports, dashboards and analytics tools
- Create and maintain supporting documentation including data dictionaries, data flows and database schemas necessary to document database environments and ensure maintainability
- Design, implement, monitor and maintain BI environments and servers to meet usage and performance demands
38
Oracle Data / Bi Architect Resume Examples & Samples
- Works with the Application Development teams to implement Data & BI strategies and build data flows
- Improves TCF’s Architecture practice and modernizes Data & BI Management capabilities
- Performs software analysis, code analysis, requirements analysis, software review, system risk analysis, software reliability analysis, capacity planning, etc
- Monitors, assesses, and understands data management capability developments and identifies opportunities for TCF architectural modernization
- 7+ years of experience with Data Architecture and Management
- 3+ years hands on architectural and leadership experience in design and deployment of data management solutions (data modeling, database design, data warehouse, middleware, enterprise services, operational data stores, MDM, data quality tools, application development, front-end data collection, identity/access management, and governance mechanisms) within a large enterprise environment
- Experience in architectural design and modeling and knowledge of data modeling and understanding of different data structures and their benefits and limitations under particular use cases. Solid understanding of data architecture across multiple platforms: ERP, custom applications and Clouds
- Knowledge of Data Governance, Data Quality, Data Lifecycle Management and Privacy Principles. Familiarity with BICS and PBCS is a plus
- Financial Services industry experience preferred
- Excellent relationship building skills; ability to interface with a variety of stakeholders
- Coach / mentor other team members as appropriate
39
Microsoft BI Architect Resume Examples & Samples
- Working with partners and team members to gather and analyze requirements and translate them into technical solutions
- Identify new relationships between data and provide more insight into business results
- Develop dimensional data models and SSAS cubes on SQL Server DB
- Develop and maintain SSIS/ETL packages
- Develop reports with SSRS
- Design, develop and maintain Data Warehouse using best practices
- Collaborate and implement best practices for the entire Microsoft Business Intelligence stack to deliver top solutions
- Bachelor degree in related field
- 5+ years of business intelligence experience
- 5+ years of experience with SSIS/SSAS/SSRS
- STRONG experience with Data Warehousing
- STRONG business acumen
- Strong communication skills, analytical skills and ability to develop rapport with team members and business partners
40
Senior BI Architect Resume Examples & Samples
- Work in collaboration with BI delivery team leaders, business analysts and business leaders to understand business requirements and end user’s needs
- Translate business requirements and end user’s needs into architecture blueprints that deliver cost effective & high performing, high quality BI solutions in compliance with Charter standards, policies and long-term technical strategies
- Design, develop, manage and update logical and physical data models ) for the BI data marts
- Work with IT partners to review the upstream data warehouse data models and assess/mitigate the impact on BI side
- Communicate database designs to business and technical audiences, including business users, program sponsors, database administrators, ETL developers and BI developers
- Work with DBAs to migrate schema changes between development, QA and production environments
- Provide architectural expertise, thought leadership, direction, and assistance across entire BI organization
- Present proposed solution blueprints to the Architecture Review Board. Communicates solution blueprints to other project team members, business users and program sponsors
- Participate in Architecture Review Board meetings. Review solutions presented by other BI architects and provide constructive feedback
- Assist Project Managers and BI delivery team leaders in estimating effort and resources for new projects and enhancement requests
- Engage with IT teams such as Data Management, DBAs, Security, Storage and Networking when their involvement is required to meet the project needs
- Participate in capacity planning for all layers in the BI technology stack
- Help solve complex production issues spanning multiple tiers in the BI/DW technology stack
- Stay current in new BI /DW technologies, evaluate them and make adoption recommendations
- Participate in developing and documenting technical standards and best practices for the BI organization
- Total 8+ years of experience in IT with 5+ years of full life cycle experience as an architect in large-scale, complex BI/DW environments, with numerous data sources, diverse BI applications, tens of terabytes of data and thousands of users
- 5+ years of hands-on experience in Erwin Data Modeler, ER/Studio or similar data modeling tools
- 3+ years of hands-on experience in ELT/SQL Development on Teradata or similar MPP database platform
- 3+ years of experience in ETL platforms such as Informatica, Ab-initio or Data Stage
- 3+ years of experience in BI reporting/OLAP platforms such as MicroStrategy(preferred), Cognos, Business Objects
- Expertise in all areas of data warehousing (architecture, data sourcing/acquisition, integration, transformation, presentation)
- Experience in logical and physical database design for data warehousing (3NF/Star Schemas) including SQL writing/tuning on MPP platforms such as Teradata and/or Netezza
- Proven ability to quickly grasp business requirements and translate them into optimized solution blueprints
- Strong problem solving, collaboration and communication skills Passion for leveraging data to improve business outcomes
- Certification on Teradata and/or MicroStrategy is a plus
- Familiarity with predictive modeling tools like SAS and/or R
- Familiarity with Big Data technologies such as Hadoop and Spark is a plus but not required
- Experience in cable or another telecommunications service provider is a plus
41
DW BI Architect Resume Examples & Samples
- Serve as senior level technical expert on large, complex projects
- Prepares complex design, development, implementation, and maintenance plans for systems
- Defines deliverables, costs and benefits and ROI
- Interact with corporate and project team members to negotiate timelines, responsibilities, and deliverables
- Develops, tests, and documents systems in accordance with programming standards and validation procedures
- Engineers software, system and/or programming solutions across projects and/or technologies to meet internal and external needs
- Performs peer review of work products such as code, designs, and test plans produced by other team members
- Provide expert review of system development work with regard to IT standards and validation procedures
- Serves on or may lead company committees and task forces to develop technical solutions for projects or client needs
- Provides long term evaluations of system, company wide
- Update corporate information sets associated with application information, such as PDRS and Application Portfolio database
- Mentor junior team members in training and developing technical expertise
- Proficiency in one or more of the following: VB.Net, C#, ASP.Net, Microsoft Visual Studio, Microsoft .Net, PeopleTools
- Java, hardware/software/infrastructure setup and testing (based on specific position)
- RDBMS system (expert in one of the following: Oracle, MS SQL Server)
- SQL, PL/SQL. and/or T-SQL
- Cognos experience preferred
- XML experience preferred
- Possess an expert knowledge in software development tools, practices, and lifecycle methodologies
- Possess a strong knowledge of the clinical drug development industry, procedures/processes, and regulatory standards
- Possess excellent organizational, communication, and technical database skills
- Must possess experience in specific technologies appropriate to the specific role specification. Experience should include hardware and software selection, testing, and specification
- Knowledge of modern BI Architecture, understanding of data lake, Hadoop preferred
- Must possess one or more industry recognized certifications appropriate to the specific role or be able to demonstrate equivalent expertise through extended experience or other methods
- Possess 2 years experience in hardware and software testing specific to the role
- Possess excellent aural, verbal, and written communications skills, to include writing/editing of technical documentation for international audiences; effective presentation skills
- Ability to serve as technical leader on a global engineering team
- Ability to establish and maintain effective working relationships with co-workers, managers and clients
- Master’s Degree in computer science or related field with a minimum 7 years relevant work experience; or equivalent combination of education, training and experience
42
FTS Lead BI Architect Resume Examples & Samples
- 7+ years of experience in data warehouse design, development and support
- Bachelor’s degree in Computer Science/Information Technology or equivalent
- Strong knowledge in BW Development
- Strong knowledge in Oracle Database development with PL/SQL; knowledge of TOAD or similar PL/SQL development tool is mandatory
- Skilled in ETL tools like SAP DataServices and IBM InfoSphere DataStage
- Thorough understanding and ability to navigate and develop Shell scripting and CRON Job execution in a SUSE Linux environment
- Understanding of change management processes in a highly regulated environment
- Knowledge with IBM InfoSphere DataStage ETL from/to Oracle, SAP, and SAP BW is a plus
- Thorough knowledge of online and/or printed SAP reference sources such as the SAP Service Marketplace and SAP Developers Network
43
Data / Bi Architect Resume Examples & Samples
- Leads Data & BI Architecture working sessions with appropriate stakeholders across the organization to create and maintain data modeling, data integration and BI capabilities. Ensures these models are kept current, are approved, are fit for purpose, and evangelized across the organization
- Leverages thorough understanding of business process and system processes to make recommendations and propose technical/non-technical solutions to meet business requirements
- Supports TCF’s Data Governance practice through development of a set of Data Architecture / Data Management standards
- Provides technical and strategic leadership in all Data & BI Architecture subject areas
- Supports project architects, enterprise architects, and solution architects across the organization for Data & BI Management and Data & BI Architecture capabilities – Provides guidance where appropriate
- Champions common data definitions and data protection and security
- Strong organizational, interpersonal and multitasking skills with ability to balance competing priorities
- Strong knowledge of Data Governance, Data Quality, Data Lifecycle Management and Privacy Principles
44
BI Architect Resume Examples & Samples
- Maintain the Enterprise data model repository using Erwin ModelMart Software
- Perform physical database design through DDL scripts, database snapshots, and table partitions
- Design, development, testing, performance tuning, roll out and ongoing enhancements of
- ETL processes (with proper utilization of multithreading, partitioning and other performance tuning techniques) by leveraging Microsoft SQL Server Integration Services (SSIS)
- Reports by leveraging Microsoft SQL Server Reporting Services (SSRS)
- Perform database tuning, instance performance monitoring, tablespace utilization, schema object management, database capacity planning, "bottlenecks" and "offensive" SQL activity monitoring and resolution
- Create appropriate technical documentation as required for the project team
- Participate/assist in production cutover and migration. Collaborate with other team members in issue diagnosis, resolution and ongoing run-the-business application support
45
Senior SAP BI Architect Developer Resume Examples & Samples
- The Senior BI Architect will partner with global Business Partners and other IT Solution Architects to understand the overall business requirements, develop designs, and implement solutions that will support business needs
- Responsible for the overall systems architecture and design, serves as domain expert in all aspects of architecting and designing of SAP BI solutions
- Lead solution development and implementation for Business Intelligence and Analytics systems and enhancements, and participate in defining technical standards and governance
- Interacts with various organizations that include but not limited to finance, purchasing, logistics, marketing, and order management
- Documents business requirements and provide technical design documentation
- Investigates new technology solutions, builds prototypes, and document requirements
- Supports SAP BPC module and related data extractions
- Helps to ensure reliability and scalability for BI and Analytics systems
- Troubleshoots ETL issues and provide resolutions
- Conforms with Quality Change Controls and promotion process
- Mentors junior staff and conduct user training
46
Data & BI Architect Resume Examples & Samples
- Defines, challenge and prioritize with client data requirements
- Design advanced conceptual, logical and physical data organizations, models, repository, dashboards, reports within a complete functional and technical architecture
- Partners with other architects, infrastructure and software experts to define metadata layers, technical strategy and optimal integration within existing client IT landscape
- Translate to technical designers or developers designed solution, review proposed solution and optimize it when required
- Participate to the definition of testing strategy
- Ensure business access to adequate, understandable, accurate data
- Accountable for End to End solution
- 2 years of professional experience in similar key responsibilities
- Advanced knowledge in data warehouse dimensional modelling possibilities (star schema, snowflake, etc...)
- Hands-on knowledge with one of the Key ETL market tools and one of the key reporting tool
- Hands-on knowledge with one of the key Database Management Systems
- Hands-on knowledge of enterprise repository tools, data modelling tools, data mapping tools, and data profiling tools
- Knowledge of latest market trends
47
BI Architect Resume Examples & Samples
- Bachelor’s in Computer Science or relevant program preferred, or 8+ years’ with the tech stack
- Solid understanding of Financial reporting preferably in Retail/Restaurant/Hospitality business domain
- Exposure to SOX and PCI practices is a plus
- Proven ability to capture business requirements, translate them to technical requirements, develop metadata/prototypes, reporting cubes, test and train end users
- Ability to lead and liaison between cross functional teams within the organization
- Self-motivated analytical thinker and able to work with minimal supervision
- Good verbal and written communication skills to interface with the team and business stakeholders
- Ability to pass a thorough background check and drug test
- Quick learner and ability to code and test quality applications in an scrum / agile environment
48
Data Analyst Lead-bi Architect Resume Examples & Samples
- Works closely with business analysts, systems users and other IT Architects to understand and define system and business requirements
- Works with business and IT technical areas to develop and provide SharePoint solutions as well as BI reports, scorecards and executive level dashboards through front-end BI distribution channels
- Performs testing and prototyping of SharePoint and BI Tool solutions
- Supports and troubleshoots SharePoint and production BI applications as required including optimizing performance, resolving production problems and providing timely follow-up on problem reports
- Educates, trains, coaches and mentors team members on SharePoint and BI solutions and data related issues
- Provides support and administration for SharePoint and other enterprise BI tools and reporting platforms
- Provides off-hours support
- Strong SharePoint solution design and development skills, web part customization as well as experience with SharePoint Designer required
- Knowledge of XML, Ajax, and CSS required
- Strong Microsoft Office skills, especially Excel
- Mastery of other Client Enterprise Business Intelligence tool e.g. MicroStrategy, Microsoft SQL Server Analysis Services, BI-Query, Teradata SQL Assistant, SAS, SPSS preferred
- Relational-database knowledge (RDBMS), including data warehousing Teradata preferred)
- Dimensional data modeling (logical and physical) knowledge helpful
- Strong team-oriented interpersonal, written and oral communication skills
49
Delivery Architect BI Architect Resume Examples & Samples
- You are responsible for the end-to-end architecture of a Delivery, including its assembly and integration into the IT architecture principles defined with the client
- Certification: Has or seeking IAF level 1
- Should be proficient in foundation, People Leadership, client acquisition & development, service & delivery and business leadership