Datasphere Developer Analyst

Swagelok is a global organization and one of the largest employers of manufacturing talent in Northeast Ohio. We are driven by our core values of Quality, Integrity, Respect for the Individual, Customer Focus, Innovation, and Continuous Improvement, which are demonstrated through our daily actions. For over 75 years, our dedication to our core values has been the foundation for our success. Our products have been up into space, down to the bottom of the ocean, and everywhere in between. That same dedication spans to our customers. Throughout our organization we demonstrate a commitment to these values and those we bring onboard. Whether you want to grow in your role or explore broad opportunities and develop new skills—you’ll thrive in a culture that promotes learning and development. We strive to be a company where we all can do our best work with a true sense of purpose and belonging.  Be Connected. Be Valued. Be You. We hope you’ll consider joining our team. This role is for a hands-on SAP Datasphere developer who supports the can build reliable SAP data objects from extraction through curated reporting structures. Strong ODP extractor experience is the key requirement. Microsoft Fabric experience is valuable, but secondary, with emphasis on understanding how Datasphere output supports Fabric Warehouses, Dataflow Gen2, Power Query, SQL, and Power BI reporting. Role will be responsible for acting as a full lifecycle developer for their supported solutions and applications.Essential Duties and Responsibilities:Performs key portions of the System Development Lifecycle below: Requirements gathering and analysisSolution design and architectureApplication and interface developmentUnit, integration and user acceptance testingDocumentation and knowledge transferDeployment, installation, and production supportOngoing maintenance enhancements.Develops and fosters close working relationships with LOB stakeholders, subject-matter experts, project teams, and other IT team members to translate informal business stakeholder/architect requests and/or written logical design specifications into documented, scalable coding solutions. Documentation may include, but not be limited to, updating work requests, technical documentation, operation support documentation, and application knowledge bases. Responds to production application and systems problems and drives or supports the analysis and remediation efforts. Some off hours support as necessary. Performs peer design and code reviews while promoting and adhering to enterprise application and analytics standards, development best practices, coding standards, and quality assurance processes. Assists other team members in the consistent application of these standards as appropriate.Designs, develops, and optimizes database objects and queries while applying sound relational database design principles and performance tuning techniques.Reports effort and duration to leadership for assigned tasks while working independently without leadership direction when appropriate.Effectively manages himself or herself to meet or exceed established performance goals (i.e.; efficiency, effectiveness, utilization, etc.) with potential responsibility for leading projects with moderate resource requirements, risk and/or complexity. Improves personal and professional technical knowledge and expertise including, but not limited to, maintaining current knowledge of IT trends and emerging technologies to support the definition and adoption of new development approaches and technology.Participates in department meetings and departmental projects, as requested.Education and/or Experience Requirements:Education: Bachelor’s Degree in Computer Science, Data Science, Mathematics, Engineering, Business or equivalent experience required.Experience: Typically requires a college or university degree or the equivalent work experience that provides knowledge and exposure to fundamental theories, principles and software development concepts as well as defining high level application standards, helps others understand those standards and architect solutions to meet the organizational needs.7+ years of experience of enterprise solution programming, including required experience in SAP Datasphere and preferred experience in SAP BW/BOBJ. Education: Bachelor’s Degree in Computer Science, Data Science, Mathematics, Engineering, Business or equivalent experience required.Experience: Typically requires a college or university degree or the equivalent work experience that provides knowledge and exposure to fundamental theories, principles and software development concepts as well as defining high level application standards, helps others understand those standards and architect solutions to meet the organizational needs.7+ years of experience of enterprise solution programming, including required experience in SAP Datasphere and preferred experience in SAP BW/BOBJ. Skills/Knowledge: SAP Datasphere Developer Skills and Proficiency SummaryPrimary NeedHands-on SAP Datasphere developer experienced in building Datasphere objects using ODP extractors, delta extraction patterns, and related SAP integration tools.Secondary NeedWorking knowledge of Microsoft Fabric workspaces, Warehouses, Dataflow Gen2, Power Query, SQL, and Power BI integration.Primary Technical Skills: SAP Datasphere and ODP ExtractorsCapabilityExpected ProficiencyCreate, maintain, and troubleshoot SAP Datasphere objects, including tables, views, data flows, replication flows, and analytical models.ExpertUse ODP extractors as the primary SAP data ingestion pattern, including full-load and delta-load scenarios.ExpertUnderstand SAP ECC / S/4HANA source structures, extractor behavior, and SAP-delivered business logic.AdvancedDesign curated Datasphere models for reporting, analytics, reusable dimensions, and governed consumption layers.ExpertPerform data validation, reconciliation, performance troubleshooting, and source-to-target issue resolution.ExpertSecondary Technical Skills: Microsoft Fabric and Power BI EcosystemCapabilityExpected ProficiencyWork within Microsoft Fabric workspaces, including environment organization, access management, and collaboration.ProficientUse Fabric Warehouses, Dataflow Gen2, Power Query / M, and SQL for data preparation, validation, and reporting support.ProficientPrepare clean, governed data structures for Power BI semantic models and reports.ProficientUnderstand how SAP Datasphere and Microsoft Fabric fit together in a modern analytics architecture.AdvancedWorking conditions and/or Physical Requirements:Working conditions associated with normal office environment.Ability to operate standard office equipment (e.g., computer, telephone, copier, printer, etc.).Ability to effectively communicate in both small and large groups and settings.Ability to traverse between multiple locations in Ohio and Pennsylvania as needed.Ability to safely and successfully perform the essential job functions consistent with the ADA, FMLA and other federal, state, and local standards, including meeting qualitative and quantitative productivity standards.Ability to maintain regular, punctual attendance consistent with the ADA, FMLA and other federal, state, and local standards.Swagelok provides a comprehensive package of valuable benefits called Total Rewards focused on health and wellness, compensation, retirement planning, and supplemental rewards.  To apply: 1. Click ‘Apply Now’ to the role of interest, upload your resume and complete the application.2. Those that match our qualifications will be contacted to schedule a phone interview. Congratulations on taking the first step to Be Connected. Be Valued. Be You. Swagelok is proud to be an Equal Opportunity Employer.  Applicants are selected without regard to race, ethnicity, creed, color, religion, sex, pregnancy, pregnancy-related medical conditions, age, national origin or ancestry, disability, genetic information, veteran/military status, sexual orientation, gender identity, or other protected characteristic under federal, state or local law. Swagelok will make reasonable accommodations in compliance with the Americans with Disabilities Act of 1990, the Americans with Disabilities Act Amendments Act of 2008, and Ohio state law.  This job summary is intended to be brief and does not list all the duties for this position. Nothing in this job description should be construed as an express or implied contract of employment. Swagelok is an at-will employer, which means that either party is free to terminate the employment relationship at any time, without any advanced notice, for any reason or no reason.  #LI-LK1#LI-HybridJob SummaryJob number: 15234Profession: Information Technology