Data Engineer

About the role

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.

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 leave
• 3:1 charity match