Talent.com
TPI Global (formerly Tech Providers, Inc.)
Senior SQL and Power BI DeveloperTPI Global (formerly Tech Providers, Inc.) • Downey, CA, US
Senior SQL and Power BI Developer

Senior SQL and Power BI Developer

TPI Global (formerly Tech Providers, Inc.) • Downey, CA, US
30+ days ago
Job type
  • Temporary
  • Quick Apply
Job description
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:
  • 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.
  • 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.
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.
  • 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.

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.
  • Bachelors in computer science, data analytics, or a related field.
Create a job alert for this search

Senior SQL and Power BI Developer • Downey, CA, US

Similar jobs

Remote QGIS Expert

Micro1Altadena, California, US
$40.00 hourly
Remote
Full-time

Real-world expertise is turned into training data, evaluations, and feedback loops that improve how models perform.AI labs and enterprises use micro1 to train models and build reliable AI agents th... Show more

 • Promoted

Investment Banking Senior Analyst

Roth Capital Partners, LLCNewport Coast, CA, United States
Full-time

Investment Banking Senior Analyst.Roth Capital Partners, LLC is looking to add an Investment Banking Senior Analyst to our Consumer Team.Roth is a relationship-driven investment bank focused on ser... Show more

 • Promoted

Data Scientist

TradeJobsWorkforce92704 Santa Ana, CA, US
Full-time

Data Scientist Job Duties: Formulates and leads guided, multifaceted analytic studies again... Show more

 • Promoted

Database Administrator

TradeJobsWorkForce92614 Irvine, CA, US
Full-time

Responsibility for the evaluation of database software purchases Supervision of modifications to any existing database software to meet the needs of their employer Responsibility for maintaining th... Show more

 • Promoted

Shift Leader

Bundoo KhanFullerton, CA, US
$20.00 hourly
Full-time

Join the team that’s all about flavor, energy, and opportunity at Kundoo Khan!.Are you a natural leader with a passion for people and a hunger to grow your career? If you’re ready to bring the heat... Show more

Senior Data Analyst | HR & Compensation Team (Remote Southern California)

Veritas Search GroupAltadena, CA, United States
Remote
Full-time

This role requires candidates who are currently authorized to work in the U.C2C arrangements are not accepted.While this role is primarily remote, you must live in Southern California due to occasi... Show more

 • Promoted

Senior Lease Auditor (P1-5202067-1)

Panda ExpressSan Gabriel, CA, United States
Full-time +1

Lease Auditor is responsible for performing a high volume of complex lease audits to ensure Panda is accurately billed.This position prepares clear and comprehensive audit reports, negotiates direc... Show more

 • Promoted

Remote Audit Senior Manager (Digital Assets/Crypto/Exchange/Treasury/Blockchain)

BDO USACosta Mesa, CA, United States
Remote
Full-time

The Assurance Senior Manager is responsible for developing suggestions to improve client internal controls and accounting procedures as well as advising the client on various economic and regulator... Show more

 • Promoted

Project Manager (Oracle ERP) - Remote

Cedars-SinaiHuntington Beach, CA, United States
Remote
Full-time

Job DescriptionGrow your career at Cedars-Sinai!The Enterprise Information Services (EIS) team at Cedars-Sinai understands that true clinical transformation and the optimization of a clinical infor... Show more

 • Promoted

Enterprise Mortgage Analytics & Data Sales Executive (Tier 1 Accounts)(Remote)

27-1538401 First American Data Tree, LLCSanta Ana, CA, United States
Remote
Full-time

Who We AreJoin a team that puts its People First! As a member of First American's family of companies, Data & Analytics is a national provider of property-centric information, analytics, risk m... Show more

 • Promoted

Senior Quantitative Financial Modeler

Pacific LifeNewport Beach, CA, US
$167,670.00 yearly
Full-time

Providing for loved ones, planning rewarding retirements, saving enough for whatever lies ahead – our policyholders count on us to be there when it matters most.It’s a big ask, but it’s one that we... Show more

 • Promoted

Senior Business Analyst

East West BancorpCity Of Industry, CA, United States
Full-time

We are currently seeking a Senior Business Analyst.This position will use business knowledge and analytical skills to provide guidance for development of business strategy.Create monthly reports on... Show more

 • Promoted

Senior Analyst, Proposals & Capture Jobs

Clearance JobsCosta Mesa, CA, United States
Full-time

Anduril Industries is a defense technology company with a mission to transform U.By bringing the expertise, technology, and business model of the 21st century's most innovative companies to the def... Show more

 • Promoted

OneStream Consultant

DeloitteCosta Mesa, CA, United States
Full-time

In an increasingly challenging environment marked by disruptive tech like AI, market uncertainty, and regulatory change, finance and global business services leaders recognize the opportunity to be... Show more

 • Promoted

Senior Staff Software Engineer, API Platform (Remote) - Python

3C Deutschland GmbHCosta Mesa, CA, United States
Remote
Full-time

Senior Staff Software Engineer, API Platform (Remote) - Python Full-time Employee Status :Regular Role Type :Home Job Posting - Salary Range :$133,109 - $239,596 Department :Product Development Fle... Show more

 • Promoted

PeopleSoft Technical / Developer, Sr (Remote in CA)

Irvine Tech CorpAltadena, CA, United States
Remote
Full-time

Location :Remote in CaliforniaCompensation :This job is expected to pay about $154,783 - $188,142 per yearNo Visa Sponsorship Available for this roleWhat You'll Do :Provide hands-on technical exper... Show more

 • Promoted

Senior Business Analyst

Georgia IT, Inc.Baldwin Park, CA, United States
Full-time

Location: Irwindale, CA Duration: 12 months.Locals and GC or Citizens highly preferred.Developing technical solutions to business problems, begins with defining, analyzing and documenting requireme... Show more

 • Promoted

Lead Business Analyst (Capital Markets Domain)

RZS RecruitmentNewport Coast, CA, United States
Full-time

Lead Business Analyst (Capital Markets Domain).Newport Beach, California, United States.Role: Lead Business Analyst (Capital Markets Domain) Location: Newport Beach, California, United States Offic... Show more

 • Promoted

Principal Data Engineer (Remote Work Eligible)

Dimensional Fund AdvisorsCosta Mesa, CA, United States
Remote
Full-time

Job Description :About Dimensional :Dimensional was built around a set of ideas bigger than the firm itself.With a confidence in markets, deep connections to the academic community, and a focus on ... Show more

 • Promoted

Coding Audit Director (Full-Time, Remote)

GeBBS Healthcare SolutionsAltadena, CA, United States
Remote
Full-time

Coding Audit Director (Full-Time, Remote)2 days ago Be among the first 25 applicantsDescriptionDirector - Internal & External Coding Audits GeBBS Healthcare Solutions (Remote, Full-Time)GeBBS H... Show more