Datasphere Developer Analyst

Swagelok Company•Solon, OH

13d•Hybrid

About The Position

Swagelok is seeking a hands-on SAP Datasphere developer to build reliable SAP data objects from extraction through curated reporting structures. The role’s primary technical focus is SAP Datasphere and ODP extractors, including full-load and delta-load scenarios. Microsoft Fabric experience is valuable but secondary, with emphasis on how Datasphere outputs support Fabric Warehouses, Dataflow Gen2, Power Query, SQL, and Power BI reporting. The position serves as a full-lifecycle developer for supported solutions and applications. The developer participates in requirements gathering and analysis, solution design and architecture, application and interface development, testing, documentation, deployment, production support, and ongoing maintenance and enhancements. The role works closely with business stakeholders, subject-matter experts, project teams, and IT colleagues to turn business requests and design specifications into documented, scalable solutions. The role also addresses production application and systems problems, performs peer design and code reviews, and applies enterprise standards and quality processes. It designs and optimizes database objects and queries, reports task effort and duration, works independently when appropriate, and maintains current technical knowledge. Some off-hours support may be necessary. The working environment is a normal office environment, and travel between locations in Ohio and Pennsylvania may be needed.

Requirements

Bachelor’s degree in Computer Science, Data Science, Mathematics, Engineering, or Business, or equivalent experience.
Typically requires a college or university degree or equivalent work experience providing knowledge of fundamental theories, principles, and software development concepts.
At least 7 years of experience in enterprise solution programming.
Required experience in SAP Datasphere.
Expert hands-on ability to create, maintain, and troubleshoot SAP Datasphere tables, views, data flows, replication flows, and analytical models.
Expert ability to use ODP extractors for SAP ingestion, including full-load and delta-load scenarios.
Advanced understanding of SAP ECC / S/4HANA source structures, extractor behavior, and SAP-delivered business logic.
Expert ability to design curated Datasphere models for reporting, analytics, reusable dimensions, and governed consumption layers.
Expert ability to validate and reconcile data, troubleshoot performance, and resolve source-to-target issues.
Ability to define high-level application standards, help others understand those standards, and architect solutions to meet organizational needs.
Ability to develop documented, scalable coding solutions and adhere to development, coding, and quality assurance standards.
Ability to communicate effectively in small and large groups and settings.
Ability to travel between multiple locations in Ohio and Pennsylvania as needed.
Ability to operate standard office equipment, including a computer, telephone, copier, and printer.
Ability to safely and successfully perform essential job functions and meet qualitative and quantitative productivity standards.
Ability to maintain regular, punctual attendance.

Nice To Haves

Experience in SAP BW/BOBJ.
Proficient working knowledge of Microsoft Fabric workspaces, including environment organization, access management, and collaboration.
Proficient use of Fabric Warehouses, Dataflow Gen2, Power Query / M, and SQL for data preparation, validation, and reporting support.
Proficient ability to prepare clean, governed data structures for Power BI semantic models and reports.
Advanced understanding of how SAP Datasphere and Microsoft Fabric fit together in a modern analytics architecture.

Responsibilities

Perform key parts of the system development lifecycle, including requirements gathering and analysis; solution design and architecture; application and interface development; unit, integration, and user acceptance testing; documentation and knowledge transfer; deployment, installation, and production support; and ongoing maintenance and enhancements.
Build, maintain, and troubleshoot SAP Datasphere objects, including tables, views, data flows, replication flows, and analytical models.
Use ODP extractors as the primary SAP data ingestion pattern, including full-load and delta-load scenarios.
Design curated Datasphere models for reporting, analytics, reusable dimensions, and governed consumption layers.
Work with business stakeholders, subject-matter experts, project teams, and IT colleagues to translate requests and logical design specifications into documented, scalable solutions.
Document work requests, technical details, operational support information, and application knowledge bases.
Respond to production application and systems problems and drive or support analysis and remediation.
Perform peer design and code reviews and promote adherence to enterprise application and analytics standards, development best practices, coding standards, and quality assurance processes.
Design, develop, and optimize database objects and queries using relational database design principles and performance-tuning techniques.
Perform data validation, reconciliation, performance troubleshooting, and source-to-target issue resolution.
Support data preparation, validation, and reporting using Fabric Warehouses, Dataflow Gen2, Power Query / M, and SQL; prepare governed data structures for Power BI semantic models and reports.
Report effort and duration for assigned tasks, manage work toward performance goals, and work independently when appropriate.
Maintain technical knowledge of IT trends and emerging technologies, and participate in department meetings and projects as requested.