Log In
Sign Up
This is a remote position.
Junior Research & Development-SQL Developer – Remote Job, 1+ Year Experience
Annual Income: $61K – $71K
A valid work permit is necessary in Canada
About us: Patterned Learning is a platform that aims to help developers code faster and more efficiently. It offers features such as collaborative coding, real-time multiplayer editing, and the ability to build, test, and deploy directly from the browser. The platform also provides tightly integrated code generation, editing, and output capabilities.
Summary of Position:
A skilled SQL Developer to join our dynamic team. The SQL Developer will play a crucial role in designing, implementing, and maintaining stored procedures and queries, ensuring efficient and reliable database DevOps process, and developing and maintaining reports using PowerBI. The ideal candidate should have a strong background in SQL development, database design, and PowerBI.
Duties & Responsibilities:
- Design and implement database solutions to meet business requirements
- Create entity-relationship diagrams (ERDs) and data models
- Normalize data and ensure data integrity
SQL Development:
- 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
Data Integration:
- Collaborate with cross-functional teams to integrate data from various sources into the database
- Ensure data consistency and accuracy during the integration process
Documentation:
- Maintain thorough documentation of database schemas, data dictionaries, and processes
- Document changes and updates to the database environment
Troubleshooting and Support:
- Respond to and resolve database-related issues and incidents promptly
- Provide support and assistance to end-users and other teams as needed
Minimum Qualifications:
- 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
Why Patterned Learning LLC?
Patterned Learning can provide intelligent suggestions, automate repetitive tasks, and assist developers in writing code more effectively. This can help reduce coding errors, improve productivity, and accelerate the development process.
Pattern recognition is particularly relevant in the context of coding. Neural networks, especially deep learning models, are commonly employed for pattern detection and classification tasks. These models simulate human decision-making and can identify patterns in data, making them well-suited for tasks like code analysis and generation.
