What are the responsibilities and job description for the Snowflake Data Engineer - Dallas, TX - Hybrid / Onsite position at NJTECH INC.?
Role: Snowflake Data Engineer , TCS / DTCC , Dallas, TX
Location: Dallas, TX
Experience: 7
About Us:
NJTECH is a globally managed IT services, IT consulting and business solutions partner. Our "High Performance Business" strategy builds our expertise in technology and consulting. We play a major role in helping our clients to achieve their objectives at the highest level; ultimately creating sustainable value to customers.
Job Summary:
We are seeking a highly skilled Snowflake Data Engineer to join our dynamic team. The ideal candidate will have hands-on experience in designing, developing, and optimizing scalable data solutions using Snowflake and modern data engineering tools. This role requires strong expertise in data warehousing, ETL/ELT processes, and cloud platforms, along with the ability to build efficient data pipelines and support data-driven decision-making in a fast-paced, collaborative environment.
Job Description:
Minimum 8 years of experience in Data Management, with strong expertise in analytical data warehousing and enterprise-scale data platforms, contributing to the delivery of complex data solutions.
Minimum 3 years of hands-on experience with Snowflake Cloud Data Warehouse, including use of advanced features and perfromance optimization for large, concurrent analytical workloads.
Strong experience with AWS cloud architecture, designing and supporting scalable, secure, and cost-effective data solutiona using core AWS Services.
Design, develop, and maintain complex SQL and PL/SQL procedures to support high-performance data integration and transformation processes.
Experience developing data integration solutions using Snowflake services such as Snowpark, Streams, Tasks, and Snowpipe. to implement both real-time and batch data pipelines within an use of advanced features and performance optimizing for large, concurrent analytical workloads.
Strong experience with AWS cloud architecture, designing and supporting scalable, secure, and cost-efficient data solutions using core AWS services.
Design, develop, and maintain complex sQL and PLISQL procedures to support high-performance data integration and transformation processes.
Experience developing data integration solutions using Snowflake services such as Snowpark, Stream, Tasks, and snowpipe to implement both real-time and batch data pipelines within an AWS ecosystem.
Strong knowledge of logical and physical data modeling, enabling effective analytics, reporting. and business intelligence solutions.
Hands-on experience developing dimensional data models, including slowly changing dimensions (SCDs) and multiple fact table designs, aligned with analytical best practices.
Solid experience across data lifecycle management, including data lineage, profiling, mapping, integeration, validation, cleansing, masking, subsetting, archiving, purging, virtualization, and metadata management.
Impllement and adhere to data quality and testing standards, supporting unit testing, system integeration testing, and UAT, to ensure production ready data solutions.
Perform SQL Performance tuning, proactive monitoring, and root cause analysis of data pipeline and platform issues, driving timely and effective resolution.
Solid experience across data lifecycle management, including data lineage, profiling, mapping, integration, validation, cleansing, masking, subsetting, archiving, purging, virtualization, and metadata management.
Implement and adhere to data quality and testing standards, supporting unit testing, system integration testing, and UAT, to ensure production-ready data solutions.
Perform SQL performance tuning, proactive monitoring, and root cause analysis of data pipeline and platform issues, driving timely and effective resolution.
Actively participate in Agile delivery teams, contributing to sprint planning, story implementation, estimation, and documentation using Jira.
Collaborate closely with peers, architects, and stakeholders, and provide guidance to junior engineers through code reviews and knowledge sharing.
Demonstrate strong verbal and written communication skills, effectively partnering with cross-functional technical and business teams.