Database Architect

Data Architect, Human Resources

Location : Remote

Duration : weeks

Bill Rate :

JOB FUNCTION SUMMARY :

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. This position sits in HRIS, and is responsible for developing scalable data models, designing robust integration patterns, improving data quality, and ensuring system-to-system interoperability across the BI ecosystem. The Data Architect partners closely with HR, analytics, and business stakeholders to build a modern, reliable, and well-documented data architecture that supports operational reporting, analytics, and data-driven decision-making. This position will work primarily with Employee based data.

GENERIC SCOPE :

• 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.

Key Duties and Responsibilities

Required Qualifications

Technical Expertise

oT-SQL scripting

oStored procedures, functions, and views

oQuery optimization and performance tuning

oIndexing, partitioning, and execution plan analysis

oSQL Server Integration Services (SSIS) or similar ETL tools

Education

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.

Skills