Data Engineer, Mid-Level

Verified Job On Employer Career Site

Job Summary:

AMEND is a management consulting firm based in Cincinnati, OH, focused on operations, analytics, and technology. They are seeking a Data Engineer consultant to design cutting-edge analytic solutions, optimize data architecture, and work collaboratively with various stakeholders to solve real-world problems.

Responsibilities:

• Create and maintain optimal data pipeline architecture

• Assemble large, complex data sets that meet functional / non-functional business requirements

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

• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources

• Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency, and other key business performance metrics

• Work with stakeholders including the Executive, Product, Data, and Design teams to assist with data-related technical issues and support their data infrastructure needs

• Define project requirements by identifying project milestones, phases, and deliverables

• Execute project plan, report progress, identify and resolve problems, and recommend further actions

• Delegate tasks to appropriate resources as project requirements dictate

• Design, develop, and deliver audience training and adoption methods and materials

Qualifications:

Required:

• 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 data pipelines, architectures, and data sets.

• Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.

• Strong analytic skills related to working with structured and unstructured datasets.

• Build processes supporting data transformation, data structures, metadata, dependency, and workload management.

• A successful history of manipulating, processing, and extracting value from large, disconnected datasets.

• Ability to interface with multiple other business functions (internally and externally).

• Desire to build analytical competencies in others within the business.

• Curiosity to ask questions and challenge the status quo.

• Creativity to devise out-of-the-box solutions.

• Ability to travel as needed to meet client requirements.

Preferred:

• Databricks and DBT experience is a plus.

Company:

Growth stalls out when lingering problems go unaddressed for too long, wasting valuable time and resources. Founded in 2005, the company is headquartered in Cincinnati, Ohio, USA, with a team of 51-200 employees. The company is currently Growth Stage.