JRD Systems · 1 day ago
Senior SQL and ETL Programmer
United States
Contract
Remote
Senior Level
7+ years expJRD Systems is seeking a Senior SQL and ETL Programmer responsible for leading and developing complex IT applications. The role involves designing, implementing, and managing ETL processes, ensuring data quality, and optimizing performance across various database systems.
Information TechnologySoftware
Hiring Manager
Ganesh K
Responsibilities
A Senior Programmer is responsible for leading and/or working on the most complex IT applications design, documentation, development, modification, testing, installation, implementation and support of new or existing applications software
This classification may also plan, install, configure, test, implement and manage a systems environment in support of an organization’s IT architecture and business needs
Common organizational or functional industry position titles for programmers include but are not limited to programmer analyst, applications developer, software engineer, software developer, software quality assurance specialist, systems programmer, systems software programmer, database administrators, computer systems analysts, systems engineer, systems software engineer
The Senior Programmer, in development of applications software, is responsible for analyzing and refining systems requirements; translating systems requirements into applications prototypes; planning and designing systems architecture; writing, debugging and maintaining code; determining and designing applications architecture; determining 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; evaluating new applications software technologies; and/or ensuring the rigorous application of information security/information assurance policies, principles and practices to the delivery of application software services
The Senior Programmer, in development of operating systems, is responsible for analyzing systems requirements in response to business requirements, risks and costs; evaluating, selecting, verifying and validating the systems software environment; evaluating, selecting and installing compilers, assemblers and utilities; integrating hardware and software components within the systems environment; monitoring and fine-tuning performance of the systems environment; evaluating new systems engineering technologies and their effect on the operating environment; and/or ensuring that information security/information assurance policies, principles and practices are an integral element of the operating environment
Qualification
Required
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
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
Possession of a bachelor's degree in an IT-related or Engineering field
Candidate must complete a Live Scan and background check at the Probation headquarters in Downey, CA
Preferred
Candidates local to California are highly preferred
Company
JRD Systems
JRD Systems is an information technology company that provides custom application development and staffing services.
201-500 employees
H1B Sponsorship
JRD Systems has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
2024 (4)
2023 (2)
2022 (3)
2021 (8)
2020 (18)
Funding
Current Stage
Growth StageCompany data provided by crunchbase