Job Description :
ETL Developer
Long Beach / Bakersfield, CA
Note: Power BI and Microsoft stack Net) experience is the key, Reporting and Dashboarding Developer
This role is responsible for the development, maintenance and support of data infrastructure, ETL processes, reporting, and proof of concepts to help the Strategic Data Department achieve its goals and vison. This role requires close partnership and collaboration with other Data Engineers and Subject Matter Experts.
Description:
Essential Job Duties:
Manage and support existing ETL processes (Procedures, Jobs, Views, etc
Collaborate with Subject Matter Experts to better understand company data sources
Analyze existing SQL / ETL Scripts and improving them to achieve better performance and reliability.
Reverse engineer and write programs with Oracle PL/SQL.
Rapid development of data engineering prototypes
Reporting and dashboarding.
Creating Datamart and maintaining data warehouses.
Administer and support content and records management system
Required Qualifications (list in order of priority):
Bachelor’s degree in Information Technology, Computer Science or similar
4 years and above IT Experience
Superior problem solving and analytical skills related to hardware and software solutions
Strong written and oral communication skills with a customer service focus
Ability to work both independently and in a team environment
Proven skills with creating technical documentation
Experience with Project Management skills
Must have proven skills with drive for results and strong consulting skills
Availability to provide on-call support on a rotational basis
Experienced in .Net development and Microsoft stack
SQL Knowledge and Experience
Experience with one or more RDMS (Oracle and SQL Server etc
Understanding of ETL workflows
Experience with Reports/Visualization/BI Platforms – Spotfire, Tableau, Qlik, Microsoft (Excel/Power BI)
Integrations with o365 toolsets (ower BI, Flow, power apps)
Additional Desired Qualifications (list in priority order):
Experience working in the Oil/Gas Industry
Experience in data science, big data and machine learning tools