Data Engineer

AMEND Consulting; Cincinnati (OH); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Competitive pay

Travel bonus

Flexible time off

Growth & development

Health benefits

Parental leave

Charity match

Job summary

AMEND Consulting in Cincinnati, OH seeks a Data Engineer consultant to design and optimize data architectures for client engagements. You will build scalable pipelines, transform data, and deliver analytics-driven insights across business functions.

You will work with cross-functional teams, implement robust data solutions, and push for automation and improved data delivery. Travel to client sites is expected as needed.

Qualifications

• Advanced SQL knowledge and relational databases
• Experience building and optimizing data pipelines and architectures
• Root-cause analysis on data and processes to answer business questions
• Strong analytics with structured and unstructured data
• Ability to interface with multiple business functions
• Curiosity and creativity to devise solutions

Responsibilities

• Create and maintain optimal data pipeline architecture
• Assemble large, complex data sets meeting business requirements
• Identify and implement internal process improvements for data delivery
• Build infrastructure for ETL from diverse data sources
• Develop analytics tools using the data pipeline for insights
• Collaborate with executives, product, data, and design teams
• Define project milestones, deliverables, and plan execution

Skills

SQL

Data pipelines

Analytics

Critical thinking

Problem solving

stakeholder collaboration

Tools

Databricks

DBT

Job description

About AMEND:

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.

Overview:

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!

Job Tasks:

• 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:

• 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

What's in it for you?

• Competitive pay and bonus


• Travel incentive bonus structure


• Flexible time off


• Investment in your growth and development


• Full health, vision, dental, and life benefits


• Paid parental leave3:1 charity match

*Applicants must be authorized to work for any employer in the U.S. We are unable to sponsor or take over sponsorship of employment Visa at this time.*