Data Developer ( SQL / ETL )

Here are 3 positions ( Junior , Mid level and Architect )

Location: Remote

Reports To: Head of Data Engineering

No Visa sponsorship is available for this role. 

Purpose

The Data Developer is responsible for designing, developing, and maintaining the Firm s data infrastructure, focusing on Microsoft SQL Server technologies. This role involves developing and optimizing databases, creating efficient ETL (Extract, Transform, Load) processes, and ensuring data integrity across systems. The Data Developer will collaborate with other development teams to support data-driven applications and business intelligence initiatives. This role requires deep expertise in MS SQL, Python, SSIS, stored procedures, and data integration techniques.

Responsibilities

Database Development & Optimization

• Design, develop, and maintain complex SQL Server databases to support business applications and reporting systems.
• Write, optimize, and maintain stored procedures, triggers, and user-defined functions to ensure high performance and data integrity.
• Develop efficient and scalable ETL processes using SSIS and Python to extract, transform, and load data from various sources.
• Monitor and troubleshoot database performance issues, identifying and resolving bottlenecks to ensure optimal system performance.
• Implement data partitioning, indexing strategies, and other techniques to optimize database performance and scalability.

Data Integration & ETL

• Develop and maintain data integration workflows to facilitate the seamless flow of data between internal and external systems.
• Design and implement data pipelines to ingest, process, and store large volumes of structured and unstructured data.
• Collaborate with cross-functional teams to understand business requirements and create ETL solutions that ensure data accuracy, consistency, and security.
• Ensure data is transformed and stored in a way that is suitable for analysis, reporting, and business intelligence use cases.
• Maintain data integrity and enforce data governance policies across all databases and ETL processes.

Collaboration & Support

• Work closely with application developers, business analysts, and data scientists to understand data needs and develop solutions that support business goals.
• Provide technical support for database-related issues and collaborate with other teams to troubleshoot and resolve data integration or performance problems.
• Participate in code reviews and design discussions to ensure best practices are followed in database design and development.
• Contribute to the documentation of data architectures, processes, and procedures, ensuring that systems are well-documented and easy to maintain.

Continuous Improvement

• Stay current with the latest developments in database technologies, particularly Microsoft SQL Server and related tools, and recommend improvements where appropriate.
• Proactively identify opportunities to optimize existing databases, ETL processes, and data workflows for better efficiency, scalability, and reliability.
• Implement and maintain database security measures, ensuring that sensitive data is protected in compliance with the Firm s security policies.
• Contribute to the Firm s data governance initiatives by ensuring the accuracy, consistency, and security of all managed data.

Professional Conduct

• Demonstrates commitment to the firm s core values, including Accountability, Integrity, Excellence, Grit, and Love.
• Ensures all activities align with business objectives and project timelines.
• Communicates effectively, openly exchanging ideas and listening with consideration.
• Maintains a proactive, solution-oriented mindset when addressing challenges.
• Takes ownership of responsibilities and holds others accountable for their contributions.
• Continuously seeks opportunities to optimize processes, improve performance, and drive innovation.

Qualifications:

• Expertise in MS SQL, SSIS, T-SQL
• Expertise in Python
• Strong structured problem-solving skills, with a history of using systematic and fact-based processes to improve mission-critical services.
• A focus on optimization and efficiency in processes.
• Demonstrated expertise in fostering a culture of positive collaboration among cross-functional teams with diverse personalities, skill sets, and levels of experience.
• Highly developed communication skills
• A sense of urgency and a bias for action.