Data Engineer

East Daley Capital (EDC) 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 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 and Technology Strategy, 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 VP but will also have unique exposure to C-Suite Executives and long-term objectives of the business.

This is a full-time, exempt position, based in Centennial, Colorado.

Apply at careers@eastdaley.com

Goals of the 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 FTP 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 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 database build out and queries
  • Provide leadership, training, coaching and guidance to junior staff

Success Metrics of Position:

  • 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
  • Client responses are timely, accurate, and provide expert insights to questions
  • 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 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

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 an 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 and Experience:

  • A minimum of 3 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
  • Experience performing root cause analysis on internal and external data and processes to answer specific business questions
  • Proficient in SSIS, SSRS, and Python
  • 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

Benefits:

  • Medical (with multiple plans), Dental, and Vision Coverage with Company Contribution
  • Flexible and Health Savings Account Options with Company Contribution
  • Health Concierge services, Teladoc (Telemedicine), Wellness Programs, Hospital Gap insurance, and more
  • Employee Assistance Program
  • Life and Accidental Death, Short- and Long-Term Disability coverage
  • 401K with Company Contribution
  • Unlimited Paid Time Off
  • Office snacks and Friday Company Paid Lunch
  • Casual Attire
  • Free Office Parking
  • Discounted local gym membership with no contract

Please note 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.