Data Engineer

Zyxware Technologies Pvt. Ltd; United States; On-site; USD 110,000 - 150,000; Full time

Job summary

Zyxware Technologies Pvt. Ltd. seeks an experienced Data Engineer/ETL Specialist to design, build, and maintain the data architecture that supports critical agency reporting.

The role focuses on creating robust ETL pipelines in AWS using Python and developing insights via Power BI or Tableau dashboards. The ideal candidate transforms siloed raw data into actionable insights for agency leadership while ensuring data governance and regulatory compliance across projects.

Qualifications

• Bachelor’s degree in CS/IS/Engineering or equivalent
• 4+ years hands-on Data Engineering/ETL experience
• Experience designing and implementing complex ETL pipelines
• Strong Python for data processing
• Proven experience in AWS cloud environment
• Experience developing reports/visualizations using Power BI or Tableau
• Strong SQL skills

Responsibilities

• ETL Pipeline Development: Design, develop, and automate scalable ETL/ELT processes to move data into our central data warehouse.
• AWS Infrastructure Management: Utilize AWS services to architect secure and efficient data solutions.
• Data Transformation & Coding: Write clean Python code for data manipulation, cleansing, and validation.
• Business Intelligence Reporting: Develop interactive dashboards/reports using Power BI or Tableau to track KPIs.
• Data Governance: Ensure data architecture complies with security standards and privacy regulations.

Skills

Python

SQL

AWS

Power BI

Tableau

ETL

Data governance

Education

Bachelor’s degree in Computer Science, Information Systems, Engineering, or equivalent

Tools

Python

AWS

Power BI

Tableau

Snowflake

Job description

Position Summary: We are seeking an experienced and analytical Data Engineer/ETL Specialist to join our technical team. This is a pivotal role responsible for designing, building, and maintaining the data architecture that supports critical agency reporting.

The ideal candidate is a "builder" who is comfortable working within the AWS ecosystem to create robust ETL pipelines using Python, and who also possesses the business intelligence sensibilities to develop insightful dashboards using Power BI or Tableau. You will play a key role in transforming siloed, raw data into actionable insights for agency leadership.

Key Responsibilities:

• ETL Pipeline Development: Design, develop, and automate scalable Extract, Transform, and Load (ETL/ELT) processes to move data from various government source systems into our central data warehouse.
• AWS Infrastructure Management: Utilize AWS cloud services (such as S3, Glue, Lambda, RDS, or Redshift) to architect secure and efficient data solutions.
• Data Transformation & Coding: Write clean, maintainable Python code for complex data manipulation, cleansing, and validation to ensure high data quality standards.
• Business Intelligence Reporting: Collaborate with stakeholders to gather requirements and develop interactive, high-impact dashboards and reports using Power BI or Tableau to track key performance indicators (KPIs).
• Data Governance: Ensure all data architecture complies with federal security standards, data governance policies, and privacy regulations.

Required Qualifications:

• Bachelor’s degree in Computer Science, Information Systems, Engineering, or equivalent relevant experience.
• Minimum of 4 years of hands‑on experience in Data Engineering or ETL development.
• Demonstrated expertise in designing and implementing complex ETL pipelines.
• Strong proficiency in Python for data processing and scripting.
• Proven experience working within the Amazon Web Services (AWS) cloud environment.
• Significant experience developing advanced reports and visualizations using either Microsoft Power BI or Tableau.
• Strong SQL skills for querying and analyzing data.

Preferred Qualifications (Desired but not required):

• Experience with the Snowflake Data Cloud platform.
• AWS Certified Data Analytics or Solutions Architect certifications.
• Prior experience working within a federal agency or heavily regulated environment.