Data Engineer

Greenwood Village, CO, United States

Description:

East Daley Analytics, the North American Midstream Expert, is seeking an experienced Data Engineer

About East Daley Analytics (EDA)

EDA is a fast-paced data and analytics company whose mission is to drive transparency in the energy sector. EDA, recognized as one of Colorado Companies to Watch , brings transparency to the complicated and often misunderstood energy sector and helps clients make informed strategic decisions.

About the Data Engineer position

East Daley Analytics (EDA) is seeking a results-driven, detail-oriented Data Engineer to join a best-in-class team. The ideal candidate is an innovative problem solver who is self-motivated and proactive, showing extreme passion for organizing raw data into structured and consumable reports. S/he will have a relentless approach to translating data to drive unique market insights to help our clients win. In this position, the Engineer will be able to create structure, in an unstructured and ever-changing environment, with a strong ability to challenge and be challenged in approaches, uses, and organization.

This position represents a rare opportunity to be part of the “Core Data Team” as a thought leader to extend the company’s data foundation, central to EDA’s strategy and market leadership. As a direct report to the Chief Data and Analytics Officer, the Data Engineer will work closely to plan the continued build-out of relational databases within the data warehouse. Their input and advisement of data sources, intake, processes, and implementation into production will be key to further scale product development and market insights for business stakeholders. The Data Engineer will not only receive mentorship and leadership from the CDO but will also have unique exposure to C-Suite Executives and the long-term objectives of the business.

Success Metrics & Position Goals:

Goals of Position:

Ingest, clean, normalize, and combine non-uniform, automated, and manual oil and gas fundamental data sources through scraping websites, PDFs, Excel-based models, vendor API feeds, and raw miscellaneous data files.

Ensure that data is logically paired together in a database and collectively aggregated in a data warehouse.

Develop, construct, test, and maintain databases and data warehouse architecture that supports the requirements of business stakeholders.

Develop dataset processes for data modeling, mining, and production with scheduled deployments and releases in a predictable cadence.

Recommend and implement ways to improve data reliability, efficiency, and quality within the data warehouse and for reports.

Discover opportunities for new data acquisition.

Run queries to produce consumable data and useable reports via.csv and excel for business stakeholders, both on a real-time basis and in a cyclical fashion

Create data tools and interfaces for analytics and team members that assist in building and optimizing products.

Intake Analyst adjustments to complex optimization models and calculations to data files and sources on an ongoing basis, feeding back into databases for reporting accuracy and system of records.

Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, and re-designing infrastructure for greater scalability.

Communicate with both technical and non-technical internal customers to scope business requirements and lay out detailed project plans with key milestones and owners.

Document all data sources, methodologies, and processes as it relates to the formation and refinement of the database build-out and queries.

Requirements:

Job Skills:

Excellent organizational, time management, and project management skills.

Ability to communicate clearly and concisely, especially with detailed project plans, LOEs, dependencies, and challenges to achieving goals.

Demonstrates openness to receive feedback on approaches and solutions, with a relentless pursuit of achieving primary business goals.

Commitment to the "internal client" through exceptional customer service principles

Experience in working in a fast-paced, startup, and high-growth environment with long working hours in and outside the office.

Proven flexibility and ability to manage projects and data needs that may be ambiguous and continuously change during periods of rapid growth.

Work history with the desire to learn quickly and adapt, while thriving in an ever-changing environment.

Education/Experience:

A minimum of 5 years experience in technology with a focus in architectural design and planning, data, BI, and/or data warehousing experience.

Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases. As well as advanced knowledge of Python, SSIS, and SSRS required.

Experience building and optimizing raw data pipelines, architectures, and data sets, with strong analytics skills related to working with unstructured data sets.

Machine learning experience and experience with big data infrastructure inclusive of MapReduce, Hive, HDFS, YARN, HBase, Oozie, etc.

Experience performing root cause analysis on internal and external data and processes to answer specific business questions.

Proficiency in Microsoft Office Suite.

Project Management Certifications preferred.

Small to high-growth company experience preferred.

Bachelor’s degree in information systems, Computer Information Systems, Engineering, Mathematics, or similar field preferred.

Oil and Gas industry experience is a plus.

Renewable energy experience is a plus.

Working with Executive and C-level teams is a plus.

AI experience is a plus.

Benefits:

Medical (with multiple plan options), Dental, and Vision Coverage with Company Contributions

401K with a 3% Company Match

Flexible and Health Savings Account Options with Company Contributions

EAP and Wellness Program

Reasonable unlimited vacation days

Casual Attire

Flexible, hybrid work environment

Weekly paid lunch

Please note that this job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

East Daley Analytics is an Equal Employment Opportunity (EEO) employer and welcomes all qualified applicants. Applicants will receive fair and impartial consideration without regard to race, sex, color, religion, national origin, age, disability, veteran status, genetic data, or other legally protected status.

Salary Description:

The salary range is $80,000 - $100,000.

#J-18808-Ljbffr