- onsite Job, 1+ Year Experience
Annual Income: $59K - $69K
A valid work permit is necessary in the US/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