USA Jobs, Careers and Recuitements
Job Target Job Search

Contact Information

Contact Name: DAVE

Job Details: BI Architect/SQL DBA Date: May 29 2020

Job Reference: 2392
Job Category: Engineering Jobs [ View All Engineering Jobs Jobs ]
Company Type Recruiter
Employment type: Full Time
Salary: 120 USD / Contract
Degree: High School
Experience: 3 years
Location: Houston, Delaware, 19954
Job Skills: BI Architect/SQL DBA
Share Job with Others

Job Tools

Job Description

• Assess and cultivate long-term strategic goals for BI development in conjunction with end users, managers, clients, and other stakeholders.
• Conduct research and make recommendations on BI products, services, and standards in support of procurement and development efforts.
• Evaluate and select database/data warehouse components, including hardware, relational database management systems, ETL software,
metadata management tools and database design solutions.
• Travel periodically and as required to various office and work site locations
• Additional special projects and duties as directed by management
• Direct, organize, and lead projects in the implementation and use of new BI software tools and systems.
• Lead 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 semantic layer, metadata, reports, and report definitions.
• Develop graphs and portal interfaces.
• Assist in 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.
• Produce ETL design guidelines to ensure a manageable ETL infrastructure for the BI system.
• Work with project managers to ensure that data entry, retrieval, change, and delete functions meet business requirements for project completion.
• Conduct job duties and responsibilities according to the organization’s business systems development methodology and its Systems Development Life Cycle (SDLC) methodology.
• 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.
• Act as evangelist for BI benefits across the organization; promote BI usage to relevant departments.
• Mentor and/or provide leadership to junior members of the team.

Knowledge & Skills:
• Strong background in designing oil and gas facilities from the wellhead to the sales meter
• Possess a strong background in process engineering
• Strong background in process safety management and process modeling and optimization
• Working knowledge of US Federal and Texas State oil & gas development legislation and regulations
• Minimum of 8 years direct work experience
• Comprehensive data warehouse analysis and design experience, with full knowledge of data warehouse methodologies and data modeling
• Experience with Master Data Services (MDS), tier-one applications, databases, and data warehouses, such as Oracle 9i, MS SQL Server, SAP, SCM
• Expertise in Business Objects tools, such as Scheduler, Designer, Data Integrator, and BO Universe design.
• Demonstrated ability with ETL tools, including SSIS
• Strong ability to analyze user requirements and build front-end BI applications according to specifications.
• Knowledge of MS Powershell scripting language
• Strong understanding of relational database structures, theories, principles, and practices.
• Full project management and development life cycle experience
• Demonstrated ability with MS Windows operating systems

Copyright © 2020 Jobxoom All rights reserved. Use of this site is subject to certain Terms and Conditions.