Senior SQL and Power BI Developer

JRD Systems; Downey (CA); Remote; USD 90,000 - 120,000; Full time

Job summary

A technology solutions provider is seeking a Senior Programmer to design and develop software applications, primarily focusing on data management and the creation of Power BI dashboards. This role requires substantial experience in SQL and database technologies, with a strong emphasis on performance optimization and data integrity. The position is 100% remote with onsite requirements for specific tasks. Ideal candidates will have at least 7 years of experience in IT, including advanced skills in PL/SQL and T/SQL.

Qualifications

• Minimum of 7 years in electronic data processing systems, with 4 years in a lead role.
• Experience developing Power BI dashboards and advanced DAX.
• Proficiency in PL/SQL and T/SQL for database solutions optimization.

Responsibilities

• Design, develop, and optimize applications software.
• Implement and manage database systems and ETL processes.
• Collaborate effectively with stakeholders to deliver insights.

Skills

Complex SQL queries

Database performance optimization

Data integrity assurance

Oracle PL/SQL expertise

Data modeling

Data warehousing

ETL process implementation

Power BI development

Report generation

Education

Bachelor's degree in IT or Engineering

Tools

Oracle

MySQL

SQL Server

Azure SQL

Cognos

Power BI

Crystal Reports

Job description

Senior Programmer

Responsibilities

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

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

Seniority level

Mid-Senior level

Employment type

Contract

Job function

Information Technology

Industries

IT Services and IT Consulting