Position Overview & Specifications
Remote PST work hours W2 position ( need to be on GC/ EAD / US Citizen) C2C is not an option here. Develop and maintain scalable data models in Snowflake, ensuring data integrity and reliabilityDesign and implement data transformations using DBT to support analytics and reporting requirementsCollaborate with data engineers and data analysts to understand data needs and translate them into technical solutionsOptimize Snowflake warehouse configurations and DBT models for performance and cost efficiencyTroubleshoot and resolve data pipeline issues, ensuring smooth and efficient data flowParticipate in code reviews and provide feedback to team members to ensure code quality and adherence to best practicesStay updated with the latest developments in Snowflake and DBT technologies, and propose and implement innovative solutionsDocument data pipelines, transformations, and processes to facilitate knowledge sharing and maintain data lineageWork closely with cross-functional teams to support data-driven decision-making and business objectivesContribute to agile project planning and execution related to data engineering tasks and initiatives
Skills8+ years of experience working on relational databases, SQL, and stored proceduresAdvanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases such as DBT and Snowflake for Data WarehouseAt least 3+ years of experience working on Snowflake, building data warehousing solutions, dealing with slowly changing dimensions as wellHighly preferred to have prior experience in creating DW models on SAP ECC, Salesforce systemsAt least 3+ years of experience in developing and deploying data transformations using DBT, including creating/debugging macros5+ experience in supporting end-to-end data model build and maintenance, including testing/UATBuild, maintain and test data pipelines using cloud ETL/ELT tools, preferably SnapLogicPrior experience in working on SAP HANA
Skills8+ years of experience working on relational databases, SQL, and stored proceduresAdvanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases such as DBT and Snowflake for Data WarehouseAt least 3+ years of experience working on Snowflake, building data warehousing solutions, dealing with slowly changing dimensions as wellHighly preferred to have prior experience in creating DW models on SAP ECC, Salesforce systemsAt least 3+ years of experience in developing and deploying data transformations using DBT, including creating/debugging macros5+ experience in supporting end-to-end data model build and maintenance, including testing/UATBuild, maintain and test data pipelines using cloud ETL/ELT tools, preferably SnapLogicPrior experience in working on SAP HANA