Senior Data Architect

HILTI
Wichita Falls, United States of America
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Wichita Falls, United States of America

Tech stack

Third Normal Form
API
Artificial Intelligence
Airflow
Amazon Web Services (AWS)
Amazon Web Services (AWS)
Apache HTTP Server
Cloud Computing
Cloud Engineering
Information Systems
Databases
Data Architecture
Information Engineering
Data Governance
Data Infrastructure
ETL
Data Masking
Data Security
Data Vault Modeling
DevOps
Protocol Buffers
Identity and Access Management
Interoperability
JSON
Key Management
PostgreSQL
Microsoft SQL Server
MongoDB
NoSQL
Performance Tuning
Role-Based Access Control
Cloud Services
Salesforce
Search Technologies
Data Streaming
Management of Software Versions
Parquet
Policy as Code
Data Processing
Data Classification
Large Language Models
Prompt Engineering
Spark
Change Data Capture
Indexer
Data Strategy
GIT
Perf (Linux)
Avro
Amazon Web Services (AWS)
GraphQL
Data Management
Machine Learning Operations
Cloudwatch
Terraform
Data Pipelines
Serverless Computing

Job description

TheSenior Data Architectprovides technical leadership across Hilti's data landscape shaping enterprise data strategy and designing scalable, secure, and well governed data platforms that power analytics, AI/ML, and intelligent applications. This role spanstraditional data management(DBMS, data modeling, warehousing, governance) andmodern cloud native/AI data engineeringon AWS, includingbronze, silver, gold patterns, Generation (RAG)for LLMs, and data products that serve Cloud-native SaaSapplication teams at global scale. You will collaborate with business stakeholders, data scientists, engineers, and platform teams to translate use cases intotarget data architectures, ensuring performance, reliability, security, and cost efficiency at global scale., * Architect end-to-end pipelines across from raw to polished layers using Cloud native services such asS3, Glue (ETL & Data Catalog), Lake Formation, Redshift, Athena, EMR/Spark, Kinesis/MSK, Step Functions, Lambda, EventBridge.

  • Define storage/format strategies (eg,Parquet/Delta/Apache Iceberg) and partitioning, compaction, and indexing for performance and cost.
  • Implementrow/column level security, encryption (KMS), secrets management, and fine-grained authorization viaIAM/Lake Formation.

AI/ML & Amazon Bedrock Data Foundations

  • Design datasets andfeature/knowledgelayers to supportSageMakertraining/inference andAmazon Bedrockapplications (eg,Knowledge Bases,Guardrails,Agents, and Invoke Model/Converse orchestration).
  • LeadRAGarchitectures (chunking, embeddings, retrieval) usingvector databasessuch asAmazon OpenSearch Serverless (vector search)orAurora PostgreSQL + pgvector; define evaluation and feedback loops to improve answer quality.
  • Setprompt, context, and token budgetstandards; guide teams on safe data handling for LLMs (PII redaction, policy driven filters, secured context injection).

Tradition Data Architecture & DBMS Excellence

  • Provide deep expertise in relational and NoSQL systems:SQL Server,PostgreSQL,MongoDB, includingschema design, indexing, query/perf tuning, replication, partitioning, and HA/DR.
  • Design and governEDW/Lakehouse/ODSpatterns ; integrate with.NET/C andAngularfrontends via well designed APIs and data contracts.

Integration, Interoperability & Application Alignment

  • DefineAPI and data contract standards(REST/GraphQL, Protobuf/Avro/JSON), ensuring consistent versioning and backward compatibility for.NET/C.
  • Orchestrate ingestion fromSAP, Salesforce, IoT/telemetry, external data sources, and partner ecosystems; standardize CDC and streaming patterns (eg,MSK/Kinesis,DMS,Glue).
  • Partner with Solution/Platform Architects to ensuremicroservicesandevent drivendesigns are data efficient and observability ready.

Data Governance, Quality & Observability

  • Implementdata governance(policies, stewardship, data classification),cataloging(Glue Data Catalog),lineage(Open Lineage compatible), andquality(rules, thresholds, SLAs/SLOs).
  • Embedmonitoring & cost governance(CloudWatch, CloudTrail, Cost Explorer, Lake Formation audit, data access logs) and drive continuous optimization (storage tiers, compaction, pruning).

