Facilitate and drive MDM/data integration business requirement workshops and joint application design sessions. Translate business requirements into clear MDM ELT/ETL techno-functional detailed requirements.
Drive the end-to-end solution data movement design of MDM ELT/ETL solutions including data migration strategy, data quality assessment, performance, remediation design, disaster recovery, data stewardship processes and system interaction designs.
Owns design for the overall MDM ELT/ETL solution data integration with broader source application data and analytical integration along with creation of high-level and detailed level ELT/ETL design specifications.
Coordinate with middleware/integration product teams on end-to-end integration solutions.
Develop and prototype solutions in Reltio as a hands-on MDM and PowerCenter development engineer.
Execute full software development life cycle (SDLC) and agile development of data acquisition & movement ELT/ETL solutions supporting the Bioclinica MDM & Data Warehousing solutions. Designing, developing, maintaining, and supporting functionality of fault tolerant scalable programs. Manages software versioning.
Creates work estimations, writes well-designed, testable, secure code using Informatica PowerCenter & PL/SQL as a member of a highly performant data & analytics MDM development team.
Perform detailed data analysis to understand source system data and source to target mapping.
Develop & unit test Informatica ELT/ETL data loading processes for optimal performance based upon Service Level Agreements (SLAs) and business requirements.
Determine operational feasibility of proposed solution designs.
Performance tune Informatica PowerCenter ELT/ETL mappings and report queries.
Identify, recommend, and implement ELT/ETL process and software continuous improvements.
Coordinate development projects, retrofit, maintain the versioning, and perform the Informatica deployments. Serves as Reltio, and PowerCenter Administrator for production.
Conducts root cause analysis on application and data issues throughout the life cycle of the project. Triages issues reported by users in production systems. Troubleshoots system failures and assesses root cause. Troubleshoot, debug and upgrade existing systems.
Provide level 3-4 support on ServiceNow product support tickets. Ensures all daily data load processes have fully executed and triages all failed data loads for successful daily execution. Creates alerts for failed jobs.
Performs software solution capability reviews and presentations with technical and business colleagues as required.
Communicates effectively with team, stakeholders, and other operations personnel on the successful execution of information systems development & integration deliverables. Effectively escalates issues proactively to ensure timely delivery.
Documenting the MDM cloud-based data integration environment and procedures to ensure the AWS/MDM Reltio platform remains cost effective, efficient, and of high quality.
Complying with related training programs of development staff (GCP, 21 CFR Part 11, CAPA).
Contributes to team effort by
Working with internal staff including product/project managers, application teams, business colleagues, consultants, and QA/operations support staff to assist with the development of project specifications.
Exploring new opportunities to add value to organization and departmental processes.
Helping others to achieve results.
Performing other duties as assigned.
Maintains Quality Service and Departmental Standards by
Reading, understanding, and adhering to organizational SOPs.
Reviewing and updating company SOPs related to Data & Analytics Services.
Maintains Technical and Industry Knowledge by
Maintaining a strong understanding of Data & Analytics, ELT/ETL and MDM trends and technologies.
Maintaining a strong understanding of the regulatory requirements applicable to software development in clinical trials.
Bachelor s degree in computer science, information technology or equivalent professional experience required
3 years experience working on MDM & data warehousing/management related projects/solutions with at least 2 years of MDM implementation experience, ideally including solutions involving the Reltio Platform.
3 years progressive experience in providing technology solutions and services in a global organization.
Proven 3 years in software development or programming experience as a Data Warehousing Software Engineer in large-scale ELT/ETL Informatica PowerCenter (v9.1 or higher), PL/SQL & PWX Connectors.
2 Years hands-on experience using Informatica s Data Quality Developer, and Data Quality Analyst tool. PowerBI, Tableau, SSIS, .Net experience a Plus.
Must have expert understanding of Master Data Management (MDM) architectures, business processes data validation, match and merge/survivorship rule, REST API s, project life cycles, and best practices.
Proven experience conducting data analysis, profiling, cleansing, exception handling within MDM ELT//ETL processes, matching, ELT/ETL business rule implementation, standardization, and quality practices.
Proven knowledge of Informatica PowerCenter ETL processes, best practices, installation, configuration, and administration.
Demonstrated expert knowledge of PL/SQL programming and relational database design on the Snowflake database platform. MS SQL Server, and MS-SQL a plus.
Experience in operationalizing MDM solutions, job schedule, workflow management, alerts, and notifications. Experience in Data Governance and Stewardship programs. Familiarity with reference data management, data transformation, data cleansing and standardization
Exhibits knowledge across a wide breadth of design and development related technical principles, practices, and procedures.
Ability to drive results with an emphasis on reducing cycle time and increasing speed to market of new products.
Possesses knowledge about industry best-practices in solution delivery disciplines.
Knowledge of latest trends in cloud infrastructure and migration application in private/hybrid cloud models.
Additional skill sets:
Experience working in a fast-paced green field MDM environment with competing priorities, while effectively managing time and project workload expectations.
A demonstrated passion for the value of enterprise data assets.
Highly motivated self-starter. A drive to learn and master new technologies, techniques, and data sources. Continuous learning is key to success in this position. Ability to multi-task.
Strong analytical, organizational, verbal communication and business writing skills.
Strong problem-solving, troubleshooting, de-bugging skills. Flexible. Adaptable. Strong attention to detail.
Strong ability to collaborate with architects, developers, product managers, testers, and business colleagues.
Critical thinking abilities to take complex, ambiguous, abstract requirements and break them into smaller components, patterns, views, features and work epics, themes, stories. Ability to conceptualize and think creatively. Able to take initiative and be innovative. Goal-oriented.
Ability to maintain professional and positive attitude.
Understanding of medical and/or clinical trial terminology is desirable.
Strong understanding of SDLC best practices within DW/BI practices and excellent at SQL skills.
Experience working with vendor product support / professional services teams and documentation to resolve complex solutions and product issues/limitations.
Ability to define and develop work estimates, collaborate on an agile project schedule, and contribute to project plans through documentation of tasks and requirements in an agile board.
Ability to work in group setting and independently; ability to adjust to changing priorities.
Excellent attention and orientation toward meticulous work.
Fluent in reading, writing, and speaking English.
Travel – 0-15%
Lifting – 0-10 lbs.
Other – Computer work for long periods of time
This JOB description should not be deemed all-inclusive. Additional requirements and expectations may be assigned. At all times, employees are expected to adhere to company policies and company SOPs.
Bioclinica is an equal opportunity employer. Bioclinica evaluates qualified applicants without regard to race, color, religion, gender, national origin, age, sexual orientation, gender identity or expression, protected veteran status, disability/handicap status, or any other legally protected characteristic.
Collaboration, Continuous Learning, Critical Thinking, Operational Excellence, Organizational Awareness, Results Orientation, Service Orientation,
Recruiter detailsCompany Name: BioClinicaCompany Description:
Bioclinica is the leader in scientifically-driven services and technology-enabled solutions in clinical research. Clinical trials are complex, and traditional approaches are either monolithic or fragmented. Successful trials require an ability to see key details and uncover hidden insights. Employing our scientifically-driven and technology-enabled approach, Bioclinica brings CLARITY to clinical trials for better decisions. With such clarity comes the insight to help trial sponsors and Clinical Research Organizations (CROs) develop new life-improving therapies more efficiently and safely ? and with improved quality outcomes.