Faiz Elahi

About Faiz Elahi

As the Data Analytics Engineer, I’m proud to be part of a team that’s transforming the landscape of data solutions. We’re dedicated to delivering top-notch services in:With expertise in AWS, Snowflake, PySpark, Python, Fivetran, Azure, DBT, Databricks, Power BI, Tableau, Looker, Stitch, GCP, Azure, SQL, Iceberg, Polars, Pandas, Sci-kit Learn, Koalas, NumPy, Airbyte, GKE, bigquery ML, Snowflake ML, Machine learning,Kubernetes, Dataproc, Analytics Lakehouse, Data Build Tool (dbt), GCS, Motherduck, DuckDB, Presto, Hive, Hudi, Apache Superset, Apache Flink, Apache Kafka, Beam, Spark Streaming, Delta Lake, Airflow, Prefect, Dagster, TensorFlow, PyTorch, MLflow, BigQuery, Redshift, Synapse Analytics, Azure Data Factory, AWS DynamoDB, Athena, S3, Redshift, EMR, GenAI, Chatbot, AI,Gemini, Prompt, ChatGPT, ElasticSearch, Redis, ClickHouse, Cassandra, MongoDB, Druid, Trino, and GraphQL, we bring unparalleled depth in enabling seamless data integration, real-time processing, advanced data modeling, and scalable analytics solutions.Our focus extends to leveraging data mesh architecture, deploying scalable microservices, optimizing ETL pipelines with advanced tools like Matillion and Talend, and adopting hybrid multi-cloud strategies for efficiency and agility. By integrating streaming technologies such as Apache Pulsar and Confluent Kafka, and implementing modern lakehouse paradigms, we deliver solutions that not only process high-volume data with precision but also transform them into actionable insights for predictive modeling, customer segmentation, anomaly detection, and operational intelligence.Whether it’s optimizing data lakes with Spark SQL, enhancing query performance with materialized views in Snowflake with cortex ai AI_REDACT, AI_PARSE_DOCUMENT, AI_CLASSIFY, and AI_SENTIMENT. Built RAG workflows with Cortex Search and AI_EMBED, enforced HIPAA-compliant RBAC via USE AI FUNCTIONS and SNOWFLAKE.CORTEX roles, deploying serverless architectures like Lambda functions on AWS, our proactive and innovation-driven methodology ensures that our clients consistently stay ahead in leveraging big data to achieve their most critical business objectives.If you’re looking to modernize your data platform with Snowflake, dbt, Fivetran HVR, Cortex AI, and advanced SQL/Python/R engineering, let’s connect and transform your data into scalable, governed insights.#DataSolutions #CloudComputing #BigData #DigitalTransformation #CustomSoftware #Innovation #Princetondatacompany

Experience

1. Ai Data Engineer

   City of Hope

   Apr 2025 — Present · Duarte, CA, US

   I work remotely from Princeton, NJ, leading SQL,Python, R Conversions to Snowflake migrations and building cloud-native data platforms across enterprise data pipelines.Enterprise Cloud Migration & API Integration: Led migrations of on-prem SQL Server (SSMS) systems to Snowflake. Built Python and R frameworks to convert complex T-SQL DDL/DML, resolve data type mappings, and refactor cursor-based logic into set-based CTE, MERGE, and window-function patterns. Implemented reconciliation and row-count validation to prevent data drift. Integrated APIs from Adminsure, ctca, HCM, taleo, centricity one, org publisher, and FirstUp to ingest workforce and operational data into Snowflake.Advanced dbt Engineering: Replaced SSIS with modular dbt Core pipelines using layered staging and mart models. Implemented incremental models, SCD Type 2 historization, snapshots, surrogate key macros, and source freshness tests. Engineered JSON flattening with LATERAL FLATTEN and recursive CTE hierarchies. Built star schemas for Power BI and Tableau, unifying data from virgin_pulse, smartscrubs, lyra health, Nation remit, protenus, and bluesight into governed domains.Real-Time CDC & Interoperability: Designed log-based CDC using Fivetran HVR with Direct Redo and Archive Log replication to bypass API limits and replicate source databases at the transaction-log level. Consolidated epic, clarity, caboodle, oracle health (cerner), meditech, AthenaOne Insights, Veradigm Health Insights, and eClinicalWorks Analytics/eBO into Snowflake. Built Snowpark pipelines to parse HL7, FHIR R4, DICOM, X12, and NCPDP.Snowflake Cortex AI Governance: Deployed HopeLLM API and Snowflake Cortex AI for in-warehouse LLM inference. Used AI_REDACT, AI_PARSE_DOCUMENT, AI_CLASSIFY, and AI_SENTIMENT for PHI masking and analytics. Built RAG workflows with Cortex Search and AI_EMBED, enforced HIPAA-compliant RBAC via USE AI FUNCTIONS and SNOWFLAKE.CORTEX roles, and implemented audit logging for secure AI governance.

Education

• Shanmugha Arts, Science, Technology & Reserch Academy (SASTRA), Thanjavur

  Master of Computer Applications - MCA, Information Technology

• NATIONAL INSTITUTE OF ELECTRONICS & INFORMATION TECHNOLOGY (NIELIT)

  Higher National Diploma, Big Data Analytics

• Jamia Hamdard

  Bachelor's degree, Information Technology