Pyramid Consulting Inc.
Overview
Pyramid is a leading Information Technology Consulting services company headquartered in metropolitan Atlanta, GA with emphasis on Staff Augmentation, Lifecycle IT solutions (Application Development & Support, Outsourced Testing), and Mobile Development and Test Automation. The company has grown to over 2500 IT consultants serving clients across the United States and globally, with offices in the United States, the United Kingdom, Singapore, and India. Pyramid has been recognized for diversity in IT staffing and has received multiple Supplier of the Year awards. Role: Data Modeler Location: New York City, NY Duration: 3–4 Months to start Responsibilities
Lead data modeling activities for Data Warehouse/Data Mart development, Data Warehousing (OLAP)/Business Intelligence (BI) applications, and Data Analysis for Online Transaction Processing (OLTP). Facilitate data requirement meetings with business and technical stakeholders and resolve conflicts to drive decisions. Perform design and development tasks for OLTP and OLAP environments; contribute to Data Modeling, System/Data Analysis, and overall data architecture. Work with Erwin and ER/Studio on multiple projects in OLAP and OLTP domains. Apply dimensional and relational modeling concepts (star schema, snowflake, fact and dimension tables) and implement Slowly Changing Dimensions - Type I & II as required. Demonstrate strong knowledge of data normalization/denormalization, data extraction, cleansing, and manipulation. Design and maintain logical and physical database models compliant with enterprise standards; maintain metadata and documentation for enterprise data stores. Develop ETL mappings (source-to-target) with naming standards, data types, volume considerations, and metadata definitions; provide data mapping documentation for ETL teams. Collaborate with Business Analysts, Production Support, Subject Matter Experts, DBAs, and DB Developers to deliver robust data solutions. Communicate concepts effectively; provide clear presentations and client-facing materials as needed. Qualifications
10+ years in Information Technology with expertise in data modeling for Data Warehouse/Data Mart, OLAP, BI, and OLTP environments. Extensive experience with data modeling tools (Erwin and ER/Studio). Experience with OLAP tools (e.g., SAP Business Objects) and ETL tools (Microsoft SSIS and Informatica). Proficiency with database platforms (Microsoft SQL Server 2000/2005/2008/2012) and related tooling (Office Suite, Project, SAP Business Objects). Strong understanding of dimensional vs. relational modeling, star/snowflake schemas, fact and dimension tables, and Slowly Changing Dimensions (Type I & II). Experience in ETL processes, data extraction from spreadsheets and database sources, and data cleansing/manipulation. Good communication skills and ability to interact with cross-functional teams. Technical Skills
Data Modeling Tools: Erwin and ER/Studio OLAP Tools: SAP Business Objects ETL Tools: Microsoft SSIS and Informatica Database Tools: Microsoft SQL Server (2000/2005/2008/2012) Packages: Microsoft Office Suite, Microsoft Project, SAP Business Objects Operating Systems: Windows family and UNIX Additional Information
Warm Regards
#J-18808-Ljbffr
Pyramid is a leading Information Technology Consulting services company headquartered in metropolitan Atlanta, GA with emphasis on Staff Augmentation, Lifecycle IT solutions (Application Development & Support, Outsourced Testing), and Mobile Development and Test Automation. The company has grown to over 2500 IT consultants serving clients across the United States and globally, with offices in the United States, the United Kingdom, Singapore, and India. Pyramid has been recognized for diversity in IT staffing and has received multiple Supplier of the Year awards. Role: Data Modeler Location: New York City, NY Duration: 3–4 Months to start Responsibilities
Lead data modeling activities for Data Warehouse/Data Mart development, Data Warehousing (OLAP)/Business Intelligence (BI) applications, and Data Analysis for Online Transaction Processing (OLTP). Facilitate data requirement meetings with business and technical stakeholders and resolve conflicts to drive decisions. Perform design and development tasks for OLTP and OLAP environments; contribute to Data Modeling, System/Data Analysis, and overall data architecture. Work with Erwin and ER/Studio on multiple projects in OLAP and OLTP domains. Apply dimensional and relational modeling concepts (star schema, snowflake, fact and dimension tables) and implement Slowly Changing Dimensions - Type I & II as required. Demonstrate strong knowledge of data normalization/denormalization, data extraction, cleansing, and manipulation. Design and maintain logical and physical database models compliant with enterprise standards; maintain metadata and documentation for enterprise data stores. Develop ETL mappings (source-to-target) with naming standards, data types, volume considerations, and metadata definitions; provide data mapping documentation for ETL teams. Collaborate with Business Analysts, Production Support, Subject Matter Experts, DBAs, and DB Developers to deliver robust data solutions. Communicate concepts effectively; provide clear presentations and client-facing materials as needed. Qualifications
10+ years in Information Technology with expertise in data modeling for Data Warehouse/Data Mart, OLAP, BI, and OLTP environments. Extensive experience with data modeling tools (Erwin and ER/Studio). Experience with OLAP tools (e.g., SAP Business Objects) and ETL tools (Microsoft SSIS and Informatica). Proficiency with database platforms (Microsoft SQL Server 2000/2005/2008/2012) and related tooling (Office Suite, Project, SAP Business Objects). Strong understanding of dimensional vs. relational modeling, star/snowflake schemas, fact and dimension tables, and Slowly Changing Dimensions (Type I & II). Experience in ETL processes, data extraction from spreadsheets and database sources, and data cleansing/manipulation. Good communication skills and ability to interact with cross-functional teams. Technical Skills
Data Modeling Tools: Erwin and ER/Studio OLAP Tools: SAP Business Objects ETL Tools: Microsoft SSIS and Informatica Database Tools: Microsoft SQL Server (2000/2005/2008/2012) Packages: Microsoft Office Suite, Microsoft Project, SAP Business Objects Operating Systems: Windows family and UNIX Additional Information
Warm Regards
#J-18808-Ljbffr