Business Intelligence Architect
full_timeAbout This Job
Position Summary:
The Business Intelligence Architect will work directly with the Leadership team assisting in designing and implementing the architecture of data systems and BI solutions that support the organization's data analysis and reporting needs. The duties include developing data models, optimizing data storage, and ensuring integration across multiple systems to enable efficient data extraction and visualization. The Business Intelligence Architect works closely with stakeholders to define business requirements, oversee the technical aspects of BI projects, and ensure the scalability and security of data systems. Strong technical expertise in data warehousing, databases, and analytics tools are essential for success in this role, as they play a critical role in building the infrastructure that powers data-driven decision-making.
Essential Functions & Responsibilities:
•
Guide business partners in developing and implementing Business Intelligence (BI) related strategic goals that will assist them in achieving their objectives.
•
Direct, influence, and support projects in implementing and using new and existing BI software tools and systems.
•
Leads the integration efforts for merging BI platforms with enterprise systems and applications.
•
Design, code, test, and document all new or modified BI systems, applications, and programs.
•
Develop the data layer, cubes, metadata, and report functionality.
•
Leads the design of databases and data warehouses to ensure interoperability with BI solutions.
•
Analyze user requirements and based on findings, design functional specifications for BI front-end applications.
•
Work with stakeholders to ensure that data entry, retrieval, change and delete functions meet business requirements for project completion.
•
Design and deliver end-user training and training materials; provide technical support as necessary.
•
Troubleshoot BI tools, systems, and software; performance-tune these applications as necessary. Conduct BI performance tuning and optimization.
•
Act as an evangelist for BI benefits throughout the organization, promoting healthy usage and adopting standards and best practices.
•
Evaluate and influence the selection of database/data warehouse components, including hardware performance, dimensional and relational database management systems, Extract Transform Load (ETL) best practices, metadata management tools, and database design solutions.
•
Conduct research and provide recommendations regarding BI products, services, and standards to support customer procurement, retention, and development efforts.
•
Develop, design, implement, enhance, maintain and analyze database systems, queries, and procedures in SQL Server and other environments.
•
Develop complex SQL SSIS packages for ETL data for Data Warehouse projects and assignments and be able to modify existing Data Warehouse structure to incorporate data from disparate data sources.
•
Perform development and unit testing of ETL processes (various platforms).
•
Develop, test, and implement solutions that involve databases, OLAP cubes, and reporting components.
•
Perform initial data load and data validation in a production environment.
•
Conduct knowledge transfer sessions with team members, business and IT partners.
•
Facilitate user requirement discussions with the business and drive architecture and design consistent with enterprise strategy.
•
Design and implement enterprise-level BI architectures and solutions aligned with business strategies and goals.
•
Lead the development of data models, ETL processes, and data warehousing solutions.
•
Select and manage BI tools and platforms, such as Power BI, Tableau, Looker, or Qlik.
•
Ensure high performance, scalability, and availability of BI solutions.
•
Establish and enforce data governance, data security, and best practices for BI architecture.
•
Create and maintain documentation for data models, architecture, and BI standards.
•
Stay up to date with emerging trends, tools, and technologies in business intelligence and data analytics.
Required Skills & Competencies
Technical Proficiency:
•
Strong knowledge of BI and data visualization tools (e.g., Power BI, Tableau, Looker, Qlik).
•
Advanced SQL skills for querying and optimizing data across systems.
•
Experience with data modeling techniques (star/snowflake schema, normalized/denormalized structures).
•
Familiarity with data warehousing concepts and platforms (e.g., Snowflake, Redshift, BigQuery, Azure Synapse).
•
Hands-on experience with ETL tools and data pipeline design.
•
Understanding of APIs and data integration standards.
Analytical Thinking:
•
Ability to translate business questions into analytical frameworks and insights.
•
Experience in data quality assurance, data validation, and performance tuning.
Architecture & Design:
•
Strong understanding of enterprise BI architecture and best practices.
•
Experience designing scalable, maintainable BI environments.
•
Knowledge of metadata management, master data management, and data cataloging.
Soft Skills & Leadership:
•
Excellent communication and interpersonal skills for working with both technical and non-technical stakeholders.
•
Strong project management and organizational skills.
•
Proven ability to lead BI initiatives and mentor junior team members.
•
Detail-oriented with a strong commitment to delivering high-quality results.
Tools & Technologies (Preferred):
•
Cloud platforms: AWS, Azure, or Google Cloud.
•
Orchestration and transformation tools: dbt, Airflow, Talend, Informatica.
Education, Certifications, and/or Experience
•
Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or a related field; Master’s degree preferred.
•
5+ years of experience in BI development, with at least 2 years in a BI architecture or leadership role.
•
Strong experience with modern BI tools (e.g., Power BI, Tableau, Looker, Qlik).
•
Proficient in SQL and data modeling techniques (e.g., star schema, snowflake schema).
•
Hands-on experience with data warehousing platforms (e.g., Snowflake, Redshift, BigQuery).
•
Deep understanding of ETL tools and data integration techniques.
•
Knowledge of data governance, security, and compliance best practices.
•
Strong analytical, problem-solving, and communication skills.
Future Career Path Opportunity Area(s)
•
BI / Data Manager/Director
Similar Jobs
Trending Jobs
Electrical Engineer
Dudley Staffing
Full-time
$55 - $75
Canonsburg, PA
5 months ago
Division Order Analyst
Coronado Resources
Full-timeDallas, TX
about 2 months ago
Professional Landman
Penterra Services, LLC
ContractLovington, NM
28 days ago
Accounts Payable Clerk
LPR Energy
Full-time$65000 - $65000
Dallas, TX
2 months ago
Division Order Landman
R. Lacy Services, Ltd.
Full-timeLongview, TX
about 1 month ago
contract landman
HPS Oil & Gas Properties
Full-timeLafayette, LA
4 months ago
Oil and Gas Land and Title Analyst - SAM Associate II
Bank of America
Full-timeDallas, TX
3 months ago
Attorney
Toeppich & Associates
Full-timeHouston, TX
over 1 year ago
Title Landman
Sustain Land Services
Full-timeNorman, OK
3 months ago
Senior Landman
Greenlake Energy
Full-timeAustin, TX
3 months ago
Title Reviewer
Innovation Land Services
Full-timePittsburgh, PA
5 months ago
Oil and Gas Title Attorney
Oliva Gibbs PLLC
Full-timeHouston, TX
2 months ago
Electrical Designer
Dudley Staffing
Full-time$45 - $60
Canonsburg, PA
5 months ago
contract Landman
HPS Oil & Gas Properties
Full-timeMidland, TX
4 months ago
Landman
Stockyards Energy Land Services
ContractAkiachak, TX
6 months ago
Civil/Structural Designer
Dudley Staffing
Full-time$30 - $60
Canonsburg, PA
5 months ago
EH
Project Management Specialist - Entry
Full-timeWest Palm Beach, Florida
3 days ago
contract Landman
HPS Oil & Gas Properties
Full-timeCheyenne, WY
4 months ago
Senior Division Order Analyst
Formentera
Full-time$110000 - $130000
Austin, TX
about 1 year ago
Solar Sales Closer
Yup Solar
Contract$150000 - $300000
Los Angeles, CA
2 months ago