Talent.com
Senior SQL and Power BI Developer
Senior SQL and Power BI DeveloperTech Providers, Inc. • CA - Downey, US
Senior SQL and Power BI Developer

Senior SQL and Power BI Developer

Tech Providers, Inc. • CA - Downey, US
Hace más de 30 días
Tipo de contrato
  • Temporal
Descripción del trabajo
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.
Crear una alerta de empleo para esta búsqueda

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

Ofertas similares

EA-DE IT O-SAP MDG Team Lead

SMX Services & Consulting, Inc.Brea, California, US
A tiempo completo

Please read the information in this job post thoroughly to understand exactly what is expected of potential candidates.We are seeking an experienced SAP MDG Techno-Functional Consultant to design, ...Mostrar más

 • Oferta promocionada

Senior Analyst/Shift Lead

DynamisSanta Ana, CA, United States
A tiempo completo

Dynamis is seeking a Senior Analyst/Site Lead that will assist the Program Manager (PM) with supervising contractor personnel at each site and manage all site-specific workloads, while serving as a...Mostrar más

 • Oferta promocionada

Senior Business Intelligence Analyst

JLLROSEMEAD, CA, CA, United States
A tiempo completo

This job is with JLL, an inclusive employer and a member of myGwork – the largest global platform for the LGBTQ+ business community.Please do not contact the recruiter directly.JLL empowers you to ...Mostrar más

 • Oferta promocionada

Senior Analytics Engineer

HarnhamCosta Mesa, California, US
A tiempo completo

If you are considering sending an application, make sure to hit the apply button below after reading through the entire description.This role is for builders who think in systems not dashboards.You...Mostrar más

 • Oferta promocionada

Senior DBA

SmartFinancialNewport Beach, CA, US
A tiempo completo
Quick Apply

Join SmartFinancial- Empowering Insurers with Cutting-Edge Technology.Welcome to SmartFinancial, where innovation meets impact.Our mission is simple: help insurance agencies and carriers grow faste...Mostrar más

Operating Engineer Data Center - Union

JLLIrvine, CA, CA, United States
A tiempo completo

This job is with JLL, an inclusive employer and a member of myGwork – the largest global platform for the LGBTQ+ business community.Please do not contact the recruiter directly.JLL empowers you to ...Mostrar más

 • Oferta promocionada

Healthcare-Focused Business Analyst (BSA) - Agile & SQL

USMOrange, California, United States
Temporal

A rapidly growing IT services company in California is urgently seeking a Business Analyst with healthcare experience for a 12+ month contract.The role requires at least 7 years in business systems...Mostrar más

 • Oferta promocionada

OneStream Senior Consultant

DeloitteCosta Mesa, CA, United States
A tiempo completo

Senior Consultant, Finance Transformation.Finance leaders face rapid change driven by AI, market uncertainty, and evolving regulations.Deloitte helps clients navigate this complexity with deep indu...Mostrar más

 • Oferta promocionada

The Strategy Group: Data and Field Manager

ArenaPasadena, CA, United States
A tiempo completo

Data and Field Manager The Strategy Group.The Data and Field Manager will oversee the design, execution, and evaluation of voter contact and data-driven organizing programs for clients during the 2...Mostrar más

 • Oferta promocionada

Epic Business Intelligence Developer I, II, III (Open to experienced remote in ID, NE, MO, OK, TX)

PIH HealthWhittier, CA, United States
Teletrabajo
A tiempo completo

The Business Intelligence Developer create analytics content for end users and third parties who require Epic data.The Business Intelligence Developer is critical in transforming healthcare data in...Mostrar más

 • Oferta promocionada

Data Analyst

Behr Process CorporationSanta Ana, California, United States
A tiempo completo

To thrive as a Data Analyst, you'll use a strong analytical approach.You will turn complex data into clear, actionable insights that support hard-working business and sales decisions.In this role, ...Mostrar más

 • Oferta promocionada

EA-DE IT O-SAP MDG Team Lead (Brea)

SMX Services & Consulting, Inc.Brea, CA, United States
A tiempo parcial

We are seeking an experienced SAP MDG Techno-Functional Consultant to design, implement, and support end-to-end Master Data Governance (MDG) solutions.This role focuses on domains such as Material,...Mostrar más

 • Oferta promocionada • Nueva oferta

Data Product Owner / Insurance Domain Lead (Newport Beach)

WinWireNewport Beach, CA, United States
A tiempo parcial

Data Product Owner / Domain Lead.Location: Newport Beach, CA All Days Onsite.FTE first preference - Contract next.Salary: 120k to 140k or 90/hr max including any commission.Visa: All w2 visa, No h1...Mostrar más

 • Oferta promocionada • Nueva oferta

Power Platform Specialist II

Cambro ManufacturingHuntington Beach, California, United States
A tiempo completo

First Shift (United States of America).The Power Platform Specialist II is responsible for designing, configuring, and supporting solutions across the Microsoft ecosystem, with a strong emphasis on...Mostrar más

 • Oferta promocionada

Senior Software Engineer, Data Platform

HarnhamCosta Mesa, California, US
A tiempo completo

Senior / Staff Data Platform Engineer.Costa Mesa, CA (Hybrid — minimum 3 days onsite).Citizen or Green Card holder only.Read all the information about this opportunity carefully, then use the appli...Mostrar más

 • Oferta promocionada • Nueva oferta

Remote Senior Data and Analytics Developer (Azure Data Factory)

Irvine Tech CorpSanta Ana, CA, United States
Teletrabajo
A tiempo completo

Our client is building a modern data environment and they need someone who can hit the ground running.This is a chance to join a core team that has already made major strides moving from old techno...Mostrar más

 • Oferta promocionada

Data Product Owner / Insurance Domain Lead

WinWireNewport Beach, California, US
A tiempo completo

Data Product Owner / Domain Lead.Location: Newport Beach, CA All Days Onsite.FTE first preference - Contract next.Salary: 120k to 140k or 90/hr max including any commission.Visa: All w2 visa, No h1...Mostrar más

 • Oferta promocionada • Nueva oferta

Operational Senior Analyst

AAACosta Mesa, CA, United States
A tiempo completo

As an Operational Senior Analyst, you will work with other Analysts in all the IT Financials from contract requests to the production of the final forecasted and budgeted reports for all I.This rol...Mostrar más