Data Engineering (Python + SQL with ETL)

Cloud Analytics Technologies, LLC; Alpharetta (GA); On-site; USD 83,000 - 124,000; Full time

Job summary

CLOUD ANALYTICS TECHNOLOGIES is seeking a Data Engineer to design, build, and maintain robust data pipelines using Python and SQL. The role emphasizes ETL development, data integration from APIs and multiple databases, and collaboration with analysts to produce clean, reliable datasets for analytics and reporting.

Experience with Power BI is a plus, and strong knowledge of version control and scripting is expected. The position is a 12+ month engagement with an hourly DOE rate in Alpharetta, GA.

Qualifications

• Hands-on experience designing, building, and maintaining robust data pipelines using Python and SQL.
• Expert in writing complex SQLs and developing reusable data extraction scripts.
• Skilled in writing optimized, scalable queries for analytics and reporting.
• Experience integrating data from APIs and multiple databases.
• Familiar with version control (Git) and basic shell scripting.

Responsibilities

• Design, build, and maintain robust data pipelines using Python and SQL for analytics.
• Develop reusable scripts for data extraction from structured and semi-structured data formats.
• Write optimized queries to transform and clean data for reporting.
• Integrate data from multiple sources including APIs and databases.
• Collaborate with analysts and data scientists to deliver clean datasets.
• Document data workflows and promote coding best practices.

Job description

Data Engineering (Python + SQL with ETL)

Location:

Duration:

12Months+ Extension

Hourly Rate:

Depending on Experience (DOE)

Work Authorization:

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

Additional Skills:

• 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.
• Lead AI-first transformation - Build and scale AI solutions that redefine industries
• Make an impact - Drive change for global enterprises and solve business challenges that matter
• Accelerate your career - Gain hands-on experience, world-class training, mentorship, and AI certifications to advance your skills
• Grow with the best - Learn from top engineers, data scientists, and AI experts in a dynamic, fast-moving workplace
• Committed to ethical AI - Work in an environment where governance, transparency, and security are at the core of everything we build
• Thrive in a values-driven culture - Our courage, curiosity, and incisiveness - built on a foundation of integrity and inclusion - allow your ideas to fuel progress

CLOUD ANALYTICS TECHNOLOGIES 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. CLOUD ANALYTICS TECHNOLOGIES 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 CLOUD ANALYTICS TECHNOLOGIES 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

Equal Opportunity Employer

CLOUD ANALYTICS 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. CLOUD ANALYTICS 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 CLOUD ANALYTICS 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

Some of our Business Ventures - Knowledge Analytics

Do restrictive necessities, your capability for advanced analytics or your business model need custom-made applications and infrastructure configurations? opt for our hosted managed services to urge comprehensive analytics solutions supported industry-leading Cloud Analytics Technologies, LLC code - delivered by the Cloud Analytics Technologies, LLC consultants UN agency understand these solutions best. Through a mix of with-it technology and dedicated service and support, Cloud Analytics Technologies, LLC hosted managed services will facilitate you: