Senior SQL and Power BI Developer, Downey, CA-100% Remote

Company: Pyramid Technology Solutions, Inc
Location: Downey
Posted on: April 10, 2025

Job Description:

Job Role: Senior SQL and Power BI Developer

Submit your CV and any additional required information after you have read this description by clicking on the application button.

Location: Downey, CA - Remote

Duration: 12 Months Contract



Is this role located on-site, hybrid, or remote?: Remote



Position Description:

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.



Skills Required:

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.



Skills Preferred:

Strong expertise in SQL, relational databases, and data modeling (Oracle, SQL Server, PostgreSQL, MySQL).
Proficiency in Power BI report and dashboard development, including advanced DAX, Power Query, and performance optimization for large datasets.
Hands-on experience with ETL tools: Azure Data Factory, Azure Synapse, SSIS.
Ability to design and implement data warehouse models (star, snowflake schemas, dimension hierarchies).
Skilled in data integration, data transformation, and ensuring data quality and consistency.
Proficiency in scripting languages (Python, Shell, etc.) for ETL automation and data manipulation.
Solid understanding of data warehouse architecture, including data lakes, marts, and staging.
Knowledge of data security, governance, and compliance for handling sensitive data.
Ability to optimize query performance, indexing, and partitioning strategies.
Strong communication skills to gather requirements and deliver impactful insights through user-friendly Power BI reports with row-level security and interactive visuals.



Experience Required:

This classification must have a 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:

3 years of experience in the past 4 years developing interactive dashboards and reports in Power BI, including using DAX for building measures, calculated columns, and time-based analytics.
3 years of experience in the past 4 years writing stored procedures, triggers, and performance-tuned queries using PL/SQL and T/SQL and worked with tools such as SQL*Plus, Oracle SQL Developer, and Oracle Data Integrator, along with SQL Server Integration Services (SSIS) and SQL Server Management Studio (SSMS).
3 years of experience in the past 4 years in working with Oracle and Microsoft SQL database architecture, data preparation, modeling, normalization, performance tuning and optimization for large-scale datasets.
3 years of experience in the past 4 years in working with designing and developing data warehouses using other platforms like Microsoft SQL Server, Oracle and familiarity with data warehousing tools like Azure Synapse.
3 years of experience in the past 4 years in working with data cleansing, data profiling, and data validation techniques to ensure high data integrity in the data warehouse.



Education Required:

This classification requires the possession of a 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.



Education Preferred:

Bachelors in computer science, data analytics, or a related field.
Remote working/work at home options are available for this role.

Keywords: Pyramid Technology Solutions, Inc, Irvine , Senior SQL and Power BI Developer, Downey, CA-100% Remote, IT / Software / Systems , Downey, California