SQL Database Lead /Architect

Role : SQL Database Lead /Architect

Location: New York City, NY

We are seeking a dedicated SQL Database Lead /Architect with exceptional data modeling skills to join our technology team. The ideal candidate will be a highly skilled professional in SQL development and data structuring, with a strong foundation in building scalable and efficient data solutions. While expertise in cloud technologies and reporting tools would be advantageous, the core focus of this role is on SQL development and data modeling.

Responsibilities:

• Develop and optimize advanced SQL queries and procedures to facilitate complex data retrieval, analysis, and manipulation.
• Design and maintain data models that accurately reflect business and system requirements, ensuring optimal performance.
• Evaluate existing database structures and implement enhancements to improve database integrity, performance, and efficiency.
• Collaborate with cross-functional teams to understand data needs and translate business requirements into technical solutions.
• Implement and maintain data warehousing solutions, utilizing cloud-based technologies such as Redshift and S3 when applicable.
• Integrate SQL databases with various data sources and applications, considering the use of Kafka streaming, Glue, and Lambda for data processing and workflow automation.
• Employ reporting tools like PowerBI, Cognos, or Tableau to develop dashboards and reports that provide actionable insights to business users.
• Document all aspects of database design, development processes, and data flow within the system.
• Maintain an understanding of the latest trends in SQL development, data modeling, and cloud technologies to suggest and implement best practices.

Qualifications:

• Proven experience in SQL development and data modeling, with a strong portfolio demonstrating past work and successes.
• Solid understanding of relational database concepts, data warehousing principles, and ETL processes.
• Excellent analytical and problem-solving abilities, with meticulous attention to detail.
• Strong communication skills, with the ability to convey complex data concepts to non-technical stakeholders.
• Ability to prioritize tasks, manage time effectively, and deliver projects on schedule.

Nice to Have:

• Experience with AWS cloud services, including Quicksight, Redshift, S3, RDS, Kafka streaming, Glue, and Lambda.
• Proficiency in implementing and managing reporting solutions using PowerBI, Cognos, or Tableau.
• Familiarity with Agile development methodologies and version control systems.

We can offer you:

• A highly competitive compensation and benefits package
• A multinational organization with 55 offices in 20 countries and the possibility to work abroad.
• Laptop and a mobile phone
• 10 days of paid annual leave (plus sick leave and national holidays)
• Maternity & Paternity leave plans
• A comprehensive insurance plan including medical, dental, vision, life insurance, and long-/short-term disability (plans vary by region)
• Retirement savings plans
• A higher education certification policy
• Commuter benefits (varies by region)
• Extensive training opportunities, focused on skills, substantive knowledge, and personal development.
• On-demand Udemy for Business for all Synechron employees with free access to more than 5000 curated courses
• Coaching opportunities with experienced colleagues from our Financial Innovation Labs (FinLabs) and Center of Excellences (CoE) groups
• Cutting edge projects at the world’s leading tier-one banks, financial institutions and insurance firms.
• A flat and approachable organization
• A truly diverse, fun-loving and global work culture

SYNECHRON’S DIVERSITY & INCLUSION STATEMENT

Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.

All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.