Data Architect/Data Engineer

UsefulBI; Northern (KY); Hybrid; USD 120,000 - 180,000; Full time

Job summary

UsefulBI is seeking an experienced Data Architect/Data Engineer to design scalable data solutions for analytics, reporting, and enterprise data needs. You will model data, build warehouses and data lakes, and guide data platform decisions.

The role emphasizes collaboration with business and analytics teams, ensuring data quality, security, governance, and performance. Proficiency with cloud platforms (AWS/Azure/GCP), SQL, and big data tools is essential.

Qualifications

• 8+ years in Data Architecture / Data Engineering.
• Strong knowledge of SQL, databases, and data modeling.
• Experience with ETL/ELT and data integration.
• Hands-on experience with cloud data platforms: AWS, Azure, GCP.
• Experience with Data Warehouse, Data Lake/Lakehouse, Big Data technologies (Spark, Kafka, Hadoop).
• Understanding of data governance, security, and performance optimization.
• Excellent communication and stakeholder management skills.

Responsibilities

• Design and develop enterprise data architecture solutions.
• Create conceptual, logical, and physical data models.
• Build and optimize data warehouses, data lakes, and data pipelines.
• Define data integration strategies and best practices.
• Collaborate with business, data engineering, and analytics teams.
• Ensure data quality, security, governance, and compliance.
• Provide technical guidance on data platforms and architecture decisions.

Skills

Data Architecture

Data Engineering

Data Modeling

SQL

ETL/ELT

Cloud Platforms

Data Warehouse

Data Lake / Lakehouse

Big Data

Spark

Kafka

Hadoop

Governance & Security

Stakeholder Management

Communication

Job description

JOB DESCRIPTION

Job Summary:

We are looking for an experienced Data Architect/Data engineer to design and implement scalable data solutions that support business analytics, reporting, and enterprise data needs. The ideal candidate will have strong experience in data modeling, cloud data platforms, data warehousing, and designing modern data architectures.

Key Responsibilities:

• Design and develop enterprise data architecture solutions.
• Create conceptual, logical, and physical data models.
• Build and optimize data warehouses, data lakes, and data pipelines.
• Define data integration strategies and best practices.
• Collaborate with business, data engineering, and analytics teams.
• Ensure data quality, security, governance, and compliance.
• Provide technical guidance on data platforms and architecture decisions.

Required Skills & Qualifications:

• 8+ years of experience in Data Architecture / Data Engineering.
• Strong knowledge of SQL, databases, and data modeling.
• Experience with ETL/ELT processes and data integration.
• Hands-on experience with cloud data platforms:
  • AWS / Azure / GCP
• Experience with:
  • Data Warehouse
  • Data Lake / Lakehouse
  • Big Data technologies (Spark, Kafka, Hadoop)
• Understanding of data governance, security, and performance optimization.
• Strong communication and stakeholder management skills.

Preferred:

• Experience with BI tools like Power BI/Tableau.
• Experience designing enterprise-scale data platforms.
• Cloud certifications are a plus.