Apply on Employer Site

AMEND Consulting · 5 months ago

Senior Data Engineer

Cincinnati, Ohio, United States

Full-time

Onsite

Senior Level

AMEND is a management consulting firm based in Cincinnati, OH, focused on operations, analytics, and technology. The Senior Data Engineer consultant role involves designing analytic solutions, optimizing data architecture, and collaborating with various teams to enhance data-driven decision-making.

AnalyticsBig DataBusiness IntelligenceConsultingManagement Consulting

No H1B

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

SQLData pipeline optimizationData architecture designDatabricksDBTAnalytic skillsRoot cause analysisData transformationCuriosityCreativity

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