Data Architect, Human Resources

Software Guidance & Assistance, Inc., (SGA), is searching for a Data Architect, Human Resources for a Contract assignment with one of our premier Healthcare clients in Los Angeles, CA . (100% remote PST hours)

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.

Required Skills :

• 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.
• 7+ years of experience working with Microsoft SQL Server in an enterprise data warehouse environment, including advanced proficiency with:

o T-SQL scripting

o Stored procedures, functions, and views

o Query optimization and performance tuning

o Indexing, partitioning, and execution plan analysis

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

SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let’s work better together, we mean it. You’ll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at .

SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company to request an accommodation or assistance regarding our policy.