Data Architect (Big Data)

TL;DR

Data Architect (Big Data): Designing and implementing robust data models and ETL processes for scalable reporting and analytics with an accent on dimensional modeling and data lake optimization. Focus on improving query performance, enforcing data quality standards, and scaling data volume across the organization.

Location: Alpharetta, Georgia

Company

hirify.global is a leading provider of payment technology services and software for merchants and consumers globally.

What you will do

• Design and implement robust data models leveraging dimensional modeling principles for performance and scalability.
• Develop efficient ETL processes, data pipelines, and workflows to integrate data from multiple sources into the data lake.
• Solution and optimize data lake architectures to ensure high query performance as data volume grows.
• Establish and enforce data quality standards, including validation, transformation, and cleansing rules.
• Perform detailed performance tuning of ETL processes and optimize queries to reduce data access latency.

Requirements

• BS in Computer Science, Information Technology, Business/MIS or a related field.
• Minimum of 2 years of professional experience in coding, designing, and analyzing data.
• Expertise in designing star schemas, snowflake schemas, and dimensional models per Kimball methodology.
• Proven experience with ETL frameworks and data warehousing platforms such as Snowflake, BigLake, or BigQuery.
• Deep understanding of SQL, query optimization, and performance tuning.
• Strong proficiency in Python, Java, or Scala for pipeline development.

Nice to have

• 4+ years of professional experience in data design and development.
• Familiarity with OpenTelemetry.
• Basic to advanced knowledge of AI/ML.
• Experience with big data technologies such as Spark, Kafka, DBT, Iceberg, or Parquet.