Part Time Senior Data Warehouse Architect and Data Platform Subject Matter Expert (SME)
Responsibilities
We are seeking a Part Time Senior Data Warehouse Architect and Data Platform Subject Matter Expert (SME) to lead the design, implementation, administration, and optimization of enterprise data warehouse and analytics platforms. The successful candidate will possess extensive experience in data architecture, database administration, ETL development, data modeling, analytics, and large-scale MPP database environments. This qualified individual will work 30 hours a week LOE.
Responsibilities & Qualifications
- Design, develop, and support enterprise Data Warehouse solutions supporting both OLTP and analytical workloads.
- Architect logical and physical data models utilizing Kimball Dimensional, Inmon Normalized, and relational modeling methodologies.
- Define and implement enterprise data architecture standards, governance practices, and best practices.
- Administer, support, and optimize Greenplum, Teradata, PostgreSQL, SQL Server, Oracle, IBM DB2, and related database platforms.
- Serve as Subject Matter Expert (SME) for Greenplum MPP Database and Data Computing Appliance (DCA) environments.
- Lead database performance tuning, capacity planning, backup/recovery, disaster recovery, and high-availability initiatives.
- Design, develop, and optimize ETL and data integration solutions using Informatica PowerCenter, DataStage, Ab Initio, PowerMart, Microsoft DTS, ETI, Data Junction, or similar enterprise tools.
- Develop automation and operational solutions using Python and Bash scripting.
- Support enterprise reporting, analytics, and business intelligence initiatives utilizing Business Objects, MicroStrategy, Crystal Reports, Microsoft Reporting Services, Brio, QMF, and similar platforms.
- Collaborate with business stakeholders to gather requirements, facilitate JAD sessions, and translate business needs into scalable technical solutions.
- Lead data platform modernization, migration, and optimization projects.
- Provide technical leadership, mentoring, and guidance to architects, developers, database administrators, and project teams.
- Troubleshoot complex database, ETL, reporting, and infrastructure issues across enterprise environments.
- Work effectively within Linux (RHEL), Unix, Windows Server, and IBM Mainframe environments including z/OS, OS/390, MVS, and VM.
- Support SAS Analytics and advanced analytical platforms to enable enterprise reporting and decision-making capabilities.
- Maintain documentation, architecture standards, operational procedures, and technical best practices.
Qualifications
Required Experience
- Bachelor’s degree and 8 years of experience or 12 years with a High school diploma/equivalent
- 8+ years of experience in Data Warehousing, Data Architecture, Database Administration, Data Engineering, or related disciplines.
- Extensive experience with large-scale data warehouse implementations and enterprise analytics platforms.
- Strong expertise in SQL development, query optimization, and database performance tuning.
- Hands-on experience with Greenplum, Teradata, PostgreSQL, SQL Server, Oracle, and/or IBM DB2 databases.
- Strong data modeling expertise including dimensional, normalized, logical, and physical modeling techniques.
- Experience with enterprise ETL and data integration tools.
- Advanced Python and Bash scripting skills.
- Experience leading technical projects and working directly with business and executive stakeholders.
- Excellent analytical, communication, problem-solving, and documentation skills.
- Must be a US Citizen.
- Ability to obtain or maintain the required agency clearance.
Preferred Experience
- Active Public Trust Clearance.
- Experience supporting Greenplum Data Computing Appliance (DCA) environments.
- Consulting or professional services experience.
- Project management or technical leadership experience on large-scale enterprise initiatives.
- Experience with cloud-based data warehouse and analytics platforms.
- Experience supporting federal government or highly regulated environments
Peraton Overview
Peraton is a next-generation national security company that drives missions of consequence spanning the globe and extending to the farthest reaches of the galaxy. As the world’s leading mission capability integrator and transformative enterprise IT provider, we deliver trusted, highly differentiated solutions and technologies to protect our nation and allies. Peraton operates at the critical nexus between traditional and nontraditional threats across all domains: land, sea, space, air, and cyberspace. The company serves as a valued partner to essential government agencies and supports every branch of the U.S. armed forces. Each day, our employees do the can’t be done by solving the most daunting challenges facing our customers. Visit peraton.com to learn how we’re keeping people around the world safe and secure.