Data Engineer
Job Type
Full-time
Description

East Daley Capital (EDC), recognized as one of Colorado Companies To Watch, is a fast-paced, growth-positioned, data and analytics company disrupting the way oil and gas companies and capital market participants use data and insights. By bringing transparency to the complicated and often misunderstood midstream energy sector, EDC helps clients win by enhancing their risk mitigation strategies and identifying new opportunities to outpace their competitors. The East Daley Team is comprised of highly motivated professionals driven by the challenge of holistically dissecting the energy space and identifying data that can help clients decipher the value chain from producer to demand market. The company is seeking to add new team members, including the role of a Data Engineer to further scale the organization and best-in-class team. The salary for the position is between $90,000 and $110,000, depending on experience.


East Daley Capital (EDC) is seeking a results-driven, detail-oriented Sr. 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 in order ultimately to help 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 build out the company’s data foundation, central to EDC’s strategy and market leadership. As a direct report of the VP of Data Technology, the Sr. 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 Sr. Data Engineer will not only receive mentorship and leadership from the VP but will also have unique exposure to C-Suite Executives and the long-term objectives of the business.


This is a full-time, exempt position, based in Greenwood Village, Colorado, and reports to the VP of Data Technology.

  

Goals of Position

  • 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.
  • Ingest, clean, normalize, and combine non-uniform, automated, and manual oil and gas fundamental data sources through scraping websites, PDFs, Excel-based models, vendor FTP feeds, and raw miscellaneous data files
  • Ensure that data is logically paired together in a database and collectively aggregated in a data warehouse
  • Good understanding of building and designing API’s
  • 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 product
  • 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 layout detailed project plans with key milestones and owners
  • Document all data sources, methodologies, and processes as it relates to formation and refinement of the database build out and queries
  • Provide leadership, training, coaching, and guidance to junior staff

  

Success Metrics of Position Goals

  • Comprehensive, clean, and complete data sets in production that are housed in a data warehouse and are easily accessible via reporting interfaces for all stakeholders
  • Data warehouse that is built for future scale and ensures architectural integrity and consistency
  • Creation and improvement of efficient data intake processes to allow for an ongoing feedback loop of IP with evolving datasets and products into the data warehouse
  • Consistent report formatting and functionality that increases the frequency of delivery to internal stakeholders in order to provide first-to-market insights for clients
  • Robust project plans with key milestones, owners, and details on step by step progression
  • Proficient, efficient, and proactive written and oral communication with stakeholders and management on roadmaps, roadblocks, and data integrity
  • Fulfillment and balance of priorities with both long-term projects and short-term data needs within appointed deadlines
  • Accessible and detailed documentation of processes, methodologies, and systems
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
  • 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 of 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
  • 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