Snowflake Analyst SAP S​/Integration Security Clearance

Position: Snowflake Analyst SAP S/4 Integration with Security Clearance
PDS Defense, Inc. is seeking a Snowflake Analyst - SAP S/4 Integration, in Richardson, TX. Job

Job Description:

The Snowflake Analyst is responsible for reverse engineering existing data solutions, translating business requirements into functional and technical specifications, and enabling seamless integration of SAP S/4

HANA data into enterprise data products. This role bridges architecture, data engineering, and business analysis by deeply understanding source system structures and transforming them into optimized Snowflake based models.
________________________________________

Key Responsibilities

• Analyze existing data products, pipelines, and data models to reverse engineer solution logic, dependencies, and transformation rules.

• Work with SAP functional and technical teams to understand SAP S/4

HANA data structures (tables, CDS views, IDocs, APIs, etc.) and map them into Snowflake models.

• Design and document functional specifications and detailed technical specifications for integrating SAP S/4

HANA data into Snowflake and downstream data products.

• Evaluate SAP source data for quality, completeness, and alignment with business reporting needs.

• Collaborate with architects and data engineers to define ingestion frameworks, staging layers, data transformations, and semantic models.

• Translate business use cases into robust data requirements, ensuring consistency across enterprise data domains.

• Prepare lineage documentation, data dictionaries, mapping documents, and interface specifications.

• Support testing efforts by defining test scenarios, validating data transformations, and troubleshooting data issues across the ingestion pipelines.

• Recommend improvements to existing Snowflake models, warehouse configurations, and transformation logic based on findings from reverse engineering activities.

• Ensure compliance with data governance, security policies, and best practices for SAP/Snowflake integration.
________________________________________
Required Skills & Experience

• Strong proficiency with Snowflake (warehousing concepts, schema design, performance optimization, SQL).

• Experience interpreting SAP S/4 data structures, including modules such as FI/CO, MM, SD, or PP.

• Ability to read and understand SAP metadata from tables, CDS views, SAP extractors, or SAP BW artifacts.

• Knowledge of ELT/ETL frameworks, data modeling concepts, and data pipeline architectures.

• Demonstrated ability to reverse engineer existing datasets, views, or dashboards.

• High competency in writing detailed functional and technical specifications.

• Strong communication and collaboration skills, especially in cross functional SAP/Data Engineering environments.
________________________________________

Preferred Qualifications

• Prior work in large enterprise SAP landscapes.

• Understanding of cloud architectures (Azure, AWS, GCP), particularly Snowflake native services. Education/

Experience:

Typically requires a degree in Technology, Engineering or Data Science unless prohibited by local laws/regulations and minimum 2 years of prior relevant experience or an Advanced Degree in a related field or in absence of a degree, 6 years of relevant experience. Citizenship: MUST BE US CITIZEN ONLY
** Benefits offered to vary by the contract. Depending on your temporary assignment, benefits may include direct deposit, free career counseling services, 401(k), select paid holidays, short-term disability insurance, skills training, employee referral bonus, affordable medical coverage plan, and Daily Pay (in some locations). For a full description of benefits available to you, be sure to talk with your recruiter. Military connected talent encouraged to apply.

VEVRAA Federal Contractor / Request Priority Protected Veteran Referrals / Equal Opportunity Employer / Veterans / Disabled To read our Candidate Privacy Information Statement, which explains how we will use your information, please visit  or  The Company will consider qualified applicants with arrest and conviction records in accordance with federal, state, and local laws and/or security clearance requirements, including, as applicable:
* The California Fair Chance Act

* Los Angeles City Fair Chance Ordinance

* Los Angeles County Fair Chance Ordinance for Employers

* San Francisco Fair Chance Ordinance