Sql Developer / CTE / Windows Functions
Philadelphia, PA
Onsite
Full Time
$80k - $100k
Our client is an embedded IoT company and looking for a SQL Developer, You will use your expertise in Common Table Expressions (CTE), stored procedures, star schema design, and window functions will be crucial. As a SQL Developer, you will play a pivotal role in designing and optimizing databases to support our IoT solutions. You'll collaborate closely with cross-functional teams to ensure data integrity and efficiency, contributing to the development of innovative solutions that drive our company's growth in the IoT space. This is an exciting opportunity for a skilled SQL Developer to make a significant impact in a dynamic and rapidly evolving industry.
Required Skills and Experience:
- Experience with Common Table Expressions (CTE)
- Proficiency in developing stored procedures
- Familiarity with star schema design
- Knowledge of window functions in SQL
What You Will be Doing:
- Designing and developing SQL queries, stored procedures, and views to support various business needs
- Collaborating with cross-functional teams to understand data requirements and optimize database performance
- Implementing and maintaining star schema data models for efficient data retrieval and analysis
- Utilizing window functions for advanced data manipulation and analysis tasks
The Offer:
- Competitive salary based on experience and skills
- Opportunities for professional growth and advancement
- Comprehensive benefits package including health insurance and retirement plans
- Dynamic and collaborative work environment with a focus on innovation and continuous learning