SQL Developer III

HighTower Advisors • Chicago, IL

422d

About The Position

The SQL Developer III role at HighTower Advisors is crucial for designing, developing, and maintaining SQL Server and Snowflake database models. This position focuses on developing complex queries to support business analytics, building scalable data architectures, optimizing database performance, and ensuring data accuracy across systems. Collaboration with stakeholders to translate business needs into effective data structures is essential for success in this role.

Requirements

• Bachelor's degree in computer science, Information Technology, or a related field.
• 4+ years of experience as a Database Developer or similar role.
• Extensive experience with SQL Server and Snowflake, including optimization and clustering strategies.
• Advanced SQL proficiency for writing and troubleshooting complex queries.
• Understanding of database administration and Snowflake cloud platform management.
• Proficiency in data manipulation using SQL, Python, or R.
• Familiarity with data integration pipeline development techniques.
• Knowledge of data visualization tools such as Tableau or Power BI.
• Understanding of data privacy regulations and best practices.
• Highly proficient in organization and communication.

Nice To Haves

• Experience with data warehousing concepts.
• Familiarity with tools like Snowpipe, Mulesoft, SSIS, Azure Data Factory.

Responsibilities

• Design and develop database models in SQL Server and Snowflake to meet business intelligence and operational requirements.
• Develop a Snowflake data warehouse for self-service analytics and integrate AI insights.
• Evaluate database models' performance and scalability, ensuring uptime and stability in production environments.
• Write, troubleshoot, and optimize complex SQL queries for accurate data retrieval.
• Design and manage ETL/ELT pipelines for data integration processes.
• Monitor and optimize database performance, identifying and resolving bottlenecks.
• Implement data quality controls and ensure compliance with security and privacy regulations.

Benefits

• Coverage on the first day of employment for medical, dental, and vision insurance.
• Paid parental leave (16 weeks for primary caregiver and 8 weeks for secondary caregiver).
• Flexible PTO plan.
• Hybrid model work schedule (50% in office).
• 401k matching plan.
• HSA employer contributions.
• Student loan assistance.
• Pet insurance.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Industry: Professional, Scientific, and Technical Services
• Education Level: Bachelor's degree