Talent.com
Database Architect
Database ArchitectAxelon Services Corporation • Los Angeles, CA
Database Architect

Database Architect

Axelon Services Corporation • Los Angeles, CA
29 days ago
Job type
  • Full-time
Job description

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

  • . Data Architecture & Modeling
  • 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.
  • . Data Integration & Pipeline Architecture
  • 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.
  • . Data Quality & Governance
  • 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.
  • . BI Platform Architecture & Optimization
  • 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.
  • . Solution Design & Technical Leadership
  • 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.
  • . Documentation & Knowledge Transfer
  • 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 Qualifications

    Technical Expertise

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

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

  • 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.
  • Create a job alert for this search

    Database Architect • Los Angeles, CA

    Similar jobs
    Cloud Database Architect

    Cloud Database Architect

    VirtualVocations • Van Nuys, California, United States
    Full-time
    A company is looking for a Cloud Database Solution Architect.Key Responsibilities Lead cloud database architecture within hybrid cloud models Design solutions for high availability, security, mi...Show more
    Last updated: 1 day ago • Promoted
    Lead Data Architect

    Lead Data Architect

    Capital Group • Los Angeles, CA, United States
    Full-time
    I can succeed as a Lead Data Architect at Capital Group.As a Lead Data Platform Architect, you will serve as the technical domain expert on foundational data and integration technologies to better ...Show more
    Last updated: 30+ days ago • Promoted
    Enterprise Architect

    Enterprise Architect

    Wounded Warrior Project • Los Angeles, CA, United States
    Full-time
    We know these are some of the things people look for in a job.If you're the kind of person who believes that honoring and empowering our nation's veterans is more than just a cause - that it's a ca...Show more
    Last updated: 30+ days ago • Promoted
    AWS Data Architect

    AWS Data Architect

    E-Solutions • Torrance, CA, United States
    Full-time
    My client is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harn...Show more
    Last updated: 3 days ago • Promoted
    Database Architect

    Database Architect

    24-Hour HR Process Outsourcing, Inc. • Redondo Beach, CA, United States
    Full-time
    Established in 2008, 24HRPO has been providing world class offshore recruitment and back office human resource services to our clients in the US predominantly in the IT and Healthcare industry.Our ...Show more
    Last updated: 12 days ago • Promoted
    Analyst, SAP Master Data

    Analyst, SAP Master Data

    AES Corporation • Long Beach, CA, United States
    Full-time
    Are you ready to be part of a company that's not just talking about the future, but actively shaping it? Join The AES Corporation (NYSE : AES), a. AES is committed to shaping a future through innovat...Show more
    Last updated: 3 days ago • Promoted
    Data Engineer

    Data Engineer

    Customs Goods • Carson, California, United States
    Full-time
    The Data Engineer will design, build, and maintain scalable data infrastructure and integrations to support enterprise analytics and operational systems. This role focuses on enabling seamless data ...Show more
    Last updated: 13 days ago • Promoted
    Senior Azure Cloud Engineer

    Senior Azure Cloud Engineer

    Unisys Corporation • Long Beach, CA, United States
    Full-time
    What success looks like in this role : .We are seeking a highly skilled Senior Azure Cloud Engineer with proven expertise in designing and deploying multitenant Microsoft Sentinel environments.The id...Show more
    Last updated: 30+ days ago • Promoted
    Senior Database Engineer (PostgreSQL)

    Senior Database Engineer (PostgreSQL)

    Computrition, Inc. • Los Angeles, CA, United States
    Full-time
    Senior Database Engineer (PostgreSQL) - Cloud-Native.Computrition - Jonas Software (https : / / www.Senior Director of Engineering. Lead Software Architect and Lead Software Engineer.We're building a cl...Show more
    Last updated: 30+ days ago • Promoted
    MongoDB DBA

    MongoDB DBA

    Kaav Inc. • Los Angeles, CA, United States
    Full-time
    Administer configure and optimize MongoDB databases for performance and scalability.Manage AWS RDS instances ensuring reliability backups and disaster recovery. Implement monitoring performance tuni...Show more
    Last updated: 3 days ago • Promoted
    MongoDB DBA

    MongoDB DBA

    Futran Tech Solutions Pvt. Ltd. • Los Angeles, CA, United States
    Full-time
    Work Location : Los Angeles, CA.Work Mode : 100% remote (Need to work as per PST ZONE).Administer configure and optimize MongoDB databases for performance and scalability. Manage AWS RDS instances ens...Show more
    Last updated: 3 days ago • Promoted
    Database Architect

    Database Architect

    Axelon Services Corporation • Los Angeles, CA, US
    Full-time
    Data Architect, Human Resources.The Data Architect plays a strategic and technical leadership role in designing, optimizing, and governing the data architecture that supports Human Resources busine...Show more
    Last updated: 28 days ago • Promoted
    Technical Project Manager (Finance Data Platforms)

    Technical Project Manager (Finance Data Platforms)

    Milestone Technologies, Inc. • Burbank, CA, US
    Full-time
    Month W2 Contract (No C2C / No Visa Sponsorship / No Student Sponsorship).Onsite 4x per week in Burbank, CA / 1 day remote. Seeking a Project Manager, Finance Data Platforms for EPM (Enterprise Performanc...Show more
    Last updated: 5 days ago • Promoted
    Senior Data Architect

    Senior Data Architect

    Marsh LLC • Los Angeles, CA, United States
    Full-time
    Award-winning, inclusive, Top Workplace culture doesn’t happen overnight.It’s a result of hard work by extraordinary people. More than 11,000 of the industry’s brightest talent drive our efforts to ...Show more
    Last updated: 22 hours ago • Promoted • New!
    EDW Architect

    EDW Architect

    Prosum • Los Angeles, CA, United States
    Full-time
    We are looking for a highly experienced and technically skilled.Enterprise Data Warehouse (EDW) Architect.This is a critical, hands-on role that will drive our data architecture strategy, enabling ...Show more
    Last updated: 3 days ago • Promoted
    Senior Database Architect — Secret Clearance

    Senior Database Architect — Secret Clearance

    24-Hour HR Process Outsourcing, Inc. • Redondo Beach, CA, United States
    Full-time
    A leading HR outsourcing company in California is looking for an experienced Database Architect to design and maintain SQL Server and Oracle databases. The role requires at least 6 years of relevant...Show more
    Last updated: 2 days ago • Promoted
    Senior Enterprise Applications and Data Architect

    Senior Enterprise Applications and Data Architect

    Fox Rothschild • Los Angeles, CA, United States
    Full-time
    As a member of the Information Systems Department, the Senior Enterprise Applications and Data Architect is responsible for assessing, developing, and maintaining architecture components within the...Show more
    Last updated: 3 days ago • Promoted
    Senior Architect

    Senior Architect

    Amtec Staffing • Long Beach, CA, US
    Full-time
    We are seeking a Senior Architect to lead the design and execution of Commercial, Retail, Education, and Healthcare projects. This role requires a blend of creativity and technical expertise to deli...Show more
    Last updated: 16 days ago • Promoted