Data Architect

Company: Public Company Accounting Oversight Board
Location: Washington
Posted on: February 1, 2025

Job Description:

Join us and make a difference in global investor protection.Who We AreThe 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 OfferAt 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 $157,400 - $229,600 per year. 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.
• Generous paid time off - Up to 6 weeks annually, in addition to 12 federal holidays, 2 floating holidays, and a year-end break in December 2025.
• Highly competitive 401(k) match and 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 SummaryThe PCAOB has a full-time position as a Data Architect in the Office of Chief Operating Officer - Office of Technology (OCOO-OT). This role will be responsible for creating the architecture and blueprints for building modern cloud-based data systems and capabilities that align with business strategy and technology standards while ensuring data security and compliance.Responsibilities
• Collaborate with PCAOB Divisions and Offices to translate business requirements into practical data solutions, including the design of databases, data flows, and data storage systems.
• Create procedures to ensure data accuracy and accessibility by establishing and implementing data management processes for efficient data handling.
• Establish processes and procedures to support the rationalization of data sources to reduce data replication and silos.
• Define Data Architecture Framework, considering security, reference data, metadata, and master data.
• Research Data Acquisition Opportunities; stay informed about data sources and emerging technologies.
• 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 alignment with long-term strategic roadmaps.
• Develop all aspects of ETL processes necessary to deliver data and analytic outputs, including data loading, cleansing, storing, quality, transformation, and extraction.
• Identify data and relationships that address business issues.
• Analyze and interpret trends in complex, large datasets using available tools.
• Effectively communicate complex findings into actionable results for high-level discussions with management.QualificationsEducation/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, integration, migration, and development techniques.
• Hands-on experience with database technologies (e.g., Azure Analytics Services, SQL, NoSQL, SQL Server, Databricks).
• Expert understanding of architectural strategies for data modeling and preparation for AI.
• Deep hands-on expertise in SQL, Python, and/or R; experience with SAS or Stata.
• Familiarity with ETL tools and platforms: Azure, Azure Synapse Analytics, Azure ML, Azure Data Factory, Informatica ETL, and PowerBI.
• A self-starter able to manage several ongoing assignments, requiring autonomy and independent judgment.
• Ability to articulate a position with sound logic and supporting empirical evidence.
• Ability to effectively represent OCOO-OT to internal and external constituencies.
• Exceptional interpersonal and communication skills, including teamwork, facilitation, and negotiation.
• Strong leadership and team management skills.
• Must be legally authorized to work in the United States without the need for employer sponsorship.Preferred Qualifications
• Familiar with agile methods and capable of supporting agile project teams.
• Professional certification in data science or analytics.All PCAOB employees are entitled to equal opportunity and a professional work environment, free of discrimination and harassment. The PCAOB will consider for employment all qualified applicants with criminal histories in a manner consistent with applicable law.#LI-HybridAbout UsThe PCAOB will be a trusted leader that promotes high quality auditing through forward-looking, responsive, and innovative oversight. At all times, we will act with integrity, pursue excellence, operate with effectiveness, embrace collaboration, and demand accountability.
  #J-18808-Ljbffr

Keywords: Public Company Accounting Oversight Board, Annandale , Data Architect, Accounting, Auditing , Washington, Virginia