- 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