Sr Data Architect Analyst responsible for data architecture solutions in Oracle HCM. Leading design and implementation of data warehousing and analytics for HR stakeholders.
Responsibilities
**Key Responsibilities:**
Drive Analytics projects and coordinate with other stakeholders including but not limited to Senior Leadership, HR Stakeholders, IT Stakeholders, EDW team, and Architects
Design and customize semantic models, attributes, and hierarchies within FDI to align with complex business requirements.
Understand, build, and develop FDI, OTBI, and BIP reports and analytics for data reporting and integration, including ODI/Informatica.
Designing, building, and maintaining advanced visual narratives (Heat Maps, Tree Maps) to uncover workforce patterns.
Ensure data security and compliance with industry standards, in Oracle HCM’s OTBI/BIP and FDI.
Design star schemas, fact and dimension tables, and perform physical and logical data modeling.
Administer BI tools, including metadata modeling, dashboards, DV, Object Level Security, and Data Level Security.
Handle data migrations and create complex SQL queries across multiple databases.
Analyze and troubleshoot Oracle data and performance issues.
Experience implementing predictive models and AI/ML algorithms.
Collaborate with HR stakeholders to gather requirements and deliver, troubleshoot, and optimize data solutions
Act as the subject matter expert (SME) on Oracle HCM data structures, providing guidance to junior analysts and technical teams
Help develop and implement data strategies that drive business values
Requirements
**Required Qualifications:**
Eight years of experience, preferably in HCM domain.
Strong HR Domain knowledge with understanding of data models, KPIs, Metrics, visualizations, and Security
Data Engineering Skillset – Proficiency in SQL, PL/SQL, cloud architecture (OCI/Azure), experience with data warehouse modelling and BI administration tools.
Proven experience in creating and handling complex SQL queries.
FDI Security Roles and groups, and inheritance/mapping with HCM
Strong understanding of Oracle data analysis and performance optimization.
**Preferred Qualifications:**
Experience in the HR domains, specifically in Oracle Cloud.
Familiarity with Oracle Integration Cloud (OIC)
Bachelors/Masters degree preferably in Analytics, IT, Computers, Information Systems
Strong analytical and problem-solving skills.
Excellent communication and teamwork abilities.
Ability to collaborate with team and manage stakeholders
Presentation skills to share strategy, solutions, recommendations
Certified in FDI (Fusion Data Intelligence), Generative AI Certified Professional
Manager of Data Architecture at Statista guiding cross - functional data teams and projects. Overseeing data architecture and driving key programs in a global data - driven organization.
Principal Data Engineer at Genworth leading build teams and mentoring engineers in data engineering practices. Overseeing data architecture and engineering processes for the Life, Annuity, and Long - Term Care Data Solutions team.
Associate Data Engineer supporting enterprise data initiatives for big data projects at CVS Health. Ensuring the quality, reliability, and security of data solutions on Snowflake and Google Cloud Platform.
Data Engineer responsible for building data pipelines and improving data quality at Snap Inc. Collaborating with stakeholders across various functions to ensure timely dataset availability.
Senior Data Engineer automating cleaning and analysis of data for clinical trials at Statistics & Data Corporation. Engaging in AI initiatives to enhance data processing and insights.
Vice President of Strategic Data Architecture overseeing data architecture for a group of companies. Defining, governing, and advancing the data ecosystem to align with business priorities.
Data Engineer role in São Paulo developing data pipelines and maintaining data architecture. Collaborative role with a focus on data governance and analytics.
Data Engineer designing automated data pipelines for a leading recycling and sustainability company. Collaborating with IT and operations to streamline workflows and increase efficiency.
Data Warehouse Engineer developing end - to - end solutions for projects at TD Bank. Leading technical design and delivery of effective tech solutions.
Building, optimizing and supporting Beghou’s AI data platform in cloud environments using Databricks and Python. Requires hands - on development and adherence to software engineering best practices.