Senior Data Engineer

AMEND Consulting; Cincinnati (OH); Presencial; USD 120.000 - 160.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Competitive pay & bonus

Travel incentive bonus

Flexible time off

Growth and development

Health, vision, dental, life benefits

Paid parental leave

3:1 charity match

Descripción de la vacante

AMEND Consulting in Cincinnati, OH seeks a Senior Data Engineer consultant to solve real-world problems by designing cutting-edge analytic solutions. You will join a fast-growing team and help optimize or redesign client data architecture as a change agent and technical leader.

You will partner with executives, product, data and design teams to deliver scalable pipelines and actionable insights, while traveling to meet client requirements and contributing to training and adoption of new

Formación

• Advanced SQL with relational databases; DBT/Databricks a plus.
• Experience building and optimizing data pipelines.
• Ability to analyze data to answer business questions.
• Experience with structured and unstructured data.
• Ability to collaborate with multiple business functions.
• Willingness to travel to client sites.

Responsabilidades

• Create and maintain optimal data pipeline architecture.
• Assemble large, complex data sets meeting requirements.
• Identify and implement internal process improvements for scalability.
• Build infrastructure for ETL from varied sources.
• Develop analytics tools for insights on metrics like acquisition and ops.
• Collaborate with Exec, Product, Data, and Design teams on data needs.
• Define project milestones, phases, and deliverables.
• Execute project plan, report progress, resolve problems.
• Delegate tasks per project needs.
• Design and deliver audience training and adoption materials.

Conocimientos

SQL & Databases

Data pipelines

Root cause analysis

Analytical skills

Data transformation

Big data handling

Stakeholder interfacing

Mentoring/coaching

Curiosity

Creativity

Travel flexibility

Herramientas

Databricks

DBT

Descripción del empleo

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.

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 Senior 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 leave
• 3: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.*