Database Engineer

Database Engineer Newark, New Jersey, United States About the Job Database Engineer Full-time, direct employment Hybrid onsite/remote - Newark, NJ No visa sponsorship or C2C at this time Job Description: Our client is seeking a highly skilled Database Engineer to join their team. The ideal candidate will have extensive experience in database development, with a strong focus on Snowflake development features and proficiency in various database technologies. The candidate should possess excellent analytical skills, problem-solving abilities, and a deep understanding of data security and privacy best practices. Responsibilities: Snowflake Development: Utilize strong knowledge of Snowflake development features such as SnowPipe, Streams, SQL REST API, Procedures, User Defined Functions, External Functions, Tagging, Masking, Data Lineage, and SnowPark to design, develop, and optimize data solutions. SQL Proficiency: Demonstrate proficiency in SQL, data querying, and performance optimization techniques to ensure efficient data retrieval and processing. Procedural Languages: Utilize proficiency in procedural languages such as MSSQL TSQL, Postgres PL/SQL to develop and maintain data warehouse and OLTP applications. Data Modeling and Database Design: Apply expertise in data modeling and database design to architect scalable and efficient database solutions. Snowflake Development Experience: Leverage 3+ years of experience in developing and deploying applications in Snowflake to design and implement robust data architectures. AWS Services: Utilize familiarity with AWS services such as S3, DMS, EC2, Glue, and Lambda to integrate Snowflake with other cloud services and technologies. Aurora Postgres Database Clusters: Demonstrate proficiency in managing Aurora Postgres database clusters on AWS to ensure high availability and performance. Orchestration Tools: Utilize familiarity with orchestration tools like Airflow, Autosys, etc., to automate and schedule data workflows and processes. Communication and Collaboration: Effectively communicate the status, challenges, and proposed solutions with the team. Work collaboratively in an Agile environment with Scrum Master/Product owner to deliver high-quality solutions. Qualifications: Bachelor's degree in Computer Science, Information Systems, or a related field. 5+ years of experience as a database developer with a strong focus on Snowflake development. Proficiency in SQL, data querying, and performance optimization techniques. Experience in developing data warehouse and OLTP applications. Familiarity with AWS services and Aurora Postgres database clusters. Experience with orchestration tools like Airflow, Autosys, etc. Strong analytical and problem-solving skills, with the ability to conduct root cause analysis and provide viable solutions. Knowledge of data security and privacy best practices. Working knowledge of data governance to ensure high data quality. Familiarity with data visualization and business intelligence tools (e.g., Tableau, Power BI). Ability to prioritize multiple tasks and projects and work effectively under pressure. Experience working in an Agile environment with Scrum Master/Product owner. Additional skills that set you apart, such as good understanding of Snowflake infrastructure, Python API development/Snowflake SnowPark coding experience, and knowledge of streaming or messaging technologies like Kafka or Kinesis, are highly desirable. Understanding of capital markets within Fixed Income is a plus. If you meet these qualifications and are passionate about database engineering and data management, we encourage you to apply for immediate consideration. Or refer someone 4 Staffing Corp