DATA ANALYST

Role: Data Analyst

Location: Hybrid (3x a week onsite/Houston,TX ) Duration: 6 month contract

Job Description: Support Data Management & Analytics reporting, analytics, planning, root cause analysis, and process improvements with industry and corporate o&g operation datasets. Develop innovative analytic solutions, while creating actionable insights and driving decisions. Formulate hypothesis, develop queries and models to evaluate hypotheses and formulate solutions to drive process and performance improvement within various operations life-cycle stages. Collaborate and educate stakeholders while supporting data governance Develops and maintains relationships and partnerships with corporate departments, stakeholders, peers, and partner Develop data management frameworks to properly tag and manage curated data assets, promoting reuse and avoiding a ‘data swamp’ Partner with IT support to evaluate, prioritize, and develop data management supporting applications. Work with internal customers/partners to gather requirements, build, and deploy robust models. Work with the business and application designers to identify and model integrative views of data and determine the quality of service requirements (data currency, availability, response times, and data volumes). Loading and transforming sets of structured, semi structured and unstructured data. Own data QA, ensuring precise, unique, and fresh data is available to multiple business teams Ad Hoc data requests for business team members Reverse-engineer & document legacy ETL code for maintainability. Manage related metadata to include business descriptions of the data, details of any calculations and summaries, descriptions of the sources, and indications of data quality and currency. Aid in the analysis of data and analytics security requirements and solutions. Work with the security team to ensure that enterprise data and analytics assets are treated as protected assets. Record how data is moved around the “virtual” enterprise, including frequency of movement, source and destination of each step, transformation, and any aggregation or calculations. Recommend any opportunities for efficiencies and improvement of data quality. Provide leadership to the data management team on a continual basis on emerging trends and best practices.

Requirements

Bachelor’s degree, or foreign degree equivalent, in Statistics, Data Science, Mathematics, Computer Science, or Engineering (any) or a related field and 3 years of progressively responsible post-bachelor’s degree related experience. Experience in Oil and Gas operations and terminology Strong hands-on skills and deep knowledge of SQL, Stored Procedure, and advanced SQL in Data Warehousing environment The position also requires 3 years of experience in data analysis using tools such as Excel, Tableau, SQL, SAS Suite, MSSQL Server and Oracle 3 years of experience in reporting using tools such as Tableau, Excel, Oracle, SQL, and PowerBI 3 years of experience in business intelligence using Tableau, Excel, Spotfire, and PowerBI Experience in building ETL / data warehouse transformation processes Familiarity with best practices in development of data warehousing Deep knowledge of ETL pipelines, data warehouse management, and data governance Experience in data strategies, data analysis, database architecture and management, development or administration and relevant data processing, systems analysis/design, and 2-3 years of experience developing/maintaining database objects in one of the database systems or a combination of education and experience from which comparable knowledge and skills are acquired. Ability to translate business requirements into ETL technical requirements Advanced SQL skills in the methods of stored procedures, functions, triggers, indexes, and security Python

--

Thanks & Regards, Pallavi Reddy| Technical Recruiter Thoughtwave Software and Solutions Desk: 6302289745 ,EXTN:167 Email: pallavi@thoughtwavesoft.com Linked in: https://www.linkedin.com/in/pallavi-batchu-2756a8296/