Ampcus Inc · 1 month ago
Data Architect, Human Resources
United States
Full-time
Remote
Senior Level
$94/hr - $99/hr
7+ years expAmpcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. The Data Architect plays a strategic and technical leadership role in designing, optimizing, and governing the data architecture that supports Human Resources business intelligence and analytics.
Data ManagementInformation Technology
Responsibilities
Lead the design and evolution of the HR data architecture supporting HR Business Intelligence, Data Integrations between HR Systems, and BI tools like Tableau and Power BI
Develop scalable data models (conceptual, logical, physical) aligned with business needs
Oversee data integration frameworks, ETL/ELT pipelines, and interface standards
Evaluate and improve data quality, consistency, master data management, and metadata stewardship
Establish best practices for data governance, documentation, change management, and system optimization
Design, document, and maintain conceptual, logical, and physical data models
Develop data structures that support analytics, dashboards, operational reporting, and advanced BI use cases and/or data integrations/interfaces
Optimize existing data models to improve performance, scalability, and data integrity
Simplify complex data domains into well-defined models aligned to business processes
Architect data integration patterns (batch, streaming, API-based, message-driven) to support enterprise BI needs
Define standards for ETL/ELT development, data staging, transformation logic, and load performance
Oversee system-to-system interoperability and ensure consistent handling of master data and reference data
Evaluate existing interfaces and recommend modern integration best practices
Implement data quality frameworks, validation rules, and error-handling patterns
Partner with data governance teams to define data definitions, lineage, and stewardship models
Establish standards for metadata management, naming conventions, versioning, and data documentation
Support architecture decisions related to data warehouses, data lakes, semantic layers, and reporting repositories
Optimize BI performance through indexing, partitioning, caching, and model tuning
Collaborate with BI developers to ensure efficient, performant reporting and dashboarding
Provide architecture guidance for new BI tools, technologies, and platform enhancements
Lead technical discovery, current-state assessments, and future-state architecture planning
Translate business requirements into well-architected data solutions
Review and approve data design for new initiatives, enhancements, and integrations
Provide guidance, mentorship, and architectural oversight to data engineers and BI developers
Develop and maintain architecture diagrams, system flows, interface maps, and technical standards
Document dependencies, data lineage, and operational workflows for key data assets
Provide training and knowledge transfer to data engineering, BI, and analyst teams
Support the creation of long-term BI roadmap plans and architectural frameworks
Qualification
Required
7+ years of experience working with Microsoft SQL Server in an enterprise data warehouse environment, including advanced proficiency with: T-SQL scripting, Stored procedures, functions, and views, Query optimization and performance tuning, Indexing, partitioning, and execution plan analysis, SQL Server Integration Services (SSIS) or similar ETL tools
Demonstrated ability to design, maintain, and optimize data warehouses and BI-oriented data models in SQL Server
Strong proficiency designing conceptual, logical, and physical data models for analytical use cases
Experience architecting and supporting ETL/ELT pipelines feeding SQL Server environments
Deep understanding of data integration patterns (batch, delta, API, and event-driven)
Hands-on experience with data governance, master data, metadata management, and data quality frameworks
Experience with BI tools (Tableau, Power BI, or similar) and the underlying data structures they rely on
Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related technical field; OR Equivalent combination of education and extensive professional experience in data architecture, data engineering, or business intelligence
Strong ability to diagnose and resolve complex data issues, pipeline failures, and system bottlenecks
Ability to translate loosely defined business requirements into technical architectural solutions
Demonstrated success planning and executing architectural improvements in a BI environment
Excellent communication skills with the ability to articulate technical concepts to diverse stakeholders
Experience collaborating across IT, business, analytics, and data engineering teams
Ability to produce clear documentation, diagrams, specifications, data dictionaries, and standards
Company
Ampcus Inc
Ampcus is a global business, technology consulting and an staff augmentation firm specializing in AI/ML,digital solutions, Cybersecurity & Risk management, Testing, Forensics & Fraud services and human capital management.
1001-5000 employees
H1B Sponsorship
Ampcus Inc has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (14)
2024 (13)
2023 (7)
2022 (16)
2021 (13)
2020 (18)
Funding
Current Stage
Late StageLeadership Team
Raj Narayan
Sr. Vice President, Strategic Sales
Recent News
2025-08-18
2025-07-31
Seattle TechFlash
2025-07-15
Company data provided by crunchbase