Data Architect

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

• Develop, support, and optimize the data warehouse to facilitate reporting and analysis of enterprise data.
• Responsible for analyzing source system data, building processes to provide data cleansing and proper categorization.
• Translates business processes into logical and physical models in support of business requirements.
• Contributes to the data warehouse development lifecycle (requirements gathering, ETL, database design & development, testing & validation).
• Designs and builds data structures to support analysis and reporting.
• Designs and builds processes to ensure integrity and quality of data.
• Troubleshoots and optimizes existing queries and databases.
• Recommends and implements process improvements.
• Maintains data dictionary & documentation.
• Acts as an internal consultant providing technical guidance on business systems projects.
• Determines and resolves problems with other systems analysts, programmers, and systems users.
• Maintains, develops, modifies, and documents processes according to general specifications and guidelines.
• Provides guidance to lower-level team members.
• Consults with managerial and systems analysis personnel to clarify intent, identify problems, suggest changes, and determine extent of programming and coding required.
• Revises or directs revision of existing programs to increase operating efficiency or adapt to new requirements.
• Analyzes, defines, and documents system requirements for data, workflow, logical processes, hardware and operating system environment, interfaces with other systems, internal and external checks, and controls and outputs.
• Researches and evaluates software and hardware to enhance and improve existing processes.

Requirements

• Bachelor’s degree; BS in Computer Science, Management Information Systems or similar degree preferred
• At least six years related experience and/or training and experience with a developed expertise in database administration, data architecture or data modeling
• Knowledge of Microsoft Office products including Microsoft Word, Excel, Power Pivot, PowerPoint, Access Outlook email program
• General database administration practices
• Knowledge of application of data warehousing and data modeling concepts
• Advanced SQL & database development ETL design patterns & best practices (MS Integration Services, Informatica, etc.)
• SQL optimization methods and techniques
• Demonstrated leadership capabilities on sizable projects.

Core Competencies

Expertise in data warehouse development, including ETL design, database administration, and data modeling, with a strong focus on data integrity and optimization. Proven ability to translate business requirements into technical solutions while providing guidance and leadership to team members.

Highest-signal resume keywords

• Data Warehouse Development
• ETL Design & Development
• Advanced SQL & Database Development
• Data Modeling Concepts
• Database Administration Practices

ATS Optimization Keywords

Hard Skills

• SQL Optimization Methods
• Data Cleansing Processes
• Logical & Physical Data Models
• Data Structures Design
• Testing & Validation
• Process Improvement Implementation
• Data Dictionary Maintenance
• System Requirements Analysis
• Troubleshooting Databases
• Documentation Practices

Soft Skills

• Leadership Capabilities
• Technical Guidance
• Problem-Solving
• Collaboration with Team Members
• Consultation with Management

Industry Keywords

• Data Warehouse
• Data Architecture
• Data Modeling
• Database Administration
• Enterprise Data Analysis

Tools & Technologies

• Microsoft Office Suite
• MS Integration Services
• Informatica
• Power Pivot
• Access