Data Engineering (Python + SQL with ETL)

Ethereum Technologies LLC; Alpharetta (GA); On-site; Full time

Job summary

A leading technology company is seeking a Data Engineer proficient in Python and SQL to design and maintain data pipelines. The role involves building robust ETL processes, integrating diverse data sources, and collaborating with data scientists for analysis. Ideal candidates will have hands-on experience with complex SQL, data source integration, and a familiarity with Power BI. This position encourages a collaborative environment focused on delivering reliable data for business decisions.

Qualifications

• Good hands-on experience designing and maintaining data pipelines using Python and SQL.
• Expert in writing complex SQLs and optimizing database interactions.
• Experience with diverse file-based data sources like CSV and JSON.

Responsibilities

• Design, build, and maintain robust data pipelines.
• Integrate data from different sources and document workflows.
• Work with analysts and data scientists to deliver clean datasets.

Skills

Python

SQL

ETL processes

Data pipeline development

API integration

Tools

Power BI

PostgreSQL

MySQL

SQL Server

Job description

Data Engineering (Python + SQL with ETL)

• Good hands‑on years of experience in designing, building, and maintaining robust data pipelines using Python and SQL.
• Expert in writing complex SQLs.
• Develop reusable scripts for data extraction from various structured and semi‑structured file formats.
• Write optimized and scalable queries to retrieve, clean, and transform data for analytics and reporting.
• Integrate data from different sources, including APIs and multiple databases.
• Work closely with analysts, data scientists, and business stakeholders to deliver clean, reliable datasets for analysis.
• Document data workflows and ensure best practices in coding and version control.
• Good to have experience on Paginated Reports and Power BI issues, Power BI Development, enhancement, and Migration.
• Core Python:Expert‑level proficiency in writing efficient, modular, and production‑grade Python code for data extraction, transformation, and loading (ETL) processes.
• SQL & Databases:Highly skilled in writing complex SQL queries, stored procedures, and optimizing database interactions. Hands‑on experience connecting Python scripts with various relational databases (e.g., PostgreSQL, MySQL, SQL Server).
• Data Source Integration:Extensive experience working with diverse file‑based data sources such as CSV, JSON, and Excel, including parsing, transforming, and integrating them into ETL pipelines.
• API & DB Connectivity:Exposure to consuming REST APIs for data ingestion and integrating multiple database sources in a unified workflow.
• Familiarity with version control (Git), basic shell scripting, and working knowledge of data validation and performance tuning.
• PBI Skills: Desirable to have skills on Power BI Development, enhancement and Migration.

ETHEREUM TECHNOLOGIES LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. ETHEREUM TECHNOLOGIES LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will ETHEREUM TECHNOLOGIES LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract