HighTower Advisors-posted about 1 year ago
Full-time • Mid Level
Chicago, IL
Professional, Scientific, and Technical Services

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.

  • 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.
  • 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.
  • Experience with data warehousing concepts.
  • Familiarity with tools like Snowpipe, Mulesoft, SSIS, Azure Data Factory.
  • 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.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service