Architect, Data Warehouse

12801BR

Title :

Architect, Data Warehouse

Job Description :

Lead the design development and maintenance of enterprise data warehouse and data analytics environment. Possess expertise in modern data architecture, data warehousing, data integration, cloud computing, and analytics solutions. Work with cross-functional teams to define, develop, and optimize enterprise data architecture supporting business intelligence (BI) and advanced analytics initiatives. Job duties :

Lead the selection and implementation of appropriate data warehousing technologies, including database platforms, ETL / ELT tools, and BI platforms.

Work with business stakeholders, data analysts, data scientists, and BI developers to understand business needs and create data warehouse specifications.

Develop and maintain conceptual, logical, and physical data models, ensuring alignment with business requirements and best practices.

Design and architect the data warehouse and BI architecture, including integration, storage, processing, and presentation, either independently or in collaboration with external consultants.

Work closely with Enterprise IT teams, including SAP infrastructure and database administrators, as well as enterprise system developers and administrators.

Develop, implement, and maintain end-to-end data pipelines, designing efficient ETL / ELT processes to extract, transform, and load data from diverse sources (e.g., SAP, Hyperion, PLM / QMS systems, flat files, APIs) into the data warehouse.

Develop and oversee a future roadmap for optimizing cloud data architecture, ensuring scalability, performance, and cost efficiency.

Design and implement real-time and batch data processing solutions using modern data processing frameworks and tools.

Ensure data security, compliance, governance, quality, and effective metadata management.

Manage the software development lifecycle related to the data warehouse and create standard operating procedures.

Comply with applicable Laws and Regulations, adhere to Quality Management System processes and requirements as well as demonstrate Ethics and Integrity in all matters and at all levels throughout the organization.

Perform additional duties as assigned.

Salary Range

$140,507-$175,633 Financial compensation packages may be higher / lower than what is listed, & will ultimately depend on factors including relevant experience, internal equity, skillset, knowledge, geography, education, business needs and market demand.

Auto req ID : 12801BR

Location MV :

Aliso Viejo, California, USA

Department Name :

105-Information Technology

Qualifications :

Bachelor's degree in computer science, Information Systems, or a related field, or equivalent combination of education and experience.

Minimum five (5) years of experience in data warehousing, data architecture, and business intelligence solutions.

Deep understanding of data warehousing concepts, including dimensional modeling, star schema, and snowflake schema for large-scale date modeling.

Proven knowledge of SQL Server for database management, data modeling, and query optimization.

Expertise in data integration and transformation tools and methodologies (e.g., SSIS, Azure Data Factory, SAP Data Services, etc.).

Expertise in data visualization and business intelligence tools, particularly Power BI, or other BI platforms.

Strong knowledge of data governance, security, and compliance standards.

Excellent written and verbal communication, collaboration, and critical thinking skills.

Proficient with MS Word, Excel, Outlook, and Teams.

Desired Qualifications

Experience with ERP systems (e.g., SAP S / 4HANA, Oracle, etc.) for data extraction and transformation.

Proficient in Azure Cloud, big data technologies (e.g., Spark, Data Lake), and Business Analytics.

Experience with project management involving a data lake implementation.

Ability to create reports, dashboards, and visualizations to support business decision-making.

Experience as a lead and / or senior member of a data warehouse team.

General knowledge of GxP, SOX, and other auditable data management requirements.

Knowledge of data science and machine learning concepts.

Experience with DevOps practices and tools.

Certification(s) in Data Architecture, Big Data, Data Engineering, Integrations, and other relevant technologies.

EEO

We are an equal employment opportunity employer. All qualified applicants will receive consideration for employment without regard to race, national origin, gender, age, religion, disability, sexual orientation, veteran status, marital status or any other characteristics protected by law.

Fair Chance Ordinance

If you are applying to perform work for Terumo Neuro in any position which will involve performing at least two (2) hours of work on average each week within the unincorporated areas of Los Angeles County, you can find here a list of all material job duties of the specific job position which Terumo Neuro reasonably believes that criminal history may have a direct, adverse and negative relationship potentially resulting in the withdrawal of a conditional offer of employment.

Terumo Neuro will consider for employment qualified job applicants with arrest or conviction records in accordance with the California Fair Chance Act, Los Angeles County Fair Chance Ordinance for Employers, Fair Chance Initiative for Hiring Ordinance, and San Francisco Fair Chance Ordinance.

External-Facing Title :

Architect, Data Warehouse

Posting Country : US - United States

Salary Range :

$140,507-$175,633 Financial compensation packages may be higher / lower than what is listed, & will ultimately depend on factors including relevant experience, internal equity, skillset, knowledge, geography, education, business needs and market demand.

We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, ethnicity, disability, religion, national origin, gender, gender identity, gender expression, marital status, sexual orientation, age, protected veteran status, or any other characteristic protected by law.