Job Details

Job Title: Senior SQL and Power BI Developer
Job ID: 810
Duration: 12+ Months (W2 Only)
Location: Downey, CA, 90242 (Remote Role)

Note: Please note that although the position is 100% remote, the live scan will be conducted onsite at our Downey, CA location.

Job Description:

Position Summary
The Senior Programmer is responsible for leading and working on complex IT application design, development, documentation, modification, testing, installation, and support efforts. This role may also involve planning, installing, configuring, testing, and managing systems environments that support the organization's IT architecture and business needs.

Key Responsibilities
Applications Software Development

• Analyze and refine system requirements.
• Translate system requirements into application prototypes.
• Plan and design system architecture.
• Write, debug, and maintain code.
• Determine output formats and design user interfaces.
• Collaborate with customers to test applications.
• Ensure software and system quality and functionality.
• Integrate hardware and software components.
• Develop and maintain program documentation.
• Evaluate and apply new application software technologies.
• Ensure compliance with information security and assurance principles.

• Analyze system requirements based on organizational needs, risks, and cost factors.
• Evaluate, select, verify, and validate systems software environments.
• Install and configure compilers, assemblers, and system utilities.
• Integrate hardware and software components.
• Monitor and optimize system performance.
• Evaluate new systems engineering technologies.
• Ensure information assurance and security practices are followed.

• Strong knowledge of application software development principles and lifecycles.
• Expertise in operating systems installation, configuration, and optimization.
• Understanding of organizational IT environments and infrastructure requirements.
• Proficiency in software design methodologies and reusable system components.
• Knowledge of bandwidth, server sizing, and operational needs.
• Solid understanding of database management, data modeling, data warehousing, and transaction processing.
• Experience with systems engineering concepts: scalability, reliability, supportability, and maintainability.
• Ability to establish effective working relationships.
• Excellent verbal and written communication skills, including report preparation.

• Advanced SQL knowledge including query optimization and performance tuning.
• Experience with Oracle, MySQL, SQL Server, and Azure SQL.
• Strong expertise in Oracle PL/SQL (procedures, triggers, functions).
• Ability to design efficient, scalable data models and structures.
• Experience with ETL processes and scripting languages (Python, Perl, Shell).
• Proven skills in optimizing database structures and queries.
• Knowledge of data warehousing concepts and tools.
• Proficiency with Power BI for reports and visualizations.
• Experience using Git or similar version control tools.

• Minimum 7 years of experience in electronic data processing systems study, design, and programming.
• At least 4 years in a lead capacity.

• 4 years (within past 7) writing complex SQL queries and optimizing performance across multiple databases.
• 3 years (within past 4) developing PL/SQL or similar procedural languages.
• 3 years (within past 4) designing and optimizing database schemas.
• 3 years (within past 4) developing reports using Cognos, Power BI, or Crystal Reports.
• 3 years (within past 4) implementing ETL processes and integrating diverse data sources.
• 3 years (within past 4) providing technical leadership and mentoring.
• 2 years (within past 4) communicating technical concepts to varied audiences.
• 3 years (within past 4) troubleshooting complex database issues and optimizing queries.
• 2 years building Power BI reports.
• 2 years (within past 4) maintaining documentation of schemas, procedures, and ETL processes.

• Bachelor's degree in an IT-related or Engineering field.
• Additional qualifying experience may substitute for education on a year-for-year basis.

• Bachelor's degree in Computer Science, Data Analytics, or a related field.