[Remote] Senior SQL and ETL Engineer

Note: The job is a remote job and is open to candidates in USA. US Tech Solutions is a global staff augmentation firm providing a wide range of talent on-demand and total workforce solutions. They are seeking a Senior SQL and ETL Engineer responsible for leading the design, development, testing, and implementation of complex IT applications, with a focus on SQL and ETL processes. Responsibilities • Lead and/or work on the most complex IT applications design, documentation, development, modification, testing, installation, implementation and support of new or existing applications software • Plan, install, configure, test, implement and manage a systems environment in support of an organization’s IT architecture and business needs • Analyze and refine systems requirements; translating systems requirements into applications prototypes; planning and designing systems architecture; writing, debugging and maintaining code; determining and designing applications architecture • Determine output media/formats; designing user interfaces; working with customers to test applications; assuring software and systems quality and functionality; integrating hardware and software components; writing and maintaining program documentation • Evaluate new applications software technologies; and/or ensure the rigorous application of information security/information assurance policies, principles and practices to the delivery of application software services • Analyze systems requirements in response to business requirements, risks and costs; evaluate, select, verify and validate the systems software environment; evaluate, select and install compilers, assemblers and utilities • Integrate hardware and software components within the systems environment; monitor and fine-tune performance of the systems environment; evaluate new systems engineering technologies and their effect on the operating environment; and/or ensure that information security/information assurance policies, principles and practices are an integral element of the operating environment Skills • Minimum of seven (7) years of experience in electronic data processing systems study, design, and programming • At least four (4) years of that experience must have been in a lead capacity • 3 years of experience in the past 4 years developing and optimizing SQL, PL/SQL, and T-SQL logic, including stored procedures, functions, performance tuning, and advanced relational modeling across Oracle and SQL Server • 3 years of experience in the past 4 years working with mainframe including data extraction, mapping, and conversion into modern ETL/ELT pipelines • 3 years of experience in the past 4 years designing, orchestrating, and deploying ETL/ELT pipelines using Azure Synapse Analytics, Azure Data Factory, SSIS, and Azure DevOps CI/CD workflows • 3 years of experience in the past 4 years building and maintaining enterprise data warehouses using Oracle, SQL Server, Teradata, or cloud data platforms • 3 years of experience in the past 4 years working with big data technologies such as Apache Spark, PySpark, or Hadoop for large-scale data transformation • 3 years of experience in the past 4 years integrating structured and semi-structured data (CSV, XML, JSON, Parquet) and consuming APIs using Python/PySpark • 3 years of experience in the past 4 years developing analytics-ready datasets and supporting business intelligence platforms such as Power BI or Cognos, including writing optimized SQL for reporting • 3 years of experience in the past 4 years performing data cleansing, validation, profiling, and data quality assurance for regulated or audit-sensitive environments • 3 years of experience supporting production ETL operations, troubleshooting pipeline failures, conducting root cause analysis, and ensuring SLAs for daily, monthly, or regulatory reporting workloads • Possession of a bachelor's degree in an IT-related or Engineering field • Knowledge and experience in applications software development principles and methods sufficient to participate in the design, development, testing and implementation of new or modified applications software • Operating systems installation and configuration procedures • Organization's operational environment • Software design principles, methods and approaches • Principles, methods and procedures for designing, developing, optimizing and integrating new and/or reusable systems components • Pertinent government regulations • Infrastructure requirements, such as bandwidth and server sizing • Database management principles and methodologies, including data structures, data modeling, data warehousing and transaction processing • Functionality and operability of the current operating environment • Systems engineering concepts and factors such as structured design, supportability, survivability, reliability, scalability and maintainability • Optimization concepts and methods • Establish and maintain cooperative working relationships with those contacted in the course of the work • Speak and write effectively and prepare effective reports • Strong expertise in SQL, PL/SQL, and T-SQL with advanced query tuning, stored procedure optimization, and relational data modeling across Oracle, SQL Server, PostgreSQL, and MySQL • Proficiency in modern ETL/ELT tools including Azure Synapse Analytics, Azure Data Factory, and SSIS, with the ability to design scalable ingestion, transformation, and loading workflows • Ability to design and implement data warehouse data models (star schema, snowflake, dimensional hierarchies) and optimize models for analytics and large-scale reporting • Strong understanding of data integration, data validation, cleansing, profiling, and end-to-end data quality processes to ensure accuracy and consistency across systems • Knowledge of enterprise data warehouse architecture, including staging layers, data marts, data lakes, and cloud-based ingestion frameworks • Experience applying best practices for scalable, maintainable ETL engineering, including metadata-driven design and automation • Proficiency in Python and PySpark (and familiarity with Shell/Perl) for automating ETL pipelines, handling semi-structured data, and transforming large datasets • Experience handling structured and semi-structured data formats (CSV, JSON, XML, Parquet) and consuming REST APIs for ingestion • Knowledge of data security and compliance practices, including credential management, encryption, and governance in Azure • Expertise in optimizing ETL and data warehouse performance through indexing, partitioning, caching strategies, and pipeline optimization • Familiarity with CI/CD workflows using Git/GitHub Actions for ETL deployment across Dev, QA, and Production environments • Ability to collaborate with analysts and business stakeholders, translating complex requirements into actionable datasets, KPIs, and reporting structures Company Overview • US Tech Solutions counted among the largest yet the fastest growing staffing firm; all achieved organically. It was founded in 2000, and is headquartered in Toronto, Ontario, CAN, with a workforce of 1001-5000 employees. Its website is Company H1B Sponsorship • US Tech Solutions has a track record of offering H1B sponsorships, with 4 in 2025, 9 in 2024, 13 in 2023, 24 in 2022, 18 in 2021, 14 in 2020. Please note that this does not guarantee sponsorship for this specific role. Apply tot his job