Senior SQL and Power BI DeveloperTech Providers, Inc. • CA - Downey, US
Senior SQL and Power BI Developer
Tech Providers, Inc. • CA - Downey, US
30+ days ago
Job type
- Temporary
Job descriptionA 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. 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. Possess advanced knowledge of SQL, encompassing intricate query optimization techniques, nuanced data manipulation strategies, and a keen ability for fine-tuning database performance. Proficiency extends to crafting queries that operate efficiently even with large datasets, ensuring optimal processing times and minimal resource usage. Demonstrate expertise in working with diverse and popular database management systems such as Oracle, MySQL, SQL Server, and Azure SQL. Proficiency includes database administration, schema design, and the seamless execution of operations across various platforms, showcasing adaptability and proficiency in different environments. 3. Exhibit a strong understanding and extensive experience in Oracle PL / SQL programming. This expertise encompasses the development and optimization of intricate stored procedures, triggers, and functions. Proficiency in PL / SQL ensures the seamless execution of complex tasks, enhancing database functionality and performance. Showcase the ability to design efficient data models that facilitate optimal storage and retrieval of information. Proficiency in creating robust data structures ensures streamlined access to relevant data, enhancing overall database efficiency and reducing query complexity. Demonstrate a comprehensive understanding of Extract, Transform, Load (ETL) processes and tools and scripting languages like Python, Perl, or Shell scripting for automating and data manipulation. Proficiency in integrating data from diverse sources into the database showcases the ability to harmonize disparate datasets, ensuring data consistency, accuracy, and reliability. Exhibit a strong ability to optimize both database queries and underlying structures. Proficiency in query optimization techniques and structural refinements enhances database performance and responsiveness. Skills in identifying and rectifying bottlenecks contribute to streamlined operations. Possess knowledge of data warehousing concepts and tools, enabling effective management of vast volumes of data. Expertise in data warehousing ensures efficient storage, retrieval, and analysis of large datasets, supporting the organization's data-driven decision-making processes. Display proficiency with Power BI, including crafting insightful visualizations and reports that translate raw data into valuable, actionable insights. Demonstrate proficiency in utilizing version control systems like Git to effectively manage and track changes in database scripts and queries. Expertise in version control ensures systematic tracking of modifications, enabling collaboration, maintaining code integrity, and facilitating seamless integration of changes into the database systems. 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. 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. 3 years of experience in the past 4 years working with Providing technical leadership to junior developers, conduct thorough code reviews, offer mentorship, and foster a collaborative environment within the team. 2 years of experience in the past 4 years working with communicating complex technical concepts clearly to both technical and non-technical stakeholders, ensuring a shared understanding of database solutions and their alignment with business objectives. 3 years of experience in the past 4 years working with complex database issues, debugging code, and optimizing queries for peak performance. 2 years of experience building Power BI reports. 2 years of experience in the past 4 years maintaining comprehensive documentation of database schemas, stored procedures, and ETL processes, ensuring knowledge accessibility and smooth transfer within the team. 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. Bachelors in computer science, data analytics, or a related field.
Role : Senior SQL and Power BI Developer
Duration : 12+ months contract
Location : Remote
Note :
- Please note that although the position is 100% remote, the live scan will be conducted onsite at our 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.
Position Description :
Skills Required :
Experience Required :
Education Required :
Create a job alert for this search
Power Bi Developer • CA - Downey, US
Similar jobs
A leading financial services company is seeking an experienced Senior Product Manager – Data to drive product strategy and deliver exceptional user experiences.
This remote role requires over 5 year...Show more
Interested in joining a growing company where you will work with talented colleagues, enhance a supportive and energetic culture, and be part of the climate solution? At Energy Solutions, we focus ...Show more
Job Title : AI Data Analyst Location : Santa Ana, CA - Day 1 Onsite Type : Long Term Contract Role Overview : The AI Data Analyst ...Show more
Job Summary (List Format) Senior Technical Lead Data Engineer - Position : Senior Technical Lead Data Engineer - Openin...Show more
Looking for people to participate in taking online surveys for Fortune 500 brands.All you need to do is complete online surveys by sharing your opinion.
You will help influence brand decisions on se...Show more
Spokeo is a people search engine that helps over 18 million monthly visitors reconnect with friends, reunite with families, and protect against fraud.
Additionally, our 12 billion records and over 2...Show more
Do you want to become a surrogate? .We are now offering a sign on bonus to all qualified and matched surrogates that sign contracts.
The first step is to fill out our surrogate application.A fertili...Show more
Join Opinion Edge today and get paid for your insights! Take short surveys on the topics that matter to you and earn rewards for every completed survey.
Sign up now and start turning your voice into...Show more
The Senior Data Analyst plays a strategic role in driving financial insights, optimizing data processes, and enhancing analytical capabilities across the organization.
This position leads budgeting ...Show more
Vaco is seeking a detail-oriented.This role is ideal for a motivated accounting professional with a strong foundation in general ledger accounting who is eager to grow within a collaborative financ...Show more
The Business Systems team is responsible for building and improving the many systems that enables Anduril to accomplish its mission.
Anduril’s supply chain, accounting, sales & growth, engineering, ...Show more
A company is looking for a Power BI Analyst who will transform raw data into meaningful insights through interactive dashboards and reports.
Key Responsibilities Develop and maintain reports and d...Show more
Fair Labor Standard Act Classification : .Chapman University is required to provide a reasonable estimate of the compensation range for this position.
This range takes into account a variety of factor...Show more
SQL Server Database Administration experience.Extensive experience of managing multiple MS SQL 2008 / 2012 / 2014 / 2016 servers on enterprise-class servers clusters running Windows 2003 / 2008 / 2012.Strong...Show more Vaco Los Angeles is representing a client in search of an experienced.This role ensures accurate, timely, and compliant payroll processing while serving as the subject matter expert for.The ideal c...Show more Culver City, CA- 2 days a week onsite.Temporary 3 months(covering a medical leave; potential to extend).We are partnering with a fast-growing, global technology and entertainment organization to id...Show more 
The Data & Analytics team builds the core data infrastructure that powers Anduril's operations.We design and implement scalable data architectures that model how Anduril functions across the organi...Show more
A leading defense technology company is seeking a Senior Director of Business Development to drive the next generation of edge infrastructure that supports AI-driven operations.Candidates should ha...Show more
Senior Data Product Manager - Remote, Data-Driven Growth
First American Financial Corp. • Santa Ana, CA, United States
Remote
Full-time
Last updated: 10 days ago • Promoted
Senior Data Engineer (Hybrid : Orange, CA - US)
Energy Solutions • Orange, CA, United States
Full-time
Last updated: 8 days ago • Promoted
AI Data Analyst (GCP, Looker, BI)
Diligent Tec Inc • Santa Ana, CA, Santa Ana, USA
Full-time
Last updated: 23 days ago
Lead Data Engineer and Solutions Owner
Expert Technology Services • Anaheim, CA, United States
Full-time
Quick Apply
Last updated: 16 days ago
Online Survey Participant : Work Remote and Earn Up To $25 Per Survey
Earn Haus • Altadena, CA, US
Remote
Full-time +1
Last updated: 10 days ago • Promoted
Senior SEO Data Analyst
Spokeo • Pasadena, California, US
Full-time
Quick Apply
Last updated: 30+ days ago
Women Under 40 : Earn $35,000–$40,000 as a Surrogate
Prime Genetics • Altadena, None, US
Full-time
Last updated: 1 day ago • Promoted
Share Your Opinions. Earn Rewards.
Opinion Edge • Altadena, CA, US
Full-time
Last updated: 1 day ago • Promoted
Senior Data Analyst
99 Ranch Market • Buena Park, California, United States
Full-time
Quick Apply
Last updated: 30+ days ago
Staff Accountant
Vaco by Highspring • Altadena, California, United States
Full-time
Last updated: 30+ days ago • Promoted
Senior Salesforce Software Developer
Anduril • Costa Mesa, California, United States
Full-time
Last updated: 30+ days ago • Promoted
Power BI Analyst
VirtualVocations • Downey, California, United States
Full-time
Last updated: 8 days ago • Promoted
Senior PeopleSoft Developer
InsideHigherEd • Orange, California, United States
Full-time +1
Last updated: 30+ days ago • Promoted
SQL Database Administrator
Two95 International Inc. • Pasadena, CA, US
Full-time
Quick Apply
Last updated: 30+ days ago
Payroll Manager
Vaco by Highspring • Altadena, California, United States
Full-time
Last updated: 30+ days ago • Promoted
Sr Global Benefits Manager
Vaco by Highspring • Altadena, California, United States
Full-time
Last updated: 8 days ago • Promoted
Senior Software Engineer, Data & Analytics
Anduril Industries • Costa Mesa, California, United States
Full-time
Last updated: 30+ days ago • Promoted
Senior Director, Edge Infrastructure & AI Growth
Slope • Costa Mesa, CA, United States
Full-time
Last updated: 4 days ago • Promoted