JRD Systems

Compensation

Full Description

• **ONLY ON W2*** The Senior Programmer will possess 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; and speak and write effectively and prepare effective reports. Experience 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. Experience Preferred 1) 4 years of experience in the past 7 years writing complex SQL queries, optimizing database performance, and ensuring data integrity across various database management systems, including Oracle, MySQL, SQL Server, and Azure SQL. 2) 3 years of experience in the past 4 years working with advanced skills in Oracle PL/SQL or similar procedural languages, adept at developing efficient stored procedures, triggers, and functions for seamless database operations. 3) 3 years of experience in the past 4 years working with designing and optimizing database schemas, ensuring scalability, data normalization, and efficient indexing for high-performance transactional systems. 4) 3 years of experience in the past 4 years working with developing intricate reports and visualizations using tools such as Cognos, Power BI, or Crystal Reports, transforming raw data into meaningful insights for diverse stakeholders. 5) 3 years of experience in the past 4 years working with Implementing robust ETL processes, integrating data from diverse sources into data warehouses flawlessly, ensuring accuracy, consistency, and reliability of data for analytical purposes. Education Required Bachelor’s degree in an IT-related or Engineering field. Additional qualifying experience may be substituted for the required education on a year-for-year basis. Additional Information • Please note that although the position is 100% remote, the live scan will be conducted onsite at Downey HQ location. This position is for developing Power BI dashboards with advanced DAX, data modeling, and performance tuning and a strong SQL expertise in PL/SQL and T/SQL for building and optimizing database solutions.