Sr Data Engineer

AssureSoft Corporation; United States; Remote; USD 130,000 - 190,000; Full time

Benefits offered by this job

Great Place To Work certification

Long-term projects

English scholarships

English classes

State-of-the-art tools

Certifications

Recreation activities

Regulatory compliance

Job summary

AssureSoft is seeking a Senior Data Engineer to design, build, and optimize scalable data pipelines and ETL/ELT processes. You will implement data ingestion, transformation, and quality checks using Python, SQL, dbt, and Airbyte, with Snowflake data warehousing and MySQL sources.

Collaboration with engineers, analysts, and stakeholders is essential. The role emphasizes performance tuning, reliable data solutions, and cost-efficient pipeline improvements, with remote-friendly arrangements and

Qualifications

• Senior data engineering experience with a track record of delivering scalable pipelines.
• Proficient in Python for data processing, automation, and pipeline development.
• Advanced SQL skills and performance tuning.

Responsibilities

• Design, develop, test, and maintain scalable data pipelines and ETL/ELT processes.
• Build and optimize data transformation workflows using Python, SQL, and dbt.
• Develop and maintain data ingestion, synchronization, and integration pipelines using Airbyte.
• Design and optimize data models, transformations, and queries in Snowflake.
• Extract, transform, and integrate data from relational databases, including MySQL.
• Implement data quality checks, validation processes, error handling, and pipeline monitoring.
• Troubleshoot pipeline failures, perform root cause analysis, and implement sustainable solutions.
• Develop clean, reusable, maintainable, and well-documented code and SQL transformations.
• Collaborate with engineers, analysts, developers, and stakeholders to deliver reliable data solutions.
• Participate in technical estimation and development planning.
• Improve pipeline performance, scalability, reliability, and cost efficiency.

Skills

Python

SQL

Data pipelines

ETL/ELT

Troubleshooting

Tools

dbt

Airbyte

Snowflake

MySQL

Git

CI/CD

Docker

Job description

The key to our success is simple; we deliver the highest quality, on time, with passion and commitment, and live every day by a set of great values. We've built a company that fosters long-term careers in an environment of continuous learning, with cutting-edge benefits, tools, and resources. In addition, certifications that endorse our company as a great place to work.

Responsibilities

• Design, develop, test, and maintain scalable data pipelines and ETL/ELT processes.
• Build and optimize data transformation workflows using Python, SQL, and dbt.
• Develop and maintain data ingestion, synchronization, and integration pipelines using Airbyte.
• Design and optimize data models, transformations, and queries in Snowflake.
• Extract, transform, and integrate data from relational databases, including MySQL.
• Implement data quality checks, validation processes, error handling, and pipeline monitoring.
• Troubleshoot pipeline failures, perform root cause analysis, and implement sustainable solutions.
• Develop clean, reusable, maintainable, and well-documented code and SQL transformations.
• Collaborate with engineers, analysts, developers, and stakeholders to deliver reliable data solutions.
• Participate in technical estimation and development planning.
• Improve pipeline performance, scalability, reliability, and cost efficiency.

Requirements

• Solid professional experience in data engineering at a senior level.
• Strong proficiency in Python for data processing, automation, and pipeline development.
• Advanced SQL skills, including complex queries, data transformations, and performance optimization.
• Proven experience designing, developing, and maintaining ETL/ELT pipelines.
• Hands-on experience with dbt for data transformation, modeling, testing, and documentation.
• Practical experience with Airbyte for data ingestion, synchronization, and integration.
• Strong experience with Snowflake, including data warehousing, data modeling, and query optimization.
• Experience with relational databases, particularly MySQL.
• Solid understanding of data warehousing, dimensional modeling, and data pipeline architecture.
• Experience implementing data quality validation, error handling, and pipeline monitoring.
• Familiarity with Git, version control, and collaborative development workflows.
• Experience with CI/CD pipelines and modern data engineering practices.
• Hands-on experience using AI-assisted software development tools.
• Strong debugging, troubleshooting, and analytical problem-solving skills.
• Ability to work independently, collaborate effectively, and take ownership of deliverables.

Nice to Have

• Experience with cloud platforms (AWS, Azure, or Google Cloud), Docker, and modern data lake architectures.
• Familiarity with Agile methodologies, data governance, security, and access control best practices.

#LI-REMOTE

About us

AssureSoft is a multinational software development and information technology company providing strategic consulting, technology services, and outsourcing business processes. We work to innovate and create quality software with motivated, passionate, and qualified teams that develop in an environment of professional, stable growth and continuous learning.

Inclusive Opportunities for Every Talent. At AssureSoft, we believe that true innovation is born from diversity—of ideas, experiences, and perspectives. That’s why our hiring practices are inclusive and reflect a firm commitment to equity and equal opportunity.
Here, every person—regardless of origin, gender, orientation, or beliefs—finds a space to grow, contribute, and be valued not only for their talent, but also for who they are.

What sets us apart

• Great Place To Work certification.
• A company with more than 15 years of experience.
• Work with world-class clients and long-term projects.
• English scholarships for an external institute.
• English classes with company teachers.
• State-of-the- art tools and resources.
• Certifications for your professional growth.
• Recreation and leisure activities.
• Compliance with the regulations and labor rights of your region.

Retention of your personal information: AssureSoft will retain your personal information for as long as necessary to fulfill the purposes for which it was collected or as necessary to comply with our legal obligations, resolve disputes, and maintain appropriate business records. Once the purpose has been fulfilled, your personal information will be retained and blocked due to the possibility of legal and governmental requirements, and until the status of limitations has run out.

Important Notice Regarding Personal Information : If you do not want your personal and professional information to be retained in our database, please send your request for data removal to [e-mail] .