Sr Data Engineer

AssureSoft - Careers; United States; Remote; USD 140,000 - 190,000; Full time

Job summary

AssureSoft is seeking a senior data engineer to design and operate scalable data pipelines in a remote-enabled U.S. team.

You will implement ETL/ELT using Python, SQL, and dbt, build ingestion and integration workflows with Airbyte, and optimize Snowflake data warehousing for performance and cost efficiency. You will collaborate with engineers, analysts, and stakeholders, ensuring data quality, monitoring, and robust documentation.

Qualifications

• Senior data engineering experience in production environments.
• Strong Python skills for data processing, automation, and pipelines.
• Advanced SQL for complex transformations and performance tuning.
• Proven ETL/ELT design, development, and maintenance.
• Experience with dbt, Airbyte, Snowflake, and relational databases.

Responsibilities

• Design, build, test, and maintain scalable data pipelines.
• Develop data transformation workflows using Python, SQL, and dbt.
• Create and maintain ingestion, synchronization, and integration pipelines.
• Model, optimize, and query Snowflake data warehouses.
• Ensure data quality, error handling, and pipeline monitoring.
• Troubleshoot failures, perform root cause analyses, and implement fixes.
• Write clean, well-documented code and documentation for SQL transforms.
• Collaborate with engineers, analysts, and stakeholders on data solutions.
• Participate in estimation and development planning, improve performance.
• Adopt CI/CD practices and AI-assisted development tools.

Skills

Senior data engineering

Python for data processing

Advanced SQL

ETL/ELT pipelines

AI-assisted development tools

Education

Senior level data engineering

Tools

dbt

Airbyte

Snowflake

MySQL

Git

CI/CD

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