You will design and implement scalable data solutions to support business intelligence and analytics efforts.
Responsibilities
- Design and develop complex SQL queries, stored procedures, and functions for data extraction and transformation.
- Build and maintain scalable data warehouse solutions using Snowflake infrastructure.
- Implement data warehousing best practices, including fact table modeling, handling changing dimensions, and data integrity checks.
- Extract and integrate data from Salesforce Data Cloud, Salesforce Workbench, and Salesforce objects.
- Develop CDS Views and work within SAP Datasphere for data modeling and extraction.
- Deploy Power BI dashboards, reports, datasets, and data models to support decision making.
Required Skills
- 5+ years of experience in data engineering or business intelligence roles.
- Advanced SQL development including stored procedures, complex joins, window functions, and performance tuning.
- Hands-on experience with Snowflake architecture and tools.
- In-depth understanding of data warehousing concepts such as star/snowflake schemas, SCDs, and fact/dimension tables.
- Proven experience with Salesforce data extraction and manipulation.
- Hands-on experience with SAP Datasphere and Core Data Services (CDS) Views.
- Solid experience with Power BI report creation, data modeling, and publishing.
- Bachelor's or Master's degree in Computer Science, Information Systems, or a related field.
Preferred Skills
- Experience building data loading pipelines from SAP S/4HANA, Salesforce, and FTP sources.
- Familiarity with S/4HANA data models and CDS view architecture.
- Experience with Microsoft Fabric for data architecture and analytics configuration.
- Certifications in Snowflake, Power BI, or SAP Analytics.