You haven't searched anything yet.
SQL Developer
Job Summary:
We are seeking a skilled SQL Developer to join our dynamic and innovative team. The ideal candidate will have extensive experience in SQL Stored Procedures, ETL processes, CRM/HR systems, as well as the Kimball method of data warehouse design. This role is crucial in ensuring the smooth and efficient management of our data infrastructure, enabling us to make data-driven decisions and enhance our business intelligence capabilities.
Key Responsibilities:
· Design, develop, and maintain SQL Stored Procedures to optimize data management and retrieval processes.
· Develop and optimize ETL processes to efficiently extract, transform, and load data from various sources into our data warehouse.
· Collaborate with cross-functional teams to ensure the seamless integration of CRM and HR systems with our data warehouse.
· Implement and maintain the Kimball method of data warehouse design to ensure data accuracy, consistency, and accessibility.
· Perform data analysis and quality assurance to identify and resolve any data inconsistencies or issues.
· Develop and maintain data models, schemas, and documentation to support our data warehouse and business intelligence initiatives.
· Monitor and optimize database performance, ensuring scalability and high availability.
· Stay updated with industry trends and best practices in SQL development, ETL, data warehousing, and business intelligence.
· Collaborate with IT teams, business analysts, and stakeholders to understand data requirements and deliver data infrastructure that supports business goals.
Requirements:
· 3 years of experience in SQL development, with a strong focus on stored procedures and data warehousing.
· Proven experience in ETL processes and tools, as well as CRM/HR systems integration.
· Knowledge of Kimball method data warehouse design principles and best practices.
· Proficiency in SQL and other relevant programming languages.
· Strong analytical and problem-solving skills, with the ability to troubleshoot and resolve complex data issues.
· Excellent communication and collaboration skills, with the ability to work effectively in a team environment.
Full Time
$82k-102k (estimate)
05/05/2024
05/18/2024
pivotal-solutions.net
GREAT NECK, NY
50 - 100
Private
STEVEN EDELMAN
$10M - $50M
Business Services
Pivotal Solutions provides temporary & permanent staffing solutions to banks, brokerage, insurance & accounting firms and other private enterprises.
The following is the career advancement route for SQL Developer (Consulting) positions, which can be used as a reference in future career path planning. As a SQL Developer (Consulting), it can be promoted into senior positions as a Database Engineer V that are expected to handle more key tasks, people in this role will get a higher salary paid than an ordinary SQL Developer (Consulting). You can explore the career advancement for a SQL Developer (Consulting) below and select your interested title to get hiring information.