AMEND
Posted 1y ago

Data Engineer

AMEND
Cincinnati, Ohio, United States
OnsiteFull Time
Responsibilities
  • Create pipelines
  • Assemble datasets
  • Automate processes
Requirements
  • Data Engineer with SQL, data pipelines, and analytics
  • Databricks/DBT experience preferred
Technical tools mentioned
SQLDatabricksDBT

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 leave
  • 3:1 charity match
 
All this to say – we are looking for talented people who are excited to make an impact on our clients.  If this job description isn’t a perfect match for your skillset, but you are talented, eager to learn, and passionate about our work, please apply! Our recruiting process is centered around you as an individual and finding the best place for you to thrive at AMEND, whether it be with the specific title on this posting or something different.  One recruiting conversation with us has the potential to open you up to our entire network of opportunities, so why not give it a shot?  We’re looking forward to connecting with you.

 

*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.* 

About AMEND

Provides management consulting for operations, analytics, and business technology.

Similar jobs

Data Engineer roles near Cincinnati, Ohio
3d
Save
Mark Applied
Hide
Data Engineer
Cincinnati, Ohio, United States
OnsiteFull Time
Cincinnati Reds
Cincinnati Reds: Operates the Cincinnati Reds Major League Baseball franchise.
2+ YOEBachelor's degree or equivalent technical experience, 2+ years of professional experience, SQL and Python proficiency, and experience with cloud, ETL/ELT, DevOps, orchestration, and infrastructure tools.
SQL, Python, PySpark, Git, Continuous Integration/Continuous Deployment (CI/CD), Azure DevOps, Azure, Google Cloud Platform (GCP), Amazon Web Services (AWS), Terraform, CloudFormation, Kafka, Kinesis, Apache Airflow, Dagster, Prefect
3d
Save
Mark Applied
Hide
Senior Data Engineer (P1129)
Chicago or Cincinnati or United States
$98k-$169k/yr OnsiteFull Time
84.51°
84.51°NYSE: KR: Provides retail data analytics and targeted advertising services.
3+ YOERequires 3+ years in data development, Databricks, PySpark/Spark, and Python or Java; ETL, data warehousing, orchestration, CI/CD, version control, Agile, AI concepts, and a relevant bachelor's degree.
PySpark, Python, Databricks, FastAPI, Helm, Azure Kubernetes Service (AKS), Spark, Java, Azure, Databricks Delta Tables, Delta Lake, Delta Live Tables, Flask, Kubernetes, Structured Streaming, Kafka, Azure Event Hubs, GitHub, GitHub Actions, Terraform, Tableau, Microsoft Power BI, Cognos
4d
Save
Mark Applied
Hide
Data Engineer
Dayton, Ohio, United States
$62k-$141k/yr OnsiteFull Time
Booz Allen Hamilton
Booz Allen HamiltonNYSE: BAH: Consulting and technology services for government and commercial clients
5+ YOERequires 5+ years in data architecture, design, or engineering, a bachelor's degree in computer science or a technical discipline, AWS knowledge, programming experience, and TS/SCI clearance.
IoT, machine learning, artificial intelligence, Extract, Transform, Load (ETL), NoSQL, SQL, AWS, Amazon S3, AWS IAM, Amazon EventBridge, AWS Step Functions, AWS Lambda, dbt, Airflow, GitHub, CI/CD, Python, Rust, C++, Java, API, AWS architecture
5d
Save
Mark Applied
Hide
Google Senior Data Engineer
Albany or Arlington or Atlanta or Austin or Beaverton or Bentonville or Boston or Carmel or Charlotte or Chicago or Cincinnati or Cleveland or Columbus or Culver City or Denver or Des Moines or Detroit or Hartford or Houston or Irving or Kirkland or Miami or Milwaukee or Minneapolis or Morristown or Mountain View or Nashville or New York City or Oklahoma City or Overland Park or Philadelphia or Pittsburgh or Raleigh or Redmond or Sacramento or San Diego or San Francisco or Scottsdale or Seattle or St. Louis or St. Petersburg or Walnut Creek or United States
$80k-$266k/yr HybridFull Time
Accenture
AccentureNYSE: ACN: Global professional services firm providing consulting and technology solutions.
5+ YOERequires 5+ years in data engineering, analytics, or ML; 4+ years with GCP; 5+ years with SQL and pipelines; 3+ years with Python or AI tools; and a bachelor's degree or equivalent.
Google Cloud Platform (GCP), BigQuery, Looker, Vertex AI, Gemini Foundation Models, Gemini Enterprise, Dataflow, Dataproc, Pub/Sub, Cloud Storage, Looker Studio, Model APIs, Embeddings, Dataplex, IAM, SQL, Python, Git
5d
Save
Mark Applied
Hide
Data Engineer
Dayton, Ohio, United States
$62k-$141k/yr OnsiteFull Time
Booz Allen Hamilton
Booz Allen HamiltonNYSE: BAH: Provides technology and management consulting services to diverse organizations.
5+ YOERequires 5+ years in data architecture, design, or engineering; cloud migration, ETL, pipelines, databases, AI/ML integration, AWS, TS/SCI clearance, and a bachelor's degree in computer science or a technical discipline.
IoT, machine learning, artificial intelligence, Extract, Transform, Load (ETL), NoSQL, SQL, AWS, Amazon S3, AWS IAM, Amazon EventBridge, AWS Step Functions, AWS Lambda, dbt, Apache Airflow, GitHub, Python, Rust, C++, Java, CI/CD
6d
Save
Mark Applied
Hide
Data Engineer Lead
San Antonio or Beavercreek or Houston or Charlotte or Huntsville or Atlanta
$92k-$153k/yr OnsiteFull Time
Guidehouse
Guidehouse: Provides management and technology consulting services to diverse organizations.
7+ YOEBachelor's degree in a technical field, 7+ years of data or software engineering experience, technical leadership, Python, SQL, Spark/PySpark, cloud platforms, data pipelines, ETL/ELT, CI/CD, Docker, and Kubernetes.
Python, SQL, Spark, PySpark, AWS, Azure, Databricks, Snowflake, Docker, Kubernetes, Terraform, CloudFormation, Bicep, ARM, Kafka, Event Hub, Kinesis, Splunk, Datadog, CloudWatch, Kibana, Elasticsearch
6d
Save
Mark Applied
Hide
Branch Operations Data Engineer
Irving or Hopkins or Cincinnati or United States
$93k-$109k/yr OnsiteFull Time
U.S. Bank
U.S. BankNYSE: USB: Provider of personal, business, and institutional financial services.
4+ YOEBachelor's degree in a related field or equivalent experience, plus 4–5 years of statistical or data analytics experience; requires advanced analytics, predictive modeling, communication, and project management skills.
E-Verify
6d
Save
Mark Applied
Hide
Data Engineer Intern - Spring 2027
Cincinnati, Ohio, United States
OnsiteFull Time, Internship
Medpace
MedpaceNASDAQ: MEDP: Full-service clinical research organization for pharmaceutical and biotechnology industries.
Working toward a bachelor's degree in computer science, data science, or a related field, with excellent communication, analytical, and problem-solving skills.
Snowflake, SQL Server, Azure SQL, dbt, Azure Data Factory, SSIS, Microsoft Power BI, Extract, Transform, and Load (ETL), Extract, Load and Transform (ELT)