Azure Databricks Engineer

Overview

Information Technology at PNNL is a diverse team of computing and technology professionals with a clear mandate to leverage human-centered design to re-imagine how digital technologies can improve the research experience, enable data-driven insights for decision makers, enhance the efficiency of getting work done at the laboratory, and accelerate PNNL’s scientific discovery.

Come join this talented family of designers, engineers, cyber security experts, analysts, and product managers as they partner with multi-disciplinary teams across the laboratory to advance a bold digital transformation agenda leveraging the latest in cloud architectures, agile, user experiences, and continuous integration / continuous delivery to create the PNNL Digital Workplace.

Responsibilities

We are seeking a skilled Azure Databricks Engineer to join our team and collaborate with internal and external partners in building and maintaining a robust data architecture.

This role is pivotal to the success of data-focused projects by ensuring that users throughout PNNL can easily and reliably access business critical data.

The ideal candidate will have deep expertise in Databricks within the Azure environment and a passion for creating high-performance data solutions.

Collaborate with internal teams and consultants to design and implement a modern data architecture using Azure Databricks.

Develop and maintain data pipelines in Data Factory and Databricks.

Create and maintain data models to support Power BI semantic layers.

Ensure data integration and warehousing needs for ERP systems are met efficiently.

Monitor and optimize data workflows to ensure performance and cost-effectiveness.

Provide technical guidance and support during the migration of data to the new architecture.

Ensure the security and compliance of data solutions in accordance with lab standards.

Create and follow best practices and standards for data engineering, including version control, code reviews, and documentation.

Stay updated with the latest developments in Azure and Databricks technologies and apply them to improve the architecture.

Troubleshoot and resolve issues with data pipelines and workflows.

Provide on-call and off-hours support as needed to ensure the continuous operation of data systems.

Work closely with business analysts and stakeholders to gather requirements and ensure data solutions meet business needs

Qualifications

Minimum Qualifications :

BS / BA and 5 years of relevant experience -OR-

MS / MA or higher and 3 years of relevant experience -OR-

PhD and 1 year of relevant experience -OR-

AA and 14 years of relevant experience -OR-

HS / GED and 16 years of relevant experience

Qualifying software development experience in designing, architecting, programming, deploying, and automating software solutions in support of scientific research or consumer digital product development may be counted

Preferred Qualifications :

Proven experience with Azure Databricks and Data Factory (Azure or Fabric), certifications are a plus (e.g., Databricks Certified Data Engineer Associate / Professional).

Strong understanding of data warehousing principles and ETL processes.

Experience with supporting Power BI use cases.

Proficiency in programming languages such as Python, SQL, and Scala.

Additional Information

Due to business needs and client space, US Citizenship is required.

Pacific Northwest National Laboratory is subject to the Department of Energy Unclassified Foreign National Access Program site, information, technologies, and equipment access requirements.

lgibe

Testing Designated Position

This is not a Testing Designated Position (TDP).

About PNNL

Pacific Northwest National Laboratory (PNNL) is a world-class research institution powered by a highly educated, diverse workforce committed to the values of Integrity, Creativity, Collaboration, Impact, and Courage.

Every year, scores of dynamic, driven people come to PNNL to work with renowned researchers on meaningful science, innovations and outcomes for the U.

S. Department of Energy and other sponsors; here is your chance to be one of them!

At PNNL, you will find an exciting research environment and excellent benefits including health insurance, flexible work schedules and telework options.

PNNL is located in eastern Washington State the dry side of Washington known for its stellar outdoor recreation and affordable cost of living.

The Lab’s campus is only a 45-minute flight (or 3-hour drive) from Seattle or Portland, and is serviced by the convenient PSC airport, connected to 8 major hubs.

Commitment to Excellence, Diversity, Equity, Inclusion, and Equal Employment Opportunity

Our laboratory is committed to a diverse and inclusive work environment dedicated to solving critical challenges in fundamental sciences, national security, and energy resiliency.

We are proud to be an Equal Employment Opportunity and Affirmative Action employer. In support of this commitment, we encourage people of all racial / ethnic identities, women, veterans, and individuals with disabilities to apply for employment.

Pacific Northwest National Laboratory considers all applicants for employment without regard to race, religion, color, sex (including pregnancy, sexual orientation, and gender identity), national origin, age, disability, genetic information (including family medical history), protected veteran status, and any other status or characteristic protected by federal, state, and / or local laws.

We are committed to providing reasonable accommodations for individuals with disabilities and disabled veterans in our job application procedures and in employment.

If you need assistance or an accommodation due to a disability, contact us at careers@pnnl.gov .

Drug Free Workplace

PNNL is committed to a drug-free workplace supported by Workplace Substance Abuse Program (WSAP) and complies with federal laws prohibiting the possession and use of illegal drugs.

If you are offered employment at PNNL, you must pass a drug test prior to commencing employment. PNNL complies with federal law regarding illegal drug use.

Under federal law, marijuana remains an illegal drug. If you test positive for any illegal controlled substance, including marijuana, your offer of employment will be withdrawn.

HSPD-12 PIV Credential Requirement

In accordance with Homeland Security Presidential Directive 12 (HSPD-12) and Department of Energy (DOE) Order 473.1A, new employees are required to obtain and maintain a HSPD-12 Personal Identity Verification (PIV) Credential.

To obtain this credential, new employees must successfully complete and pass a Federal Tier 1 background check investigation.

This investigation includes a declaration of illegal drug activities, including use, supply, possession, or manufacture within the last year.

This includes marijuana and cannabis derivatives, which are still considered illegal under federal law, regardless of state laws.

Mandatory Requirements

Please be aware that the Department of Energy (DOE) prohibits DOE employees and contractors from having any affiliation with the foreign government of a country DOE has identified as a country of risk without explicit approval by DOE and Battelle.

If you are offered a position at PNNL and currently have any affiliation with the government of one of these countries, you will be required to disclose this information and recuse yourself of that affiliation or receive approval from DOE and Battelle prior to your first day of employment.

Rockstar Rewards

Employees and their families are offered medical insurance, dental insurance, vision insurance, health savings account, flexible spending accounts, basic life insurance, disability insurance*, employee assistance program, business travel insurance, tuition assistance, supplemental parental bonding leave , surrogacy and adoption assistance, and fertility support.

Employees are automatically enrolled in our company funded pension plan* and may enroll in our 401k savings plan. Employees may accrue up to 120 vacation hours per year and may receive ten paid holidays per year.

Research Associates excluded.

Once eligibility requirements are met.

Click Here For Rockstar Rewards ()

Notice to Applicants

PNNL lists the full pay range for the position in the job posting. Starting pay is calculated from the minimum of the pay range and actual placement in the range is determined based on an individual’s relevant job-related skills, qualifications, and experience.

This approach is applicable to all positions, with the exception of positions governed by collective bargaining agreements and certain limited-term positions which have specific pay rules.

As part of our commitment to fair compensation practices, we do not ask for or consider current or past salaries in making compensation offers at hire.

Instead, our compensation offers are determined by the specific requirements of the position, prevailing market trends, applicable collective bargaining agreements, pay equity for the position type, and individual qualifications and skills relevant to the performance of the position.

Minimum Salary

USD $124,700.00 / Yr.

Maximum Salary

USD $197,100.00 / Yr.