Part Time Senior Data Warehouse Architect and Data Platform Subject Matter Expert (SME)
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Tech stack
+30 more
Job description
Enterprise analysis, software tools, and data services to support quantitative reporting and analytical solutions, helping to deliver high-quality data for the customer. Also develops and maintains key data sets, documentation, and analytical tools while offering flexible support for financial and analytical data needs., 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., * 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.
Requirements
- 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
Benefits & conditions
Parental leave, 401(k), Health insurance, Paid time off, Vision insurance, Health savings account, Dental insurance, Life insurance Part-time Remote in Laurel, MD, Target Salary Range: $86,000 - $138,000. This represents the typical salary range for this position. Salary is determined by various factors, including but not limited to, the scope and responsibilities of the position, the individual’s experience, education, knowledge, skills, and competencies, as well as geographic location and business and contract considerations. Depending on the position, employees may be eligible for overtime, shift differential, and a discretionary bonus in addition to base pay.
Benefits Statement: Peraton offers eligible employees a variety of benefits including medical, dental, vision, life, health savings account, short/long term disability, EAP, parental leave, 401(k), paid time off (PTO) for vacation, and company paid holidays. A full listing of available benefits can be viewed at https://www.careers.peraton.com/benefits.
About the company
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 solve the most daunting challenges that our customers face. Visit peraton.com to learn how we’re keeping people around the world safe and secure.
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Talks and stories from around this role — technically off-topic, practically not.
Moments
Explore playlistsVideos
See allRelated articles
See all
Data Analyst Salary in the UK
How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again
Highest Paying Tech Companies for Developers
Data Engineer Salary UK