Data Engineer

<div class="content-intro"><p></p> <p> </p> <p></p></div><div><strong>About AMEND: </strong><br><br><span data-teams="true">AMEND is a management consulting firm based in Cincinnati, OH with areas of focus in operations, analytics, and technology. We are focused on strengthening the people, processes, and systems in organizations to generate a holistic transformation. Our three-tiered approach provides a distinct competitive edge and allows us to build strong relationships and create customized solutions for every client. This is an incredible time to step into a growing team where everyone is aligned to a common goal to change lives, transform businesses, and make a positive impact on anything we touch. </span><br><br><strong>Overview:</strong><br><br>The Data Engineer consultant role is an incredibly exciting position in the fastest growing segment of AMEND. You will be working to solve real-world problems by designing cutting edge analytic solutions while surrounded by a team of world class talent. You will be entering an environment of explosive growth with ample opportunity for development. We are looking for individuals who can go into a client and optimize (or re-design) companies data architecture, who are the combination of a change agent, technical leader and passionate about transforming companies for the better. We need someone who is a problem solver, a critical thinker, and is always wanting to go after new things; you’ll never be doing the same thing twice!<br><br><strong>Job Tasks:</strong></div> <ul> <li>Create and maintain optimal data pipeline architecture</li> <li>Assemble large, complex data sets that meet functional / non-functional business requirements</li> <li>Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.</li> <li>Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources</li> <li>Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency, and other key business performance metrics</li> <li>Work with stakeholders including the Executive, Product, Data, and Design teams to assist with data-related technical issues and support their data infrastructure needs</li> <li>Define project requirements by identifying project milestones, phases, and deliverables</li> <li>Execute project plan, report progress, identify and resolve problems, and recommend further actions</li> <li>Delegate tasks to appropriate resources as project requirements dictate</li> <li>Design, develop, and deliver audience training and adoption methods and materials</li> </ul> <div> </div> <div><strong>Qualifications:</strong></div> <ul> <li>Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases. Databricks and DBT experience is a plus</li> <li>Experience building and optimizing data pipelines, architectures, and data sets</li> <li>Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement</li> <li>Strong analytic skills related to working with structured and unstructured datasets</li> <li>Build processes supporting data transformation, data structures, metadata, dependency, and workload management</li> <li>A successful hist