Senior Data Architect

Jobtailor; West Valley City (UT); On-site; USD 90,000 - 130,000; Full time

Job summary

JobTailor is seeking a senior Data Warehouse Architect to lead design and implementation of enterprise data warehouses for complex projects in the United States. You will drive data modeling, ETL development, and governance to ensure data usability for clients and stakeholders.

Responsibilities include optimizing data presentation for reporting tools, maintaining standards, and mentoring teams. Strong SQL/PLSQL, Python, and R experience with EPIC data models are highly valued.

Qualifications

• Requires graduate degree in CS, IS, Bioinformatics, Statistics, or related field, or a Bachelor's with 3 years' experience.
• Strong knowledge of SQL and data warehousing concepts; experience with EPIC data models is a plus.
• Experience in designing, implementing, and optimizing ETL processes and data pipelines.

Responsibilities

• Lead development of data marts and data models to support client reporting needs.
• Oversee physical design and implementation of databases for complex projects.
• Develop and maintain standards for data warehouse architectures, models, tools, and databases.

Skills

Leadership

Troubleshooting

Documentation

Consultation

Communication

Education

Master's degree in Computer Science or related field

Bachelor's degree with 3 years of experience

Tools

Oracle Database

Microsoft SQL Server

Alteryx

Cognos

Tableau

Informatica Cloud Services

PowerCenter

Azure Databricks

EPIC Clarity/Caboodle/Cogito

Job description

Responsibilities

• Provide leadership in developing data marts, designing data models, implementing ETL processes, and ensuring data usability for clients.
• Lead the physical design and implementation of databases for complex projects, optimizing data presentation for reporting tools.
• Develop and maintain standards for data warehouse elements, such as architectures, models, tools, and databases ensuring it aligns with best practices.
• Provide troubleshooting support for data warehouses and address technical issues promptly.
• Design, implement, and operate data warehouse systems to balance optimization of data access and resource utilization to meet performance requirements.
• Perform complex system and data analysis, using SQL, PLSQL, Python, and other languages to develop solutions through advanced programming and analysis.
• Build robust processes to streamline data flow by developing data warehouse process models, including sourcing, loading, transformation, and extraction, to support data integration pipelines.
• Create and manage supporting documentation, including metadata, diagrams of entity relationships, business processes, and process flows, for governance and reference.
• Ensure proper integration of data with existing standards and business processes to support smooth operations, maintaining consistency across systems.
• Create plans, test files, and scripts for data warehouse testing, including unit and integration testing to ensure system readiness.
• Develop, document, and deliver complex ad-hoc queries, consulting with business users to determine needs, feasibility, and priorities.
• Develop and implement ETL processes and map data between source systems, data warehouses, and data marts, ensuring smooth data flow across them, while verifying the structure, accuracy, and quality of warehouse data.

Requirements

• Master's degree or equivalent foreign education in Computer Science, Information Systems, Bioinformatics, Statistics, or a closely related field.
• Or Bachelor's degree with 3 years of experience in the same fields.
• Knowledge of Oracle or Microsoft SQL Server databases.
• Knowledge of Alteryx, Cognos, and Tableau.
• Knowledge of Architecture and Modeling Tools.
• Knowledge of Data Integration and Strategies.
• Knowledge of SQL.
• Knowledge of R and Python.
• Knowledge of Data Warehouse Concepts, Models, Cohorts, Metrics and KPIs.
• Knowledge of Informatica Intelligent Cloud Services and PowerCenter.
• Knowledge of Azure Databricks.
• Knowledge of EPIC Clarity and Caboodle.
• Knowledge of EPIC Cogito.
• Knowledge of EPIC Caboodle Development.
• Knowledge of EPIC Clinical Data Model.

ATS Optimization Keywords

Below are skills and terms extracted directly from this job posting to improve Applicant Tracking System (ATS) visibility. This unique feature helps candidates tailor their applications more effectively — a feature exclusive to JobTailor job listings.

Hard Skills

• SQL
• PLSQL
• Python
• R
• ETL processes
• Data modeling
• Data warehousing
• Data integration
• Data analysis
• Data flow optimization

Soft Skills

• Leadership
• Troubleshooting
• Documentation
• Consultation
• Communication