Security, Compliance & Risk

  • Enforce privacy and compliance (eg, GDPR) withdata minimization, tokenization, masking, andaccess controlsacross environments.
  • Define secure patterns formodel inputs/outputs(LLM safety),prompt hygiene, andguardrailsto prevent leakage or misuse.

Delivery Leadership & Collaboration

  • Producearchitecture blueprints, target state designs, andbuild/run guardrails; guide PoCs and pilots to derisk solutions.
  • Mentor data engineers, analysts, and junior architects; leaddesign reviews,threat modeling, andcost/performancereviews.
  • Communicate clearly with technical and nontechnical stakeholders, champion a culture ofengineering excellenceandlearning.

Requirements

  • This position is not eligible for employer-sponsored work authorization or visa sponsorship (including initial, transfer, or extension), and candidates must be authorized to work in the United States at the time of application and remain authorized for the duration of employment without the need for sponsorship.
  • Bachelor's or master's incomputer science, Information Systems, Data Engineering, or related field (or equivalent experience). Relevant certifications a plus (eg,AWS Data Analytics/Solutions Architect preferred).
  • 10+ yearsdesigning and delivering enterprise data solutions, includinghands-onwork with bothtraditional DBMSandcloud nativedata platforms.
  • 5+ yearsbuilding on cloud platformswith production experience in several of:S3, Glue, Lake Formation, Redshift, Athena, EMR/Spark, Kinesis/MSK, Lambda, Step Functions, EventBridge, SageMaker.
  • Demonstrated expertise implementingdata propagation Lakehousepatterns and governanceat scale.
  • Proven track record supportingAI/MLworkloads (feature stores, model data pipelines) and deliveringRAGsolutions with vector search on AWS.
  • StrongSQLandPython; proficiency indata modeling-IFC (preferred),3NF, dimensional/star, data vault, etc.
  • DBMS:SQL Server,PostgreSQL(schema, indexing, query planning, replication/HA, partitioning, backup/restore).
  • Data Engineering:Spark/EMR,Glue(ETL/ELT & Studio),Airflow/Step Functionsorchestration,Parquet/Delta/Iceberg.
  • Streaming/CDC:MSK/Kinesis,DMS(change data capture),event drivenpatterns.
  • Security & Governance:IAM,KMS,Lake Formation,Secrets Manager, data masking/tokenization, RBAC/ABAC.
  • AI/LLM enablement:Amazon Bedrock(Knowledge Bases, Guardrails, Agents), embeddings, chunking, retrieval,prompt design,token optimization, evaluation loops.
  • Observability & FinOps: Cloud logs/metrics, lineage/quality SLAs,cost controls(storage/compute), workload rightsizing.
  • DevOps/MLOps/IaC:Git,CI/CDfor data pipelines;Terraform/CDK; environment promotion; artifact/versioning ; blue/green or canary for data jobs.

Preferred Skills

  • Experience withRedshift RA3/Spectrum,materialized views,workload management, and federated queries (Athena/Glue).
  • Familiarity withPower BI/Microsoft FabricandAmazon Quick Sight; semantic modeling and governance for BI.
  • Exposure to privacy enhancing technologies(anonymization, differential privacy),policy as code, andguardrailframeworks.
  • Experience working withgeographically distributed teamsandregulated data.
  • Strategic thinking with the ability to balance short-term incrementsandlong term architecture.
  • Excellent written and verbal communication, facilitation of architecture decisions, and stakeholder alignment.
  • Mentoring mindset and demonstrated influence without authority across cross functional teams.

Benefits & conditions

In addition to a competitive base salary and bonus potential, we offer a robust benefits package including a generous paid time off policy that includes vacation, personal days, health & wellness, and 2 days per year to give back in your local community, paid family leave, educational reimbursement, 401(k) matching, medical/dental/vision coverage, and a variety of other benefits to fit the needs of our employees.

About the company

"We passionately create enthusiastic customers and build a better future"​
Hilti is a global leader in providing technology-leading products, systems and services to the worldwide construction industry. Our success is driven by distinction, defying convention and powering some of the world’s most ambitious feats of engineering for our customers.
We are proud to be recognized as one of best workplaces on the 2020 Fortune 100 Best Companies to Work For® list and 2019 Best place to Work by Glassdoor, and ranked among the top employers by the Great Place to Work® Institute multiple times.

Apply for this position