• Senior Business Intelligence Architect

    Job ID 2018-1403
    Job Locations
    US-CA-Costa Mesa
    Regular Full-Time
  • Overview

    The Senior BI Architect is responsible for providing hands-on design and implementation expertise around data warehousing, ETL, OLAP/tabular cubes, report development and data modeling across QSC. He/she will be tasked with leading development and design procedures of data driven items; working individually, with key stakeholders and managing additional development resources that will be utilized by finance, commercial and operational teams to answer key stake holder questions and solve problems with creative solutions to provide the critical insights necessary for leadership to make informed, data driven decisions.


    • Architect the Microsoft Business Intelligence (BI) solutions utilizing MS SQL Server 2014/2012 SSAS, SSRS, PowerPivot, PowerView, PerformancePoint, integration with Excel and SharePoint, tailoring solutions for management dashboards, financial reporting and operational business intelligence.
    • Develop and manage BI presentation layer training, and documentation to ensure quality and stability.
    • Troubleshoot BI Environment problems and tune for performance. Diagnose and resolve application bottlenecks and performance issues. Define and enforce coding standards, design styles and best practices.
    • Generate standard or custom reports summarizing business, financial, or economic data for review by executives, managers, sales operations, and other stakeholders.
    • Manages additional development resources including internal as well outside contractors and consultants.
    • Completes research, design, development, testing, retrieval, and data reporting utilizing the knowledge of various software packages.
    • Advises on the resolution of complex analytics.
    • Identifies and recommends business, technology, and process improvement opportunities.
    • Establishes and serves an analytics review function to ensure the uniformity and quality of analytical tools and reports are delivered consistently to business partners.
    1. Responsible for exhibiting professional behavior with both internal and external business associates that reflects positively on the company and is consistent with the company’s policies and practices.
    2. Responsible for taking accountability to demonstrate the organization’s Cultural Beliefs and achieving desired results. Responsible for driving the Culture within the organization by using tools such as storytelling, focused feedback, and recognition. Performance is aligned with the Culture of Accountability - See It, Own It, Solve It, and Do It. 


    • Master’s degree in computer science, computer application or related field of study.
    • 3+ years of experience architecting, developing and/or managing the implementation of Business Intelligence solutions using Microsoft SQL Server, Microsoft SharePoint and Microsoft Excel utilizing experience with Microsoft OLAP, Hyperion, Cognos, Business Objects or other enterprise level tools.
    • Extensive experience designing and the development of large Enterprise data warehouses and reporting systems for a large scale BI user community.
    • Expertise in the Microsoft BI solution offerings including SQL Server 2014/2012/2008 R2 stack (SSRS, SSAS, SSIS), PowerView, PowerPivot, Decomposition Tree, SharePoint, Excel, PerformancePoint Server, PowerBI.
    • Advanced proficiency with Microsoft Excel and experienced in the development of KPI Dashboards.
    • Understanding of multi-dimensional database design and architecture.
    • Ability to conduct quality control/auditing to ensure accurate and appropriate use of data during the project system, integration test and user acceptance testing.
    • Experience with data analytics providing actionable data driven decision making.
    • Must be extremely detail-oriented with respect to documentation and communication.
    • Strong problem solving, math, statistics, analytical and quantitative reasoning skills.
    • Whole problem solver, implements solutions to solve root cause problems
    • Able to express complex concepts effectively, both verbally and in writing to business partners.
    • Comfortable interacting with stakeholders at all levels throughout the business.
    • Desire to achieve excellent project outcomes, and exceed expectations.


    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed

    Need help finding the right job?

    We can recommend jobs specifically for you! Click here to get started.