Enterprise Data Warehouse Modeler

Type of Experience

• Knowledge of Relational Databases 8
• Knowledge of building Dimensional Model (Erwin, ER Studio) 10
• Expert level knowledge working with SQL Server, Oracle and PostgreSQL 10
• Requirements Gathering and data analysis 8
• SQL Programming 8
• Business intelligence technologies and solutions 5
• Data Profiling 5

Note: In addition, please list any desired experience.

• Creating visual displays for data analysis and presentation
• Tableau Reporting Server
• Vertica Database
• Experience with high performance big data concepts, such as Hadoop architectures and columnar databases such as Vertica
• Experience with solution delivery frameworks and tools such as Agile, Scrum, Kanban, JIRA

Education

• Bachelor’s degree with a strong academic record

Essential Duties

The Data Warehouse modeler and developer will spearhead the design and development of a new, high performance enterprise data warehouse for the organization, using industry best practices and data modeling techniques. Leads projects in designing enterprise data reporting architecture that includes strategic reporting databases, data marts and data warehouses. Creates complex ETL packages to extract data from various data sources and load into data warehouse. Takes ownership of system structure integrity and data integrity. Serves as technical team member in the development of business intelligence solutions and other reports based on data from various sources.

• Serves as Subject Matter Expert in data warehouse concepts (Kimball, Inmon, star schema, snowflake schemas, and normalized and de-normalized data models)
• Leads the integration of the data warehouse with a modern, leading business intelligence platform
• Leads in designing and revising data model for data warehouse, and meta data and data dictionaries across the enterprise
• Develops and maintains a thorough knowledge of business processes supported by software systems/products
• Analyzes and documents “as-is” and “to-be” scenarios (processes, models, use cases, plans and solutions)
• Performed Source system analysis (SSA) to identify the source data that needs to be moved into the target Tables
• Perform Data Analysis and Data validation by writing SQL queries
• Innovating new ways to standardize existing data processes and optimizing current workflows
• Creating custom data sets for use within our Analytics teams
• Create Data Mapping documents, data dictionaries and Interface Control Documents (ICDs)
• Works as part of Scrum Development Team and effectively participates in sprint planning, task estimates, task sequencing, task assignments, sprint reviews and retrospectives.
• Meets and collaborates with business users on requirements and objectives
• Leads in reviewing and revising database designs and scripts on an ongoing basis
• Leads in documenting meta-data about Data Warehouse System according to computer industry standards and knowledge of database management systems.
• Manages data loads, and security, storage and performance strategies and implementations.
• Serves as technical team member in the development of business intelligence reports and analysis, providing mentoring, guidance and troubleshooting to analysis team members in solving complex reporting and analytical problems
• Conducts complex analyses of strategic issues based on analysis of trends and interrelationships of key performance drivers documented in the data warehouse, especially the identification of test and control groups and comparison and evaluation of their relative performance; synthesizes research results and develops actionable strategic recommendations; communicates research results and strategic recommendations to nationwide and division strategy managers.
• Devises ER diagrams and identifies unique foreign keys, entities, attributes, relationships and business rules for data warehouse
• Meets and collaborates with business users on requirements and objectives
• Leads in reviewing and revising database designs and scripts on an ongoing basis
• Leads in documenting meta-data about Data Warehouse System according to computer industry standards and knowledge of database management systems.
• Manages data loads, and security, storage and performance strategies and implementations.
• Serves as technical team member in the development of business intelligence reports and analysis, providing mentoring, guidance and troubleshooting to analysis team members in solving complex reporting and analytical problems
• Conducts complex analyses of strategic issues based on analysis of trends and interrelationships of key performance drivers documented in the data warehouse, especially the identification of test and control groups and comparison and evaluation of their relative performance; synthesizes research results and develops actionable strategic recommendations; communicates research results and strategic recommendations to nationwide and division strategy managers.
• Devises ER diagrams and identifies unique foreign keys, entities, attributes, relationships and business rules for data warehouse
• Meets and collaborates with business users on requirements and objectives
• Leads in reviewing and revising database designs and scripts on an ongoing basis
• Leads in documenting meta-data about Data Warehouse System according to computer industry standards and knowledge of database management systems.
• Manages data loads, and security, storage and performance strategies and implementations.
• Serves as technical team member in the development of business intelligence reports and analysis, providing mentoring, guidance and troubleshooting to analysis team members in solving complex reporting and analytical problems
• Conducts complex analyses of strategic issues based on analysis of trends and interrelationships of key performance drivers documented in the data warehouse, especially the identification of test and control groups and comparison and evaluation of their relative performance; synthesizes research results and develops actionable strategic recommendations; communicates research results and strategic recommendations to nationwide and division strategy managers.
• Devises ER diagrams and identifies unique foreign keys, entities, attributes, relationships and business rules for data warehouse