Job Information
Robert Half Data Architect (Life Sciences Industry) in Fort Lee, New Jersey
Description
This role will be responsible for designing databases and data structures for multiple systems including analytical data stored in the Data Warehouse. This role will be responsible for instituting best practices and policies around designing flexible data warehouses and business intelligence for multiple use cases to support all departments driving efficiency and maximizing revenue generation.
DUTIES AND RESPONSIBILITIES:
Designs, develops, and maintains data models and toolsets to support growing global Data Warehouse.
Develops ETL tools and processes for data extraction, normalization, integration, and processing of data into the data warehouse.
Develops policies and procedures for the collection and analysis of data to ensure accuracy and integrity from source to destination.
Coordinates with IT Infrastructure team to deploy software and hardware upgrades that allows for large data use cases.
Implements new data analysis methodologies and BI strategies.
Performs data profiling to identify and understand anomalies.
Develops and analyzes SQL queries (Oracle and Microsoft) to support business operations and regulatory audits.
Creates technical and functional specifications for new designs and collaborates with team members to obtain approvals.
Liaises with QA on compliance and validation issues.
Other job-related responsibilities as required.
Requirements
Proficient in Microsoft SQL Server (SSMS, SSIS, SSAS, SSRS), Power BI and ETL tools and best practices.
Experience with Oracle OLTP and OLAP preferred.
Ability to understand and find appropriate applications for data and analysis results.
Proficient in SQL Query language
Specific Responsibilities/Duties
EDUCATION, QUALIFICATIONS EXPERIENCE:
Bachelor's degree in computer science or related field required.
Minimum five years' experience in a Data Warehouse business intelligence, data mining and data architecture role, preferably in a life sciences or other regulated environment.
Technology Doesn't Change the World, People Do.®
Robert Half is the world’s first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.
Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. Download the Robert Half app (https://www.roberthalf.com/us/en/mobile-app) and get 1-tap apply, notifications of AI-matched jobs, and much more.
All applicants applying for U.S. job openings must be legally authorized to work in the United States. Benefits are available to contract/temporary professionals, including medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit roberthalf.gobenefits.net for more information.
© 2024 Robert Half. An Equal Opportunity Employer. M/F/Disability/Veterans. By clicking “Apply Now,” you’re agreeing to Robert Half’s Terms of Use (https:///www.roberthalf.com/us/en/terms) .