Data Architect (Lakehouse / Warehousing)

Job Description

Job Description:\n\nCompany Description ProSidian is a Management And Operations Consulting Services firm that focuses on providing value to clients through tailored solutions based on industry-leading practices. ProSidian provides enterprise services/solutions for Risk Management | Compliance | Business Process | IT Effectiveness | Engineering | Environmental | Sustainability | Human Capital. We help forward-thinking clients solve problems and improve operations. Launched by Management Consultants, our multidisciplinary teams bring together the talents of global professionals to complete a wide range of engagements for public and private, defense and civilian government, and non-profit organizations. Our solution-centric services are deployed across the enterprise, target drivers of economic profit (growth, margin, and efficiency), and are aligned at the intersections of assets, processes, policies, and people delivering value. See Link To the ProSidian website at Description ProSidian Seeks a Data Architect (Lakehouse / Warehousing) | Human Capital Technology Support - HR Tech Modernization [NSF0052052] for Program Support on a Exempt W2: No Overtime Pay Basis located in the Mid Atlantic Region and listed under a Data Architect Labor Category as a Engagement Team Mid Level Professional aligned under services related to NAICS: 541611 - Management and Financial Consulting, Acquisition and Grants Management Support, and Business Program and Project Management Services - DPLH Est.: 1920 Hrs. ST | 0 Hrs. OT on a Exempt W2: No Overtime Pay Contract Contingent Basis, generally located across the Alexandria, VA (Hybrid) Across The Mid Atlantic Region supporting a Human Capital Analytics & IT Modernization for Federal science agency HR modernization The Data Architect (Lakehouse / Warehousing) | Human Capital Technology Support - HR Tech Modernization [NSF0052052] is aligned with GSA Labor Category: Data Architect. We seek Data Architect (Lakehouse / Warehousing) | Human Capital Technology Support - HR Tech Modernization [NSF0052052] candidates with relevant Government And Public Services Sector Experience (functional and technical area expertise also ideal) to support professional services engagement for Government And Public Services Sector Clients such as NSF. 0 JOB OVERVIEW Provide services and support as a Data Architect (Lakehouse / Warehousing) [Business Analytics Support: HR Technology Ecosystem, And Enterprise-Wide Decision-Making Capabilities Enhancement] in the Government And Public Services Industry Sector focusing on HC | Human Capital Solutions for clients such as National Science Foundation (NSF | OCHCO / OCIO) | Office of the Chief Human Capital Officer (OCHCO) / Office of the Chief Information Officer (OCIO) Generally Located In Alexandria, VA (Hybrid) and across the Mid Atlantic Region (Of Country/World) Working Hybrid On/Off Client Site. Deliver innovative solutions that improve operational efficiency through digital transformation and process automation; enhance data-driven decision-making using role-based advanced analytics and business intelligence; support regulatory compliance and adherence to federal human capital management policies; facilitate seamless integration of IT systems and workforce planning tools; optimize service delivery through performance-based outcomes and SLAs. HR Tech Modernization: Integration and automation of HR workflows using enterprise software solutions, including ServiceNow and SAP NS2 SuccessFactors. Consultative expertise in determining the most appropriate data system architecture, such as data warehouses, data lakes, and data lake houses. Technical understanding of migrating data from the current data system architecture to the upgraded data system architecture. Familiarity with FEDRAMP compliant data architecture platform providers such as Databricks and Snowflake is desired. RESPONSIBILITIES AND DUTIES - Data Architect (Lakehouse / Warehousing) | Human Capital Technology Support - HR Tech Modernization [NSF0052052] Deliver innovative solutions that improve operational efficiency through digital transformation and process automation; enhance data-driven decision-making using role-based advanced analytics and business intelligence; support regulatory compliance and adherence to federal human capital management policies; facilitate seamless integration of IT systems and workforce planning tools; optimize service delivery through performance-based outcomes and SLAs. HR Tech Modernization: Integration and automation of HR workflows using enterprise software solutions, including ServiceNow and SAP NS2 SuccessFactors. Consultative expertise in determining the most appropriate data system architecture, such as data warehouses, data lakes, and data lake houses. Technical understanding of migrating data from the current data system architecture to the upgraded data system architecture. Familiarity with FEDRAMP compliant data architecture platform providers such as Databricks and Snowflake is desired. Data Architect (Lakehouse / Warehousing) Candidates work to facilitate Human Capital Technology Support - HR Tech Modernization delivering Human Capital Technology Support - HR Tech Modernization through Structure the data | modernize the platform | create the foundation for analytics at scale.. Further, they Design and guide implementation of enterprise data architecture supporting HR modernization, including warehousing, lake, and Lakehouse patterns. Assess current-state data environments, define target-state models, support migration planning, and align architectural choices with reporting, analytics, interoperability, and compliance requirements. Data Architect (Lakehouse / Warehousing) Professionals typically cover HR Tech Modernization Functional Area / Swim Lane / Category Disciplines and serve as Senior lead/architect/manager scope with enterprise influence, independent judgment, and responsibility for cross-functional delivery or strategy.. They Define target-state architecture, design standards, and implementation patterns for HR Tech Modernization; translate mission and user requirements into scalable, secure, compliant solutions and guide technical decisions. The role(s) are located in the Mid Atlantic Region, at or near Alexandria, VA (Hybrid). Initially identified Work Site Address (Working Hybrid On/Off Client Site: 401 Dulany Street Randolph Building Alexandria, VA 22314Qualifications Desired Qualifications For Data Architect (Lakehouse / Warehousing) | Human Capital Technology Support - HR Tech Modernization [NSF0052052] (NSF0052052) Candidates: 8+ years of experience in data architecture, enterprise data design, and modernization planning, including structured and semi-structured data environments. Experience with federal data constraints and modern cloud data platforms preferred. Education / Experience Requirements / Qualifications Bachelor’s degree in computer science, information systems, data engineering, or related field required; advanced degree or cloud/data certifications preferred. 8+ years of experience in data architecture, enterprise data design, and modernization planning, including structured and semi-structured data environments. Experience with federal data constraints and modern cloud data platforms preferred. Skills Required Primarily focused on Management and Financial Consulting, Acquisition and Grants Management Support, and Business Program and Project Management Services initiatives and aligned with Program Support activities Human Capital Technology Support - HR Tech Modernization Functional Area Activities. Data architecture, data warehousing, data lakes, Lakehouse design, data modeling, migration planning, metadata strategy, analytics enablement Competencies RequiredSystems thinking, technical judgment, planning, problem solving, collaboration, communication Ancillary Details Of The RolesPrimary artifacts include conceptual and logical data models, migration sequencing plans, source-to-target mapping approach, and platform option assessments.Standard Skills Required: Proficiency in project management methodologies and tools. | Exceptional leadership and interpersonal skills for effective team management. | Outstanding time management and prioritization abilities to meet project milestones. | Adaptability to changing project requirements and priorities | Ability to multi-task and pay close attention to detail. | Excellent analytical, organizational and time management skills | Strong communication skills, both oral and written.EEO Statement: We attract the best people in the industry, supporting their efforts to learn and grow. We strive to create a challenging and progressive work environment. We Provide career opportunities spanning various disciplines and geographic locations, with projects that our employees plan, design, build, and operate as diverse as the needs of our clients.Ful Time Regular VISA Sponsorship: NoWe will not support sponsorship, i.e., H-1B or TN Visas for this position. U.S. Citizenship Required You must be a United States CitizenBackground Check And Drug testing: ProSidian reserves the right to require background checks, including criminal, employment, education, licensure, etc. as well as credit and motor vehicle when applicable for certain positions. In addition, ProSidian may conduct drug testing for designated positions. Other Details Role should be familiar with migration and target-state design considerations involving modern platforms such as Databricks and Snowflake in compliance-conscious environments. #TechnicalCrossCuttingJobs #Government And Public Services #Jugaad #Copitas #AskWhy #Zakat #PokaYoke #AskidaEmekAdditional Information As a condition of employment, all employees must meet the requirements of their roles: establish, manage, pursue, and achieve annual goals and objectives with Documented Goals for each of the firm's Eight ProSidian Global Competencies [1 - Personal Effectiveness | 2 - Continuous Learning | 3 - Leadership | 4 - Client Service | 5 - Business Management | 6 - Business Development | 7 - Technical Expertise | 8 - Innovation & Knowledge Sharing (Thought Leadership)]; and support all business development and other efforts on behalf of ProSidian. Eight ProSidian Global CompetenciesPersonal Effectiveness – The ability to manage tasks, time, and relationships efficiently, achieving consistent, impactful results.Continuous Learning – Ongoing pursuit of knowledge, skills, and adaptability to remain relevant, competent, and professionally competitive.Leadership – Inspiring, guiding, and motivating others toward shared goals, fostering accountability, collaboration, and strategic organizational success.Client Service – Delivering responsive, high-quality solutions that address client needs, build trust, and strengthen long-term partnerships.Business Management – Coordinating people, processes, and resources to achieve strategic objectives, operational efficiency, and sustainable organizational performance.Business Development – Identifying, pursuing, and securing growth opportunities through strategic relationships, market insight, and innovative solutions.Technical Expertise – Applying specialized knowledge, analytical skills, and practical experience to solve complex problems with accuracy.Innovation & Knowledge Sharing (Thought Leadership) – Generating creative solutions, sharing insights, and influencing industry direction through expertise, collaboration, and continuous improvement. ------------ --------------- ------------ OTHER REQUIREMENTSBusiness Tools – understanding and proficiency with business tools and technology, including Microsoft Office. The ideal candidate is advanced with Excel, Access, Outlook, PowerPoint, and Word, proficient with Adobe Acrobat, data analytic tools, and Visio, and the ability to quickly learn other tools, as necessary.Commitment - to work with intelligent, interesting people with diverse backgrounds to solve the most significant challenges across private, public, and social sectors.Curiosity – the ideal candidate exhibits an inquisitive nature and the ability to question the status quo among a community of people they enjoy and teams that work well together.Humility – exhibits grace in success and failure while doing meaningful work where skills have an impact and make a difference.Willingness - to constantly learn, share, and grow and to view the world as their classroom. ------------ --------------- ------------ BENEFITS AND HIGHLIGHTS ProSidian Employee Benefits and Highlights - Your health and well-being are crucial to ProSidian. At ProSidian, we invest in our employees to help them maintain their health and achieve work-life balance. We are pleased to offer the Employee Benefits Program, designed to promote your health and personal well-being. Our growing list of benefits currently includes the following for Full-Time Employees:Competitive Compensation: The pay range is competitive and includes group health benefits, pre-tax employee benefits, and performance incentives. The company contributes a fixed dollar amount each month toward the plan chosen for medical and dental benefits, with contributions deducted on a pre-tax basis.Group Medical / Dental / Vision Health Insurance Benefits: ProSidian partners with network providers to offer eligible employees a variety of medical and dental plans, including high-deductible health plans and PPOs. ProSidian also provides plans for both high and low vision..401(k) Retirement Savings Plan: The 401(k) Retirement Savings Plans allow eligible employees to save for retirement. A variety of investment options are available, along with support from a personal financial planner. The plan operates as a pre-tax Safe Harbor 401(k) Retirement Savings Plan that includes a company match.Vacation and Paid Time-Off (PTO) Benefits: Eligible employees can use PTO for vacations, doctor's appointments, or personal events. These benefits include 2 weeks of vacation, 3 sick days, 10 ProSidian holidays, and government holidays..Pre-Tax Payment Programs: Pre-Tax Payment Programs are premium-only plans (POPs) that provide eligible employees with a comprehensive Flexible Spending Account (FSA) Plan and associated tax benefits.Purchasing Discounts & Savings Plans: We aim for your financial success; thus, we offer a Purchasing Discounts and Savings Plan through the Corporate Perks Benefit Program. This program provides special discounts to eligible employees on everyday purchases of products and services.Security Clearance: Due to the nature of our consulting engagements, a security clearance is necessary for engagement teams managing sensitive work in the Federal Marketplace. Security clearance is a valuable asset in your professional portfolio, enhancing your credentials.ProSidian Employee & Contractor Referral Bonus Program: ProSidian can offer up to $5,000 for referrals who stay