Job Summary:We are seeking a skilled and experienced Data Engineer to join our team. The ideal candidate will have expertise in Snowflake or Big Data platforms and a strong background in RDBMS skills like Oracle PL/SQL. You will be responsible for designing, developing, and maintaining data pipelines, ensuring data quality, and optimizing database and data platform performance. This role requires a deep understanding of modern data engineering workflows, ETL processes, and database systems.<div></div><div></div>Key Responsibilities:Data Engineering:<ul><li>Design, develop, and maintain scalable and efficient data pipelines to support business needs.</li><li>Implement ETL/ELT processes to extract, transform, and load data from various sources into Snowflake, Big Data platforms, or RDBMS systems.</li><li>Optimize data workflows for performance, scalability, and reliability.</li></ul>Snowflake or Big Data Platforms:<ul><li>For Snowflake:<ul><li>Design and implement data models in Snowflake to support analytical and reporting needs.</li><li>Develop and optimize Snowflake queries, stored procedures, and user-defined functions.</li><li>Manage Snowflake data sharing, security, and access control.</li></ul></li><li>For Big Data Platforms:<ul><li>Work with Big Data technologies such as Hadoop, Spark, Hive, or HDFS to process and analyze large datasets.</li><li>Develop distributed data processing pipelines using Spark (PySpark)</li><li>Optimize Big Data workflows for performance and scalability.</li></ul></li></ul>RDBMS Skills (Oracle PL/SQL):<ul><li>Write, debug, and optimize complex PL/SQL scripts, stored procedures, functions, and triggers.</li><li>Perform database performance tuning, query optimization, and troubleshooting in Oracle.</li><li>Design and implement database objects such as tables, views, indexes, and constraints.</li></ul>Data Integration:<ul><li>Integrate data from multiple sources, including APIs, flat files, and third-party systems.</li><li>Collaborate with data analysts, data scientists, and business teams to understand data requirements.</li></ul>Data Quality and Governance:<ul><li>Ensure data accuracy, consistency, and integrity across systems.</li><li>Implement data validation and error-handling mechanisms.</li></ul>Collaboration and Documentation:<ul><li>Work closely with cross-functional teams to understand business requirements and translate them into technical solutions.</li><li>Document data pipelines, database designs, and processes for future reference.</li></ul><div></div>Required Skills and Qualifications:<ul><li>Technical Expertise:<ul><li>Expertise in Snowflake or Big Data platforms:<ul><li>Snowflake: Hands-on experience with Snowflake data warehousing, data modeling, and query optimization.</li><li>Big Data Platforms: Experience with Hadoop, Spark (PySpark), Hive, or HDFS for distributed data processing.</li></ul></li><li>Strong experience in RDBMS skills, particularly Oracle PL/SQL, including stored procedures, functions, triggers, and performance tuning.</li><li>Proficiency in SQL and database design principles.</li><li>Experience with ETL/ELT tools</li></ul></li><li>Programming Skills:<ul><li>Proficiency in scripting languages such as Python and Shell scripting for data processing and automation.</li></ul></li><li>Data Governance:<ul><li>Knowledge of data quality, data governance, and data security best practices.</li></ul></li><li>Soft Skills:<ul><li>Strong problem-solving and analytical skills.</li><li>Excellent communication and collaboration skills.</li><li>Ability to work in a fast-paced, dynamic environment.</li></ul></li></ul><div></div>Preferred Qualifications:<ul><li>Experience with data visualization tools (e.g., Tableau, Power BI).</li><li>Knowledge of CI/CD pipelines for database deployments or Big Data workflows.</li><li>Familiarity with real-time data processing tools (e.g., Kafka, Flink, or Storm).</li><li>Certification in Snowflake, Oracle databases, or Big Data technologies is a plus.</li><li>Knowledge of NO SQL ( either Mongo or Neo4J )</li></ul>------------------------------------------------------Job Family Group: Technology------------------------------------------------------Job Family:Applications Development------------------------------------------------------Time Type:Full time------------------------------------------------------Most Relevant Skills Please see the requirements listed above.------------------------------------------------------Other Relevant Skills For complementary skills, please see above and/or contact the recruiter.------------------------------------------------------Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law. If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review <a href="https://www.citigroup.com/citi/accessibility/application-accessibility.htm" target="_blank">Accessibility at Citi</a>. View Citi’s <a href="https://www.citigroup.com/global/eeo-aa-policy" target="_blank">EEO Policy Statement</a> and the <a href="https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12ScreenRdr.pdf" target="_blank">Know Your Rights</a> poster.

Citi

Lead Data Engineer - Vice President

Citi

Similar Remote Jobs