2 Columnar Modeling Jobs

Key Responsibilities: Data Architecture: Lead the design, development, and implementation of comprehensive enterprise data architectures, primarily leveraging Azure and Snowflake platforms. Data Transformation & ETL: Oversee and guide complex data transformation and ETL processes for large and diverse datasets, ensuring data integrity, quality, and performance. Customer-Centric Data Design: Specialize in designing and optimizing customer-centric datasets from various sources, including CRM, Call Center, Marketing, Offline, and Point of Sale systems. Data Modeling: Drive the creation and maintenance of advanced data models, including Relational, Dimensional, Columnar, and Big Data models to support analytical and operational needs. Query Optimization: Develop, optimize, and troubleshoot complex SQL and NoSQL queries to ensure efficient data retrieval and manipulation. Data Warehouse Management: Apply advanced data warehousing concepts to build and manage high-performing, scalable data warehouse solutions. Tool Evaluation & Implementation: Evaluate, recommend, and implement industry-leading ETL tools such as Informatica and Unifi, ensuring best practices are followed. Business Requirements & Analysis: Lead efforts in business requirements definition and management, structured analysis, process design, and use case documentation to translate business needs into technical specifications. Reporting & Analytics Support: Collaborate with reporting teams, providing architectural guidance and support for reporting technologies like Tableau and PowerBI. Software Development Practices: Apply professional software development principles and best practices to data solution delivery. Stakeholder Collaboration: Interface effectively with sales teams and directly engage with customers to understand their data challenges and lead them to successful outcomes. Project Management & Multi-tasking: Demonstrate exceptional organizational skills, with the ability to manage and prioritize multiple simultaneous customer projects effectively. Strategic Thinking & Leadership: Act as a self-managed, proactive, and customer-focused leader, driving innovation and continuous improvement in data architecture. Position Requirements: Strong experience with data transformation & ETL on large datasets. Experience with designing customer-centric datasets (e.g., CRM, Call Center, Marketing, Offline, Point of Sale). 5+ years of experience in Data Modeling (e.g., Relational, Dimensional, Columnar, Big Data). 5+ years of experience with complex SQL or NoSQL queries. Extensive experience in advanced Data Warehouse concepts. Proven experience with industry ETL tools (e.g., Informatica, Unifi). Solid experience in Business Requirements definition, structured analysis, process design, and use case documentation. Experience with Reporting Technologies (e.g., Tableau, PowerBI). Demonstrated experience in professional software development. Exceptional organizational skills with the ability to manage multiple simultaneous customer projects. Strong verbal & written communication skills to interface with sales teams and lead customers to successful outcomes. Must be self-managed, proactive, and customer-focused. Technical Skills: Cloud Platforms: Microsoft Azure Data Warehousing: Snowflake ETL Methodologies: Extensive experience in ETL processes and tools Data Transformation: Large-scale data transformation Data Modeling: Relational, Dimensional, Columnar, Big Data Query Languages: Complex SQL, NoSQL ETL Tools: Informatica, Unifi (or similar enterprise-grade tools) Reporting & BI: Tableau, PowerBI

Key Responsibilities: Data Architecture: Lead the design, development, and implementation of comprehensive enterprise data architectures, primarily leveraging Azure and Snowflake platforms. Data Transformation & ETL: Oversee and guide complex data transformation and ETL processes for large and diverse datasets, ensuring data integrity, quality, and performance. Customer-Centric Data Design: Specialize in designing and optimizing customer-centric datasets from various sources, including CRM, Call Center, Marketing, Offline, and Point of Sale systems. Data Modeling: Drive the creation and maintenance of advanced data models, including Relational, Dimensional, Columnar, and Big Data models to support analytical and operational needs. Query Optimization: Develop, optimize, and troubleshoot complex SQL and NoSQL queries to ensure efficient data retrieval and manipulation. Data Warehouse Management: Apply advanced data warehousing concepts to build and manage high-performing, scalable data warehouse solutions. Tool Evaluation & Implementation: Evaluate, recommend, and implement industry-leading ETL tools such as Informatica and Unifi, ensuring best practices are followed. Business Requirements & Analysis: Lead efforts in business requirements definition and management, structured analysis, process design, and use case documentation to translate business needs into technical specifications. Reporting & Analytics Support: Collaborate with reporting teams, providing architectural guidance and support for reporting technologies like Tableau and PowerBI. Software Development Practices: Apply professional software development principles and best practices to data solution delivery. Stakeholder Collaboration: Interface effectively with sales teams and directly engage with customers to understand their data challenges and lead them to successful outcomes. Project Management & Multi-tasking: Demonstrate exceptional organizational skills, with the ability to manage and prioritize multiple simultaneous customer projects effectively. Strategic Thinking & Leadership: Act as a self-managed, proactive, and customer-focused leader, driving innovation and continuous improvement in data architecture. Position Requirements: Strong experience with data transformation & ETL on large datasets. Experience with designing customer-centric datasets (e.g., CRM, Call Center, Marketing, Offline, Point of Sale). 5+ years of experience in Data Modeling (e.g., Relational, Dimensional, Columnar, Big Data). 5+ years of experience with complex SQL or NoSQL queries. Extensive experience in advanced Data Warehouse concepts. Proven experience with industry ETL tools (e.g., Informatica, Unifi). Solid experience in Business Requirements definition, structured analysis, process design, and use case documentation. Experience with Reporting Technologies (e.g., Tableau, PowerBI). Demonstrated experience in professional software development. Exceptional organizational skills with the ability to manage multiple simultaneous customer projects. Strong verbal & written communication skills to interface with sales teams and lead customers to successful outcomes. Must be self-managed, proactive, and customer-focused. Technical Skills: Cloud Platforms: Microsoft Azure Data Warehousing: Snowflake ETL Methodologies: Extensive experience in ETL processes and tools Data Transformation: Large-scale data transformation Data Modeling: Relational, Dimensional, Columnar, Big Data Query Languages: Complex SQL, NoSQL ETL Tools: Informatica, Unifi (or similar enterprise-grade tools) Reporting & BI: Tableau, PowerBI