Data Engineer- SQL/Python (Part Time)

Knoventrix Technologies; United States; Remote; USD 110,000 - 150,000; Full time

Job summary

Knoventrix Technologies is seeking a skilled Data Engineer to develop and optimize SQL queries, implement robust ETL workflows, and collaborate with analysts and BI teams to translate requirements into scalable solutions.

You will work on data warehousing concepts, performance tuning, and architecture design while mentoring junior developers in SQL best practices.

Qualifications

• Strong proficiency in T-SQL and experience with MSSQLServer or AzureSQL Database or Snowflake preferred.
• Hands-on experience with ETL tools (SSIS, ADF, Talend, Fivetran etc.).
• Good understanding of data warehousing concepts, datamodeling (star/snowflake schemas), and performance tuning techniques.
• Familiarity with version control systems (Git, Azure DevOps) and CI/CD for database deployment.
• Experience working in agile or cross-functional teams.

Responsibilities

• Develop and maintain optimized SQL queries, stored procedures, views, and functions to support business applications and reporting.
• Design, implement, and automate ETL workflows using tools like SSIS, Azure Data Factory, or scripting languages (Python, PowerShell, etc.) for data integration across multiple sources.
• Collaborate with data analysts, BI developers, and business stakeholders to translate business requirements into scalable and maintainable technical solutions.
• Perform query tuning and database performance optimization to ensure high efficiency, low latency, and optimal resource usage.
• Contribute to data modeling and architecture design, ensuring best practices for normalization, indexing, and data integrity.
• Conduct peer reviews and ensure adherence to coding standards, version control, and documentation practices.
• Mentor and guide junior developers, fostering growth in SQL development, performance tuning, and database design principles

Skills

T-SQL

MSSQL

Azure SQL

Snowflake

ETL Tools

SSIS

Azure Data Factory

Talend

Fivetran

Data Warehousing

Data Modeling

Performance Tuning

Git

Azure DevOps

CI/CD

Agile

Cross-functional Teams

Tools

ETL Tools

Job description

Roles and Responsibilities

• Develop andmaintainoptimizedSQLqueries, stored procedures, views, and functions to support business applications and reporting.
• Design, implement, and automate ETL workflowsusing tools like SSIS, AzureDataFactory, or scripting languages (Python, PowerShell, etc.) fordataintegration across multiple sources.
• Collaborate withdataanalysts, BIdevelopers, and business stakeholdersto translate business requirements into scalable and maintainable technical solutions.
• Perform query tuning anddatabase performance optimizationto ensure high efficiency, low latency, andoptimalresource usage.
• Contribute todatamodelingand architecture design, ensuring best practices for normalization, indexing, anddataintegrity.
• Conduct peer reviewsand ensure adherence to coding standards, version control, and documentation practices.
• Mentor and guide juniordevelopers, fostering growth inSQLdevelopment, performance tuning, anddatabase design principles

Preferred Skills:

• Strongproficiencyin T-SQLand experience with MSSQLServeror AzureSQL Database orSnowflake preferred.
• Hands-on experience with ETL tools(SSIS, ADF, Talend,Fivetranetc.).
• Good understanding of datawarehousing concepts, datamodeling(star/snowflake schemas), and performance tuning techniques.
• Familiarity with version control systems(Git, Azure DevOps) and CI/CD fordatabase deployment.
• Experience working in agile or cross-functional teams.