Title: Senior Snowflake Engineer
Location: Remote
Duration: 3 Month
Job Responsibilities:
7+ years in data engineering, data warehousing or analytics engineering with strong recent Snowflake delivery.
Advanced Snowflake SQL, layered transformations, query tuning and production troubleshooting.
Strong dimensional modeling implementation, including facts, dimensions, surrogate keys and SCD Type 2.
Experience with source-to-target mappings, complex business rules, incremental processing and reconciliation.
Hands-on data-quality checks, audit/control logging, error handling, Git, testing and deployment.
Healthcare payer/provider, MPI or member identity experience preferred.
Build and optimize Snowflake SQL transformations across staging, curated and conformed layers.
Implement tables, views and transformation logic from approved models and source-to-target mappings.
Develop restartable, testable and supportable processing with auditability and error handling.
Implement patient/member matching logic, crosswalks and exceptions for duplicate, unmatched or conflicting records.
Build SCD Type 2 history, member-month outputs and current-state models.
Implement payer attribution across payer/plan, provider networks, PCPs and clinics and preserve monthly history.
Reconcile modeled attribution to source rosters and retain discrepancies and unassigned members.
Automate row-count, null, datatype, referential-integrity and schema-drift checks.
Build audit, balance and control logging, metrics, alerting and reconciliation evidence.
Troubleshoot defects, maintain technical documentation and participate in reviews, planning and client demonstrations.
Datavail’s Data Management Services:
Datavail’s Data Management and Analytics practice is made up of experts who provide a variety of data services including initial consulting and development, designing and building complete data systems, as well as ongoing support and management of database, data warehouse, data lake, data integration, and virtualization and reporting environments. Datavail’s team is comprised of not just excellent BI & analytics consultants, but great people as well. Datavail’s data intelligence consultants are experienced, knowledgeable and certified in the best in breed BI and analytics software applications and technologies. We ascertain your business objectives, goals and requirements, assess your environment, and recommend the tools which best fit your unique situation. Our proven methodology can help your project succeed, regardless of stage. With the combination of a proven delivery model and top-notch experience ensures that Datavail will remain the Data Management experts on demand you desire. Datavail’s flexible and client focused services always add value to your organization.
...Atlantic Tire Distributors Has Openings!Job Title: General Warehouse Worker (Night Shift)We are seeking applicants to join our Atlantic... ...Company paid short term disability.Summary:Manually and using powered equipment, move tires and stock materials in to and out of racked...
...Cardiac Arrhythmia class Must be willing to travel between locations within the health system as needed. Minimum three years of EKG experience in the acute care setting Knowledge of complex cardiac arrhythmias Experience in recognition of arrhythmia...
...business. MWI Animal Health is a leading brand of Cencora, offering animal health services globally. The primary role of theWarehouse Manageris to manage theWarehouseSupervisors and their teams. The WarehouseManageris responsible for planning, coordinating, and...
...your hands! Equity grant awarded at end of year company grant cycle with participation in company annual stock program! As a District Manager , youre passionate about operational excellence, providing remarkable customer experiences and driving sales! You take pride...
...values you! Bring your talents to Ross, our leading off-price retail chain with over 2,200 stores, and a strong track record of... ...development for our teams. About this opportunity... The Fashion Assistant II supports the Director of the NY Fashion Office in...