Data Warehouse Architect - ETL, Modeling & Data Quality

Jobtailor; Louisiana (MO); On-site; USD 100,000 - 150,000; Full time

Job summary

Jobtailor seeks a skilled Data Warehouse professional to design, support, and optimize our enterprise data warehouse for reporting and analysis. The role requires translating business processes into logical and physical data models, leading ETL development, and ensuring data integrity across systems.

You will mentor teammates and guide data-driven decisions across teams. Candidates should have a BS in CS or MIS and 6+ years of experience in database administration, data architecture, and data

Qualifications

• Bachelor’s degree or equivalent preferred.
• 6+ years related experience in database administration, data architecture or data modeling.
• Advanced SQL and ETL design patterns experience (MS Integration Services, Informatica, etc.).

Responsibilities

• Develop, support, and optimize the data warehouse for reporting and analysis.
• Analyze source system data and implement data cleansing and categorization processes.
• Translate business processes into logical and physical data models to support requirements.
• Lead data warehouse development lifecycle including ETL, design, testing, and validation.
• Design data structures and processes to ensure data integrity and quality.
• Troubleshoot and optimize queries and databases; drive process improvements.

Skills

Data Warehouse Development

ETL Design & Development

Advanced SQL & Database Development

Data Modeling Concepts

Database Administration Practices

Leadership Capabilities

Technical Guidance

Problem-Solving

Collaboration with Team Members

Education

Bachelor's degree in Computer Science/MIS or similar

Tools

MS Integration Services

Informatica

Power Pivot

Access

Microsoft Office Suite

Job description

Jobtailor seeks a skilled Data Warehouse professional to design, support, and optimize our enterprise data warehouse for reporting and analysis. The role requires translating business processes into logical and physical data models, leading ETL development, and ensuring data integrity across systems.

You will mentor teammates and guide data-driven decisions across teams. Candidates should have a BS in CS or MIS and 6+ years of experience in database administration, data architecture, and data