Databricks Solutions ArchitectStrategic Management Solutions, LLC (SMSI) provides expert management consulting, program and project management, and technical consulting services to government and private sector clients. SMSI has grown and evolved by building an outstanding reputation for client-focused performance and for delivering results that enable clients to meet commitments and milestones. SMSI is an Equal Employment Opportunity employer, all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.Job SummarySMSI LLC is seeking a Databricks Solutions Architect to assist our client, Los Alamos National Laboratory (LANL). This position will be mostly remote, with occasional trips onsite in Los Alamos, NM as needed.ResponsibilitiesLos Alamos National Laboratory has selected SAP for their next-generation Cloud ERP solution.
In parallel, they will require a future state data strategy to take advantage of new tools and technology to help modernize their current on-prem operational data store. This work plays a critical role in supporting key institutional initiatives such as enabling real-time analytics, AI/ML capabilities, and enhanced operational efficiency. This role will be critical in transformation of their legacy data environment into a modern, cloud-native architecture. In concert with institutional knowledge experts and ERP implementation planner and integrators, you will define the data strategy, standards, and blueprints for migrating and integrating high-volume operational data into a new platform, ensuring data integrity, security, and accessibility across the enterprise.Job Requirements5+ years of progressive experience in data architecture, data modernization, and cloud-based data solutions.Advise on the Databricks reference architecture covering Lakeflow, Delta Lake, Unity Catalog Mosaic AI, Databricks SQL, and Databricks AppsProvide hands-on guidance on Databricks full-stack solution designAdvise on design of both data movement (e.g.
batch, real-time streaming) and zero-copy patternsGuide platform migrations from legacy SQL and document stores onto Databricks and related cloud data platformsRecommend security, governance, and compliance-as-code: Unity Catalog ABAC, governed tags, row filters/column masks, key management, networking security and compliance security profiles.Advise on design of segregated/tiered data pool architectures aligned to the organization's data classification policy and applicable regulatory requirements, including cross-tier data movementRecommend FinOps and performance standards, workload and cost managementMentor data engineers, analysts, and AI/ML teams participate in architecture reviews and contribute to standardsWork with information & cyber security, and other teams as needed for compliance to policies and standardsEvaluate emerging Databricks capabilities and recommend adoption strategies, including endpoint integrations with third parties as they evolveExcellent verbal and written communication skills.Candidate must have the ability to work with many team members across multiple disciplines.The candidate must be able to obtain and maintain a DOE Q clearance.The candidate must have an active Real ID diver's license for badging and onboarding.Preferred Qualifications7+ years designing, building, and operating Databricks workloads with medallion layer architectureHands-on experience with Delta Lake, Unity Catalog, Spark Structured Streaming, Lakeflow (or DLT/Live Tables), Databricks SQL, MLflow, and Mosaic AI Model ServingStrong experience in cloud architecture supporting the platform (VPC/VNet, Security, S3/ADLS, KMS, etc.)Proven experience migrating enterprise data workloads from legacy/on prem data warehouse/lake to DatabricksProduction streaming and CDC experienceDepth in security and governance: Unity Catalog policies (ABAC), classification, encryption, access auditing, compliance-to-control translationHands-on experience designing multi-tier Databricks architectures driven by data classification requirementsStrong Python and SQL, Spark, NotebooksExcellent verbal and written communication skillsActive (or recent) Q clearance is a plus but not required.Nice to HaveActive Databricks certificationsGenAI and agent systems on Databricks experienceDelta Sharing and Databricks Clean Rooms for controlled, governed data exchange across organizational/cross-tier/system boundariesFamiliarity with Oracle EBS and SAP enterprise dataExperience with SAP BDC/DataSphere and Databricks integration to SAP BDC, with zero-copy patternsLakeflow Designer, Databricks Apps, Genie, Databricks OneCI/CD, Infrastructure-as-Code (e.g. Terraform) for data platformsExperience in designing, building, supporting BI reporting layersData Quality and Data Governance experiencePrior experience in regulated industries (e.g. utilities, life sciences, government services) and exposure to related frameworks (e.g. FERC/NERC, HIPAA, GxP, GDPR, FedRAMP, ITAR, etc.)Education RequirementsBachelor's degree, preferably in computer science, engineering, information systems, or related discipline, along with 12 years of experience.
Equivalent combination of education and experience will be considered.Certifications are a plus.