What are the responsibilities and job description for the Database Developer II position at Randstad Digital?
Job Details
Job Summary: As a Database Developer, you will focus on designing, optimizing, and managing complex databases, ensuring seamless data integration and flow across platforms like Salesforce and Adobe Analytics. This role requires strong technical expertise in SQL, Teradata, and Python, with hands-on experience in writing scripts and queries to support data-driven marketing strategies.
Key Responsibilities:
- Design and and implement solutions to integrate the in-house Customer Data Platform (CDP) with a centralized data warehouse using AWS and Redshift.
- Develop and maintain automated data ETL (Extract, Transform, and Load) processes to connect disparate data sources, including Salesforce, Eloqua, Adobe Analytics, OnDemand, and Showpad, to the centralized data warehouse.
- Create, optimize, and manage scripts and queries to ensure data is stored in 'Fit for Use' relational tables.
- Analyze and interpret data from multiple database sources, including relational structures, dimensional data models, and cubes.
- Build and maintain API connections to integrate ad-hoc platforms with the centralized data warehouse.
- Extract, clean, and transform data before ingestion into the Data Warehousing platform using tools such as SQL, Alteryx, and others.
- Ensure adherence to industry best practices for table schema standardization and data accuracy.
Qualifications and Skills:
- Hands-on experience in writing scripts and queries for database management.
- Proficient in SQL, Teradata, Python, Redshift, AWS, and API Development (REST APIs).
- Experience in software development is a plus.
- Expertise in marketing and data analytics is a plus.
- 4-5 years of mid-level experience in a similar role.
location: New York, New York
job type: Contract
salary: $75 - 80 per hour
work hours: 8am to 5pm
education: Bachelors
responsibilities:
Job Summary: As a Database Developer, you will focus on designing, optimizing, and managing complex databases, ensuring seamless data integration and flow across platforms like Salesforce and Adobe Analytics. This role requires strong technical expertise in SQL, Teradata, and Python, with hands-on experience in writing scripts and queries to support data-driven marketing strategies.
Key Responsibilities:
- Design and and implement solutions to integrate the in-house Customer Data Platform (CDP) with a centralized data warehouse using AWS and Redshift.
- Develop and maintain automated data ETL (Extract, Transform, and Load) processes to connect disparate data sources, including Salesforce, Eloqua, Adobe Analytics, OnDemand, and Showpad, to the centralized data warehouse.
- Create, optimize, and manage scripts and queries to ensure data is stored in 'Fit for Use' relational tables.
- Analyze and interpret data from multiple database sources, including relational structures, dimensional data models, and cubes.
- Build and maintain API connections to integrate ad-hoc platforms with the centralized data warehouse.
- Extract, clean, and transform data before ingestion into the Data Warehousing platform using tools such as SQL, Alteryx, and others.
- Ensure adherence to industry best practices for table schema standardization and data accuracy.
Qualifications and Skills:
- Hands-on experience in writing scripts and queries for database management.
- Proficient in SQL, Teradata, Python, Redshift, AWS, and API Development (REST APIs).
- Experience in software development is a plus.
- Expertise in marketing and data analytics is a plus.
- 4-5 years of mid-level experience in a similar role.
qualifications:
- Experience level: Experienced
- Minimum 4 years of experience
- Education: Bachelors
skills:
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact
Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).
This posting is open for thirty (30) days.
Salary : $75 - $80