Share this Job
Apply now

Apply for Job

Title:  Business Intelligence Architect IV

Date:  Jul 30, 2022

Dallas, TX, US, 75201

Basic Function

HF Sinclair is seeking a Business Intelligence Architect IV who will support the company’s application systems and reporting environments and performs complex and large scale assignments while working with key users to improve business processes. Provides technical expertise, direction and training for team members as well as business users.

Job Duties

  • Helps define the technical vision, strategy and plan for modeling layers of the enterprise data warehouse (EDW) to enable the development of high value, analytic solutions aligned with business needs
  • Provides expert level support for the Business Intelligence/Data Warehousing (BI/BW) module and portal including configuration and enhancement requests from the user community and company management
  • Interacts with both functional and technical groups to understand business needs, provides oversight, identifies architectural options, evaluates options against the overall enterprise, information management architecture, and makes recommendations that return analytic business value
  • Implements configuration changes, redesigns, new releases and updates to the systems environment in an effort to optimize the use of Information Technology
  • Designs interfaces, processes, reports, enhancements (including custom programs), and conversions for complex and large scale application systems and reporting environments to meet business requirements
  • Provides technical design and oversight for the justification and development of analytic driven data marts and/or data stores where extensions to the EDW development strategy are being considered
  • Designs and performs quality assurance testing and performs unit and integration testing
  • Supports development of end-user security authorizations by the end-user security authorization administration group
  • Assists with annual and rolling budgeting processes, including development of planning areas, levels, packages, functions, and folders; setting development standards and guidelines for BW; and copying budget objects and data for the next year’s planning process
  • Defines load hourly/daily Data Load strategy to SAP BW Production System and promptly resolves any issues with data loads
  • Provides support for entire BW process, from extraction to end-user reporting, developing and maintaining extractor and update programs, managing aspects of business data from ECC and source systems into BW, and performing BW environment analysis and tuning
  • Creates, maintains and monitors ODS's, InfoCubes and Multi-Providers, and processes chain load schedules
  • Analyzes business content data sources, activates and customizes if necessary; gains in-depth understanding of financial business processes; and gathers data requirements and creates appropriate BW content
  • Creates technical specifications for ABAP development to create data source extractors and maintain BEX and ad-hoc queries via BEX web
  • Creates or debugs Crystal Reports/BOBJ-Xcelsius
  • Facilitates meetings, conducts and leads presentations and/or training sessions with end-users, standardizing training and providing detailed documentation as needed
  • Delivers high-level system solutions to business problems in a timely manner such as architecting proper transport paths for Crystal Reports and SAP BI to reduce number of changes to production
  • Provides clear, concise weekly status reports for assigned team’s issues and projects
  • Consults with colleagues, management, and business team members on requirements, problems, project status, and issues
  • Understands and works within corporate IT governance policies
  • Uses entire Business Objects tool set to develop BI solutions and lead BI project teams, providing them with optimal paths to complete BI development initiatives


Special assignments or tasks assigned to the employee by their supervisor, as determined from time to time, are at the supervisor’s sole and complete discretion.


A minimum of eight years of SAP Business Intelligence work experience with five years of demonstrated experience in a combination of business intelligence architecture, design and development with SAP BI 7.0 and SAP Business Objects are required.

Education Level

A minimum of a Bachelor’s Degree in Computer Science, Information Services or related field is required.


Preferred Education Level:

Master of Business Administration 

Required Skills

Advanced working knowledge of Business Intelligence methodologies, Business Consolidation Systems (BCS) and Business Objects suite of tools such as SAP BI 7.0, BOBJ, Crystal and SAP Business Objects. Advanced data modeling experience with emphasis on design and development of dimensional models, and data warehousing experience focused on business intelligence and information. Highly versatile with advanced team building skills. Self-starter with drive and ability to achieve planned objectives. Advanced ability to work in a fast paced, multi-tasking environment as a team player. Creative, organized, strong time-management and ability to effectively communication with others, both written and verbal communication, and highly responsive to customer needs. Advanced analytical and problem-solving skills and a high attention to detail and accuracy. Presence and confidence to generate credibility both within and outside the Company. Well-developed interpersonal skills to create a positive interaction with people at all levels within and outside the organization. Working knowledge of server administration, optimization and maintenance and project management practices. Intermediate reading and writing skills, and ability to perform intermediate mathematical calculations.


Preferred Skills:

Xcelsius, Web Intelligence (Webi), BO Mobile are preferred.

Work Conditions

Office based with up to 25% travel by land or air is required. Subject to all weather and varying road conditions. Occasional long hours, as well as nights and weekends as needed.

Our One HF Sinclair Culture:

At HollyFrontier, we are united through our One HFC Culture, which is underpinned by our five core values of Safety, Integrity, Teamwork, Ownership and Inclusion. Developed to empower our people, our five core cultural values are at the heart of everything we do and extend to how we engage our stakeholders. These values influence our decisions, shape our behaviors and keep us connected across the entire organization.

We maintain a true Safety culture for our employees, communities, environments and customers. Our goal is to make sure everyone returns home safely each day. We have a long-standing commitment to Integrity and ethical behavior and do what is right for our employees, investors, communities and the environment. We encourage employees to Step Up and Stand Out by championing a culture of Teamwork and Ownership. We foster a culture of Inclusion by encouraging diversity of experiences, viewpoints and backgrounds. What makes each of us different, together makes us stronger.


About HF Sinclair

HF Sinclair, headquartered in Dallas, Texas, is an independent petroleum refiner and marketer that produces high value light products such as gasoline, diesel fuel, jet fuel and other specialty products. HollyFrontier owns and operates refineries located in Kansas, Oklahoma, New Mexico, and Utah and markets its refined products principally in the Southwest U.S., the Rocky Mountains extending into the Pacific Northwest and in other neighboring Plains states. In addition, HollyFrontier produces base oils and other specialized lubricants in the U.S., Canada and Netherlands, and exports products to more than 80 countries. HollyFrontier also owns a 57% limited partner interest and a non-economic general partner interest in Holly Energy Partners, L.P., a master limited partnership that provides petroleum product and crude oil transportation, terminal line, storage and throughput services to the petroleum industry, including HollyFrontier Corporation subsidiaries.

Equal Opportunity Employer

HF Sinclair is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status or any other prohibited ground of discrimination.

Nearest Major Market: Dallas
Nearest Secondary Market: Fort Worth

Apply now

Apply for Job