Data Analytics Engineer: SQL & Python Pipelines

Hierarch Soft Technologies, Inc.; Alpharetta (GA); Presencial; USD 90.000 - 120.000; Jornada completa

Descripción de la vacante

Hierarch Soft Technologies, Inc. in Alpharetta, GA seeks a Data Analytics Engineer to build data pipelines, models, and dashboards. The role combines SQL, Python, and data engineering across DB2, Snowflake, and APIs to deliver reusable datasets and KPIs for Power BI and Python apps.

This role emphasizes data quality, validation, and collaboration with business and tech stakeholders, including documenting sources and metrics.

Formación

• Strong SQL and relational database development skills.
• Hands-on experience with IBM DB2, Snowflake, and DuckDB.
• Proficiency in Python, including data manipulation using pandas or similar libraries.
• Experience working with CSV, JSON, Parquet, REST APIs, and relational databases.
• Understanding of data modeling, transformation, data quality, and metric/KPI development.
• Experience preparing data for Power BI or custom analytical applications.
• Familiarity with Git and modern software development practices.
• Experience using GenAI development tools to accelerate development, testing, debugging, and documentation.

Responsabilidades

• Source and integrate data from IBM DB2, Snowflake, CSV/Parquet files, JSON/REST APIs, and other sources.
• Use SQL, Python, and DuckDB to cleanse, join, transform, aggregate, and curate data.
• Develop reusable datasets, metrics, KPIs, and analytical data models.
• Prepare data for consumption by Power BI dashboards and Python-based apps.
• Build repeatable data pipelines with validation, reconciliation, logging, and error handling.
• Identify and resolve data-quality and consistency issues across source systems.
• Prototype and iterate on data solutions with business and tech stakeholders.
• Document data sources, transformation logic, business rules, and metric definitions.

Conocimientos

SQL

Python

Data integration

IBM DB2

Snowflake

DuckDB

Power BI

APIs

Data modeling

Pandas

Git

GenAI tools

Herramientas

IBM DB2

Snowflake

DuckDB

Power BI

Streamlit

Dash

Git

GitHub Copilot

Anthropic Claude

OpenAI Codex

Descripción del empleo

Hierarch Soft Technologies, Inc. in Alpharetta, GA seeks a Data Analytics Engineer to build data pipelines, models, and dashboards. The role combines SQL, Python, and data engineering across DB2, Snowflake, and APIs to deliver reusable datasets and KPIs for Power BI and Python apps.

This role emphasizes data quality, validation, and collaboration with business and tech stakeholders, including documenting sources and metrics.