200+ applicants

Company

Original Job Post

AMEND Consulting · 3 days ago

Data Engineer

Cincinnati, OH

Full-time

Onsite

Mid Level

Wonder how qualified you are to the job?

Maximize your interview chances

AnalyticsBig Data

Insider Connection @AMEND Consulting

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

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

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

SQLDatabase managementDatabricksDBTData pipelinesData analysisRoot cause analysisData transformationMetadata managementWorkload managementData manipulationBusiness acumenProblem-solvingAnalyticalInterpersonalCuriosityCreativity

Required

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

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

Benefits

Competitive pay and bonus

Continued education and individual development plans

Unlimited Vacation

Full Health, Vision, Dental, and Life Benefits

Paid parental leave

PTO for your Birthday

3:1 charity match

Company

AMEND Consulting

AMEND is a management consulting firm with 5 core service offerings: Operational Excellence and Supply Chain, Advanced Analytics, Technology and Digital Transformation, Business Intelligence, and Finance and Accounting.

Founded in 2005