Python SQL Developer

As a SQL + Python Developer, you will work closely with data analysts, engineers, and other business teams to deliver high-quality solutions. The role requires onsite presence in New York and a face-to-face interview.

Responsibilities:

• Database Development: Write and optimize complex SQL queries, stored procedures, and views for large-scale datasets to support data extraction, transformation, and analysis.

• Data Engineering: Build and maintain data pipelines using Python to automate data workflows, enhance data processing efficiency, and integrate various data sources.

• Collaborate with data analysts and business stakeholders to identify data requirements and provide actionable insights.

• Work on designing and implementing ETL (Extract, Transform, Load) processes to support data integration across multiple systems.

• Perform data cleansing and validation to ensure high data quality and consistency.

• Develop and maintain data models to support analytical and reporting needs in the capital markets domain.

• Troubleshoot performance issues related to databases and Python applications and optimize for speed and efficiency.

• Design and implement data-driven solutions to provide insights into financial trends, trading systems, and other business functions.

Requirements:

• Experience: 4-8 years of hands-on experience in SQL development and Python programming, with a focus on backend data systems.

Technical Skills:

• Strong proficiency in SQL (writing complex queries, performance tuning, and creating stored procedures).

• Experience with Python for data analysis, scripting, and developing data pipelines.

• Familiarity with data integration tools and frameworks such as Apache Airflow, Pandas, and NumPy.

• Experience working with ETL processes and data warehousing solutions.

• Strong understanding of database management systems like Oracle, MySQL, PostgreSQL, or SQL Server.

• Knowledge of data modeling, data lakes, and Big Data technologies (e.g., Hadoop, Spark) is a plus.

• Familiarity with cloud platforms such as AWS, Azure, or Google Cloud Platform.

Domain Expertise: Experience in the capital markets or financial services industry is highly preferred. Knowledge of financial data systems, trading platforms, and market data is a significant advantage.

Soft Skills:

• Strong problem-solving and analytical thinking skills.

• Excellent communication and collaboration skills, with the ability to work effectively in a cross-functional team.

• Ability to work under pressure and meet deadlines in a fast-paced environment.

• Detail-oriented with a focus on data accuracy and performance optimization.