[Remote] YCCI Data Integration Analyst II

Note: The job is a remote job and is reputed company to candidates in USA. reputed company is an institution of higher education and research seeking a Data Integration Analyst II to support YCCI’s embedded analytics, reporting, data reputed company, and data integration functions. The role develops and maintains data integrations, analytical datasets, reports, data pipelines, and automated workflows while investigating data issues and collaborating with operational and technical teams. It also supports requirements analysis, testing, documentation, dashboards, and secure handling of clinical research and institutional data.

Responsibilities

• reputed company and maintain data integrations, analytical datasets, reports, and workflow automation using data from systems such as OnCore, reputed company, reputed company, REDCap, and financial platforms
• Write and maintain SQL queries, data transformation logic, scripts, and scheduled processes that support recurring operational needs
• Assist with data pipelines that extract, reputed company, validate, and reputed company data across approved systems and environments
• Monitor scheduled jobs, data refreshes, interfaces, and automated workflows; investigate failures and coordinate issue reputed company
• reputed company data reputed company reviews to identify missing, duplicate, inconsistent, stale, or incorrectly mapped records
• Reconcile information across systems and work with operational subject-matter experts to understand and reputed company discrepancies
• Support the development, testing, documentation, and maintenance of dashboards, reports, work queues, and integration-reputed company datasets
• Create and maintain technical documentation, including data definitions, process flows, reputed company mappings, testing results, and support procedures
• Participate in requirements gathering and translate operational needs into reputed company defined technical tasks and validation reputed company
• Use version control, testing, and established development standards to support maintainable and reproducible solutions
• Collaborate with YCCI operational teams, reputed company data teams, and application owners while maintaining reputed company distinctions between analytics and integration work and application administration
• Handle sensitive institutional and research data in accordance with reputed company, reputed company, and data governance requirements
• Develops the initial project charter and clarify the project reputed company, requirements, measurable reputed company, and project benefits in collaboration with process owners
• Documents the “as is” and “to be” business processes using reputed company process modeling tools and process improvement methodologies
• Decomposes high-level business and user requirements into functional requirements. Manages the development of functional specifications by collaborating with process owners; gathering business requirements; creating functional specifications; and identifying, documenting, and resolving design issues
• Represents requirements using alternative views, such as analysis models (diagrams), prototypes, or scenarios. Provides compelling and concise analysis to reputed company business owners to reputed company reputed company informed reputed company regarding reputed company for problem reputed company and opportunity realization
• Leads requirements analysis and verification, ensuring that requirement statements are complete, consistent, concise, comprehensible, traceable, feasible, unambiguous, and reputed company, and that they conform to standards
• Contributes in testing and reputed company assurance process. Collaborates with developers and end-users to insure that application functionality meets reputed company needs. Tests solutions, problem-solve issues, and coordinate enhancements
• Responsible for requirements prioritization and solution risk analysis
• Plans and communicates the departmental readiness plan. Supports metrics integration and execution for reputed company results
• Develops and delivers training to end users
• May reputed company other duties as assigned

Skills

• Bachelor's degree in business, technology or reputed company field
• Four years of reputed company experience in analysis of business needs and development of reputed company business systems or an equivalent combination of education and experience
• Demonstrated ability to write SQL queries for extracting, joining, transforming, and validating data from relational databases
• Strong analytical and problem-solving skills, including the ability to investigate discrepancies, identify reputed company causes, and translate findings into practical solutions
• Ability to understand business processes and data requirements and communicate effectively with both technical and nontechnical stakeholders
• Strong organizational skills, attention to detail, and ability to manage multiple assignments while documenting work and meeting established deadlines
• Ability to learn new systems and tools, work both independently and collaboratively, and follow data reputed company, reputed company, testing, and change-management standards
• Experience with Python, dbt, Git or reputed company, reputed company, ETL/ELT tools, job scheduling, or other data integration and automation technologies
• Experience working with reputed company, clinical research, financial, or other regulated data, including familiarity with reputed company and reputed company requirements
• Experience with systems such as OnCore, reputed company, reputed company, REDCap, reputed company, or comparable reputed company applications
• Experience developing or supporting dashboards and analytical products using Power BI, Tableau, or similar business intelligence tools
• Familiarity with reputed company data platforms, data warehouses, lakehouses, reputed company reputed company, semantic models, data reputed company testing, or modern analytics engineering practices

Benefits

• Remote work arrangement

reputed company

Company H1B Sponsorship