data warehouse developer

job summary: The Data Warehouse Developer will assist in the initial setup, configuration and modeling of a new data warehouse in Redshift or Snowflake for the School of Medicine and Public Health. The person in this role will work closely with our data warehouse team, BI developers, software engineers and external partners to build our new academic and administrative data warehouse (AADW) as part of the UW-Madison transition to Workday in July 2025.   location: MADISON, Wisconsin job type: Contract salary: $63 - 68 per hour work hours: 8am to 5pm education: Bachelors   responsibilities: 50% Perform data warehouse design and testing, including data design, database architecture, metadata, and repository creation30% Design, develop, and maintain relational databases for data storage and data mining.15% Assist internal database team with initial data transfers into new warehouse.5% Seek continuous improvement in performance of data warehouse and ensure security of data. Required: Experience in multi-system data integrationExperience with data integration through extract, transform, load (ETL) & ELT patternsExperience with data modeling and relational database designExperience with data warehouse development, maintenance, and auditing/logging Preferred: Experience with enterprise data integration tools (e.g., Informatica Intelligent Cloud Services (IICS) Data Integration, Informatica PowerCenter, dbt), preferably IICS Data IntegrationExperience with structured and unstructured dataExperience with cloud data storage (e.g., Snowflake, Redshift)Experience with data virtualization platform (e.g., Denodo)Clear & effective written and verbal communication Education: Associate's or Bachelor's Degree preferred.   qualifications: Experience level: ExperiencedMinimum 5 years of experienceEducation: Bachelors  skills: Data WarehouseETLData Warehouse 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 HRsupport@randstadusa.com. 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.

job summary: We recently completed an implementation of People Analytics solution on Oracle ADW and Oracle Analytics Cloud, which sources data from Oracle Fusion Cloud HCM Implementation and other internal Edge Systems. We are seeking an experienced, Senior Oracle ODI ETL and OAC BI Developer for designing, developing, and maintaining ETL processes using Oracle Data Integrator (ODI) and creating business intelligence solutions with Oracle Analytics Cloud (OAC). This assignment primarily involves remote work. It is a contract position with the potential for full-time employment for candidates who meet the eligibility criteria.   location: New York, New York job type: Contract salary: $65 - 68 per hour work hours: 8am to 4pm education: Bachelors   responsibilities: Job Description We recently completed an implementation of People Analytics solution on Oracle ADW and Oracle Analytics Cloud, which sources data from Oracle Fusion Cloud HCM Implementation and other internal Edge Systems. We are seeking an experienced, Senior Oracle ODI ETL and OAC BI Developer for designing, developing, and maintaining ETL processes using Oracle Data Integrator (ODI) and creating business intelligence solutions with Oracle Analytics Cloud (OAC). This assignment primarily involves remote work. It is a contract position with the potential for full-time employment for candidates who meet the eligibility criteria. Responsibilities Lead the design & development, and management of end-to-end ETL processes using Oracle Data Integrator (ODI).Develop and implement BI solutions using Oracle Analytics Cloud (OAC), including dashboards, reports, and data visualizations.Optimize ETL workflows and BI solutions to enhance performance and scalability.Collaborate with stakeholders to understand their business needs and develop solutions that meet those needs.Identify and resolve complex ETL and BI issues in a timely manner.Create and maintain comprehensive documentation for ETL processes, BI solutions, and best practices.Provide technical guidance and mentorship to team membersProvide on-call support of Data Integration Batch processes on a rotating basis and other on-call as requiredLead and oversee technical teams to ensure timely delivery of high-quality solutions. Must be proficient in understanding and triaging complex software issuesMust have 3+ years of experience in developing and implementing BI solutions using Oracle Analytics Cloud (OAC), including dashboards, reports, and data visualizations.Must have ability to multitask under pressure handling various deadlinesMust have at least 5 years of advanced skills in SQL & PL/SQL and data querying (including writing advanced select statements, stored procedures, and functions) experienceMust have at least 5 years of experience building scalable and reliable ETL to pull large and complex data together from different systems using Oracle Data Integrator.Must have basic knowledge of REST APIs and able to test using POSTMANMust have hands on experience in Data Model design and development and optimizing the performance of data warehouseMust have knowledge of cloud computing principles, including SaaS, PaaS and knowledge of working on a Cloud based database platform like ADW.Must have strong aptitude to isolate problems, addressing immediate needs, analyzing ramifications, and implementing solutionsMust have strong verbal and written communication skills to describe and report issues in non-technical languageMust possess strong analytical skills and must be highly proficient with Excel, Word & PowerPoint Nice To Have Experience supporting Oracle ORDS REST APIs is a plusExperience with Oracle BICC Extracts and PVOs from Oracle Fusion Cloud HCM is a plus   qualifications: Experience level: ExperiencedMinimum 4 years of experienceEducation: Bachelors  skills: Oracle ODI DeveloperEnterprise Application SupportOracle Analytics Cloud 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 HRsupport@randstadusa.com. 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. It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

job summary: Enterprise Healthcare client has an immediate opening for a highly motivated Business Analytics Advisor to join their dynamic and growing team. All qualified candidates are encouraged to apply! Candidate must have experience working in an Agile environment and with being a collaborative member of an Agile team. Candidate must be good communicator and have people skills.   location: Morristown, New Jersey job type: Contract salary: $48.41 - 58.41 per hour work hours: 8am to 5pm education: Bachelors   responsibilities: Seeking Teradata SQL developer/lead and data analyst with experience working on an IBM Mainframe to build custom output files for our clients/vendors. Candidates will need to quickly get familiar with the Enterprise Data Warehouse that sources our output data and be able to write SQL queries to extract the data needed to deliver on client requirements.   qualifications: Experience level: ExperiencedMinimum 5 years of experienceEducation: Bachelors  skills: MainframeBusiness Analysis 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 HRsupport@randstadusa.com. 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.