Data Architect - Data Services Specialist

Department: Information Technology

Employment Type: Permanent - Full Time

Location: US (Remote)

Reporting To: Senior Manager - Enterprise Data & Business Intelligence

Description

Key Responsibilities

• Develop and deliver long-term strategic goals for company data architecture and standards in conjunction with various corporate and business functions – Finance & Accounting, Operations, Clinical Affairs, Business Units, Product Development, Regulatory Affairs, External Customers and other key stakeholders.
• Gather and review business requirements and processes, conduct in-person interviews or workshops, profile source system(s) data, documentation, analysis, and design of proposed systems. This specific role focuses on data decomposition and building conceptual models.
• Translate Business Requirements Documents (BRDs) and/or User Stories into viable conceptual, and subsequently, logical data models and design artifacts in conformance with existing standards and conventions.
• Develop mapping documents that demonstrate data lineage and relationships.·         
• Establish processes for governing the identification, collection, and use of corporate and clinical metadata; take steps to assure metadata accuracy and validity.
• Establish methods and procedures for tracking data quality, completeness, redundancy, and improvement.
• Conduct enterprise data capacity planning, life cycle, duration, usage requirements, feasibility studies, and other tasks.
• Create strategies and plans for enterprise data security, backup, disaster recovery, business continuity, and archiving.
• Performs visualization design; completes challenging visualization projects independently; utilizes good sensibility in visual storytelling.
• Partners with other clinical, BU, business and corporate stakeholders to develop reports that provide meaningful clinical, product and business data and information.
• Assess and determine governance, stewardship, and frameworks for managing enterprise data across the organization in collaboration with the VP of Business Systems & Services.
• Develop and promote data management methodologies and standards that are within regulatory compliance.
• Lead the mapping of enterprise data sources, data movement, interfaces, and analytics, with the goal of ensuring data quality.
• Build out the company’s data architecture and data models.
• Address enterprise data-related problems regarding systems integration, compatibility, and multiple-platform integration.
• Develop and implement key components as needed to create testing criteria in order to guarantee the fidelity and performance of the data architecture.
• Document the data architecture and environment in order to maintain a current and accurate view of the larger data picture.
• Identify and develop opportunities for data reuse, migration, or retirement.
• Knowing and applying Exactech's Quality Management System and any appropriate federal and international standards.
• Assist and support other employees, teams, and sales personnel as necessary. 

Skills Knowledge and Expertise

• Bachelor's Degree in a related field from an accredited institution required.

• A minimum of 5 years' experience in hands-on technical leadership, project management, process development and resource management.
• 7+ years' work experience as a data or information architect.
• 7+ years' work experience as an ETL developer using SAP Data Services
• 7 years' experience working with modeling tools (e.g., one or more of the following: SAP Power Designer, ER/Win, ER/Studio or other similar tools).
• 7 years of relevant data analysis; experience with database query and analysis languages (e.g., SQL, R, SAS, Python) and data visualization tools (e.g., SAP BI Platform, SAP Analytics Cloud,  and Microsoft Power BI).
• Ability to interpret complex statistical data.

• Hands-on experience with data architecting, data mining, large-scale data modeling, and business requirements gathering/analysis.
• Direct experience in implementing data management processes, procedures, and decision support.
• Strong understanding of relational data structures, theories, principles, and practices.
• Strong familiarity with metadata management and associated processes.
• Hands-on knowledge of enterprise repository tools, data modeling tools, data mapping tools, and data profiling tools.
• Demonstrated expertise with repository creation, and data and information system life cycle methodologies.
• Experience with business requirements and process analysis, entity relationship planning, database design, reporting structures, and so on.
• Ability to manage data and metadata migration.
• Excellent client/user interaction skills to determine requirements.
• Ability to effectively build and maintain relationships with business stakeholders and end user as well as other IT teams.
• Ability to exercise sound judgment and make decisions based on accurate and timely analysis.
• Demonstrated ability to define, develop, and analyze performance measures and metrics
• Solid experience utilizing and implementing relational and non-relational data storage models.
• Expert knowledge of system and software quality assurance best practices and methodologies.

• Understanding of Web services (SOAP, XML, UDDI, WSDL) and open APls.
• Broad understanding of various cloud development technologies and trends.
• Good knowledge of applicable data privacy practices and laws.
• Experience developing and supporting mission critical applications optimized to run in the cloud or virtualized environments.
• Strong experience with SDLC, Agile methodologies, Microservices, API, EDI, and public and private cloud technologies.
• Deep knowledge of system architecture, technical design, system and software development technology, scalability, availability and performance considerations.
• Has knowledge of emerging trends and developments in PaaS, Saas, iOS/Android mobile app API, cloud, Al, Machine Learning and other digital technologies.
• Strong experience with common and reliable Web and Mobile application development.
• Object oriented programming experience (e.g., using Java, J2EE, EJB, .NET, WebSphere, etc.).
• Strong scripting skills (R, Python).
• Solid experience with the following technologies:
  o    SAP BI Platform – Universes (Information Design Tool), WEBI.
  o    SAP Analytics Cloud
  o    SAP HANA
  o    Microsoft Power BI