DW Developer

It is a global technology company providing commerce solutions that power billions of transactions. Clients around the world, including 90 percent of the Fortune 500.

As a Datawarehouse data developer who enjoys building logical and physical data models using tools, create & Maintain OLAP/OLTP snowflake warehouse. The Datawarehouse data developer will be responsible for conducting modeling sessions with project teams across all business groups, gather and define data requirements for Enterprise Data Model.This person will work with a highly-integrated, cross-discipline agile team. You are expected to be hands on and up to date with the latest technology stack. If this type of position motivates you, tell us why you are the right person for this challenging role!

• Must have around 8+ years of experience in SQL & Warehouse Development.
• Create logical and physical data models using tool, create & Maintain OLAP/OLTP snowflake warehouse.
• Provide and enforce best practices and governance standards, normalization, data classification, and normalization in the delivery of high-quality data solutions for Enterprise Data Warehouse, business group focused
• BI platforms (Data Marts), metadata reporting applications, and OLAP systems.
• Conduct modeling sessions with project teams across all business groups, gather and define data requirements for Enterprise Data Model.
• Lead discussion with stakeholders designed to transform subscriber data requirements into a robust, canonical logical model and data dictionary, with clearly-written business definitions for logical entities and attributes that describe enterprise data in a way that is consumable by a wide business audience.
• Experience with Cloud BI Platform – Snowflake
• Strong experience of building report using Power BI/Tableau
• Experience in reporting tools, including SQL Database, Power BI / Tableau and Data warehouse.
• Experience in MSSQL Scripting & PL/SQL, Oracle database, TD, Snowflake
• Enforce architectural standards and influence Developers, Technical Leads, Project Managers, and Systems Analysts regarding best practices for Enterprise Data Warehouse Design.
• Perform light Data Analysis and Data Profiling as needed.
• Good hands-on experience on batch processing and streaming data/Analytics

• Bachelor's or Master’s Degree in Statistics, Math, Computer Science, Management Information Systems, Data Analytics or another quantitative discipline, or equivalent work experience
• Minimum 5+ year of experience in SQL & Warehouse development.
• Any one of ETL tool Experience is pulse (Talend, Informatica, SSIS, Pentaho)
• Database Procedural Languages (PG/SQL,PL/SQL,T-SQL)
• Data Warehouse (Kimball) and OLAP Modeling
• General Relational Modeling (OLTP,OLEP, 3NF)
• Advanced Experience writing ad-hoc SQL queries (Postgres, Microsoft SQL, SnowSQL )
• Advanced Excel skills, including functions and pivot tables

Must-haves

• Any one of ETL tool Experience is pulse (Talend, Informatica, SSIS, Pentaho)
• Database Procedural Languages (PG/SQL,PL/SQL,T-SQL)
• Data Warehouse (Kimball) and OLAP Modeling
• General Relational Modeling (OLTP,OLEP, 3NF)
• Advanced Experience writing ad-hoc SQL queries (Postgres, Microsoft SQL, SnowSQL )
• Advanced Excel skills, including functions and pivot tables

Good to have
• Familiarity with Restful APIs and general Web Services
• Strong experience of building report using Power BI/Tableau
• Experience in reporting tools, including SQL Database, Power BI / Tableau and Data warehouse.
• Experience with big data and event streaming concepts and visualization (Kafka, ELK, Splunk, Hadoop, Hive, Graphite, Prometheus)
• Scripting Language (Python, PySpark)