RxSense

Data Engineer

• Analyze and interpret complex data Ability to identify data anomalies and resolve data issues.
• Understand speciﬁc business processes and domain concepts and relate them to data subject domains.
• Optimize SQL queries, scripts, and stored procedures in Snowﬂake and SQL Server to improve eﬃciency and reduce processing time.
• Integrate and manage data from various sources, ensuring data quality, reliability, and performance
• Design, develop, and maintain scalable and high-performance ETL pipelines using Matillion ETL to ingest, transform, and load data into Snowﬂake.
• Monitor data pipeline and ETL performance, identifying bottlenecks and making necessary adjustments to ensure optimal system performance.
• Perform troubleshooting and root cause analysis to resolve data issues and prevent future occurrences.
• Develop and implement data models within Snowﬂake to support business intelligence and analytics requirements.
• Collaborate with Data Leads, Product Managers and QA Engineers to validate requirements, participate in user requirement sessions.
• Perform tests and validate data ﬂows and prepare ETL processes according to business requirements.
• Perform ETL tuning and SQL tuning.
• Ability to document data ﬂows representing business logic in ETL routines.
• Design and implement data conversion strategy from legacy to new platforms.
• Perform design validation, reconciliation, and error handling in data load processes.
• Design and prepare technical speciﬁcations and guidelines including ER diagrams and related documents.

Senior Data Engineer