Data Engineer II

Kforce has a client that is seeking a Data Engineer II in New York, NY. Responsibilities: * Data Engineer II will design and implement robust data pipelines using AWS, Python, and SQL to support business analytics and decision-making across multiple domains (e.g., sales, finance, operations) * Ensure data integrity and performance of data processing and storage systems * Optimize data flows and architecture within AWS to enhance performance, scalability, and reliability * Develop and maintain scalable and efficient ETL processes and APIs for data interaction * Collaborate with cross-functional teams to gather and address technical and design requirements * As a Data Engineer II, you will maintain and enhance data models and databases to support diverse enterprise applications * Monitor and troubleshoot operational or data issues in the data pipelines * Continuously improve systems and processes by integrating new tools and technologies * Document all data engineering procedures and solutions for future reference and compliance * Support the data management team in daily operations and long-term projects * Bachelor's degree in Computer Science, Engineering, or a related field is preferred; Equivalent practical experience is also considered * Minimum of two years of experience in data engineering or a related field * Experience with Python for scripting and data manipulation * Advanced SQL knowledge for complex querying and database interaction * Knowledge of data modeling and database design * Expertise in AWS services such as S3, EC2, RDS, Redshift, and AWS Glue * Familiarity with orchestration tools (e.g., Airflow) and data integration techniques * Understanding of data warehousing solutions and ETL processes * Strong proficiency in building and maintaining data pipelines in AWS environments * Proficiency in Python, with a solid understanding of libraries and frameworks for data engineering (e.g., Pandas, PySpark) * Strong command of SQL for creating, managing, and optimizing data structures and complex queries * Good grasp of Agile methodologies and project management practices * Demonstrated ability to design and implement effective data warehousing and analytics solutions in cloud environments * Ability to write clean, maintainable code, adhering to best practices in code quality and security * Experience with CI/CD pipelines for data operations in an AWS environment is a plus