Lead Cloud Data Engineer

Washington, DC, United States

Join us and make a difference in global investor protection.

Who We Are

The Public Company Accounting Oversight Board (PCAOB), a nonprofit organization established by Congress, oversees the audits of public companies and SEC-registered brokers and dealers to protect investors and to further the public interest in the preparation of independent, accurate, and informative audit reports.

Our investor protection mission is focused on modernizing audit standards, enhancing audit inspections, and strengthening enforcement of PCAOB rules and standards and other related laws and rules. People are at the heart of our mission at the PCAOB. As we carry out that mission, we strive to uphold the highest standards in audit quality with investors’ families, savings, and futures in mind.

We are hiring mission-driven professionals interested in a career with purpose, competitive benefit offerings, and work-life flexibility. If you are interested in working with a diverse group of talented professionals to protect investors and drive audit quality and innovation while adhering to the highest standards of ethical and professional conduct, join us.

What We Offer

At the PCAOB, we offer a highly competitive compensation and benefits package with a focus on the health and financial well-being of our valued team members. Some of the features of our comprehensive Total Rewards package include:

Compensation – We support transparency, equity, and fairness in our compensation programs and provide a reasonable estimate of the salary range, based on data-driven market analysis, for each job posting. While it is not typical for an individual to be hired at or near the top of the range, a reasonable estimate of the salary range for this role in Washington, DC (Headquarters) is $153,600 - $224,000. Team members may also be eligible for performance-based discretionary awards.

Hybrid work option – Staff will be assigned to the Washington, DC (Headquarters) office. Staff can choose to live and work from anywhere within the United States but will be required to commute to their assigned office or location for occasional intentional gatherings or meetings at the frequency required by their supervisor. Travel to an assigned office or location for commuting purposes will not be considered reimbursable business travel, unless otherwise required by state law. Business travel is reimbursable in an amount not exceeding the cost to travel from the assigned office or location, unless otherwise required by state law.

Generous paid time off – Up to 6 weeks annually, in addition to 12 federal holidays, 2 floating holidays, and a year-end break from December 25 –31, 2024

Highly competitive 401(k) matchand savings options – Immediate vesting and contributions matched dollar for dollar, up to 7 percent of eligible compensation. Roth in-plan conversion available.

Comprehensive and competitive health benefit offerings – Medical, dental, and vision plans

Supportive paid family leave benefits – Up to 16 weeks paid parental leave and up to 16 weeks paid caregiver leave

Life insurance benefits – Basic life and AD&D insurance provided; supplemental insurance also available

Education benefits – PCAOB staff qualify for the Public Service Loan Forgiveness (PSLF) program. We also offer student loan repayment assistance, staff college tuition assistance, and college coach program support.

Well-being and family resources– Mental health and well-being resources, paid volunteer time, emergency child/adult dependent back-up care services, family-forming assistance, discounted gym memberships, employee assistance program (EAP), health advocate program, and more

Commuter benefits – Tax-free employer subsidy and pretax employee deductions

Role Summary

The PCAOB has a full-time position as a Lead Cloud Data Engineer in the Office of Economic and Risk Analysis (OERA). This role will be responsible for designing, building, and integrating data from various sources and managing the data. Additionally, the role will be responsible for developing, constructing, testing, and maintaining data architectures.

Responsibilities

Collaborate with the Office of the Chief Operating Officer – Office of Data, Security, & Technology (OCOO-ODST) to develop conceptual, logical, and physical data models to support data analysis and business intelligence.

Work with Solution Architects and other technical subject matter experts to develop high-level solutions for OERA’s research needs.

Convey key architecture requirements and implications to the OCOO-ODST architectural governance team.

Drive analytics projects in collaboration with cross-functional teams to inform, influence, and support PCAOB data analytics.

Participate in detailed solution design sessions for data projects and review final solutions to ensure alignment with the PCAOB’s data architecture.

Develop data and metadata documentation for structural design and development.

Work with senior business stakeholders to secure strong engagement for solutions and ensure that the delivery of the project aligns with long-term strategic roadmaps.

Develop all aspects of ETL processes necessary to deliver data and analytic outputs; i.e., data loading, cleansing, storing, quality, transformation, and extraction.

Actively participate in data extraction, data analysis, data profiling, and data testing activities.

Acquire and extract primary or secondary data from internal or external sources and transfer into the data warehouse environment.

Identify data and data relationships that are meaningful to address business issues.

Identify, analyze, and interpret trends or patterns in complex, large datasets using tools available to the team.

Perform statistical analyses on predictive analytical models used for projects and reports.

Identify opportunities where predictive data analytics models would provide the greatest benefits for the organization.

Effectively communicate complex findings on data into actionable and understandable results for high-level discussions with management.

Qualifications

Education/Technical Expertise

Bachelor’s degree in computer science, information systems, or a related field.

Minimum of 7 years of experience in data warehousing, data modeling, data analytics, and cloud computing.

Deep knowledge of data management, data integration, and database development techniques.

Experience with database technologies (e.g., SQL, NoSQL, SQL Server, DataBricks).

Expert understanding of architectural strategies for data modeling/AI, design to meet stated requirements for data management.

Knowledge of Python and/or R and experience with SAS or SQL.

Familiarity with ETL, cloud and business intelligence tools: Azure, Azure Synapse Analytics, Azure ML, Informatica ETL, and PowerBI.

A self-starter able to administer a number of open, ongoing assignments at any one time, where some assignments are routinely unstructured, requiring autonomy and independent judgment.

Ability to clearly articulate a position with sound logic, supporting empirical evidence, and impartiality.

Ability to effectively represent OERA to a variety of internal and external constituencies.

Exceptional interpersonal and communication skills, including teamwork, facilitation, and negotiation.

Strong leadership and team management skills.

Preferred Qualifications

Familiar with agile methods and processes and capable of supporting agile project teams by providing advice and guidance on opportunities, impact, and risks.

Professional certification in data science or analytics.

Equal Employment Opportunity

All PCAOB employees are entitled to equal opportunity and a professional work environment, free of discrimination and harassment. A workplace free of discrimination and harassment is fundamental to professional success and to the PCAOB's mission. The PCAOB will consider for employment all qualified applicants with criminal histories in a manner consistent with applicable law.

#J-18808-Ljbffr