Job Description :
Data Warehouse Analyst
Location – Houston, TX – Local candidates only – in-person interview required.
Duration – 6 months
Skillsets:
· 8 years of experience as a Data Warehouse Analyst
· Proficient on SQL queries development
· Knowledge on Data warehouses techniques with emphasis on Oracle Data warehouse
· Domain/subject matter expertise on Oilfield business
· Knowledge on Microsoft products like SSAS, SSIS, SQL Server
· Knowledge on VSTS
· Desirable knowledge on OBIEE and PowerBI. The candidate will not be developing dashboards himself but must support the developers and for doing so, knowledge on these tools is desirable
Project Role:
BI consultant reports to the DR Application Manager. BI consultant tasks will include the following but not be restricted to:
Gather requirements from stakeholders belonging to different business domains on the company. The candidate must be capable to understand, extract, challenge requirements coming from different business domains users (finance, HR, assets management, operations)
Ability to mine, analyze and understand the data available on different source systems and design the best technical solution proposing how to extract and transform these datasets into the data cubes that will be used on the end users reports
Develop the procedures responsible for extracting and transforming the data into the final designed data cube.
Develop processes and tools to monitor the performance of the transformation process and the accuracy of the data
Document the database models, ETL data flow from source to final data cubes and all the business rules implemented