Logo of Huzzle

Research & Development-SQL Developer

  • Job
    Full-time
    Junior Level
  • Data
    Research & Development
  • Boise
    Remote

AI generated summary

  • You need a Bachelor's in IT or related field, SQL experience, database design skills, performance tuning, ETL, PowerBI, strong communication, and the ability to work in a fast-paced environment.
  • You will design and implement database solutions, write and optimize SQL queries, maintain schemas, troubleshoot issues, and collaborate with teams to ensure data integrity and accuracy.

Requirements

  • Bachelor's degree in Computer Science, Information Technology, or a related field or equivalent work experience
  • Proven experience as a SQL Developer or similar role
  • Proficiency in SQL programming and database management systems (e.g., Microsoft SQL Server, Oracle, MySQL)
  • Strong knowledge of database design principles and data modeling
  • Experience with performance tuning and optimization of SQL queries
  • Excellent problem-solving skills and attention to detail
  • Strong communication and collaboration skills
  • Ability to work independently and as part of a team
  • Prefer certification in database management (e.g., Microsoft Certified Database Administrator)
  • Experience with ETL (Extract, Transform, Load) processes and tools
  • Experience with business intelligence and reporting tools, PowerBI & Data Analysis Expressions (DAX)
  • Knowledge of HIPAA, preferred
  • Ability to deliver effective documentation of projects and tasks
  • Ability to perform comfortably in a fast-paced, high-intensity, deadline-oriented work environment

Responsibilities

  • Design and implement database solutions to meet business requirements
  • Create entity-relationship diagrams (ERDs) and data models
  • Normalize data and ensure data integrity
  • Write efficient and optimized SQL queries for data retrieval, manipulation, and reporting
  • Develop and maintain stored procedures, triggers, and functions
  • Troubleshoot and optimize SQL code for performance
  • Maintain database schema and drive the dev ops process to reliably propagate changes to test and production
  • Collaborate with cross-functional teams to integrate data from various sources into the database
  • Ensure data consistency and accuracy during the integration process
  • Maintain thorough documentation of database schemas, data dictionaries, and processes
  • Document changes and updates to the database environment
  • Respond to and resolve database-related issues and incidents promptly
  • Provide support and assistance to end-users and other teams as needed

FAQs

Do we support remote work?

Yes, this position is fully remote.

What is the annual income for this position?

The annual income for this position ranges from $59K to $69K.

What qualifications are required for this role?

A Bachelor's degree in Computer Science, Information Technology, or a related field or equivalent work experience is required, along with proven experience as a SQL Developer.

Is a valid work permit necessary?

Yes, a valid work permit is necessary to work in the US or Canada.

What responsibilities does the SQL Developer have?

The SQL Developer is responsible for designing and implementing database solutions, writing SQL queries, developing stored procedures, integrating data, maintaining documentation, and troubleshooting database-related issues.

What skills should the ideal candidate possess?

The ideal candidate should have proficiency in SQL programming, experience with database management systems, strong knowledge of database design, excellent problem-solving skills, and the ability to work independently and collaboratively.

Is experience with PowerBI required?

Yes, experience with PowerBI and Data Analysis Expressions (DAX) is required for developing and maintaining reports.

Are there any preferred certifications for this role?

Yes, certification in database management, such as Microsoft Certified Database Administrator, is preferred.

What tools and processes should candidates be familiar with?

Candidates should have experience with ETL processes and tools, business intelligence and reporting tools, and knowledge of HIPAA is preferred.

What type of work environment can applicants expect?

Applicants can expect a fast-paced, high-intensity, deadline-oriented work environment.

Learn Coding & Build software collaboratively with the power of AI, on any device, without spending a second on setup!

Technology
Industry
11-50
Employees

Mission & Purpose

Skip setup, soar through code! Learn & build together, on-demand, with AI your co-pilot. Any device, endless possibilities. Careers taking flight? Visit our page! But wait, there's more! You're not alone on this coding quest. Our trusty AI companion will guide you, suggest code snippets like secret spells, and catch errors before they turn into dark side bugs. Collaborate with fellow code warriors in real-time, sharing wisdom and building epic software empires together. From simple droids to full-blown Death Stars, the possibilities are endless. Web apps, mobile games, anything your code-fueled imagination can conjure. And when your masterpiece is ready, deploy it with a single click, sharing your creation with the galaxy. Level up your skills, join a thriving community of code knights, and land your dream tech job. Our career page is like a lightsaber to your resume, cutting through obstacles and illuminating your path to coding glory. So grab your device, choose your coding destiny, and join the revolution